Return
-
Title
ERROR: RESTORE cannot process database 'databasename' because it is in use by this session. -
Description
restore fails if database being restored is default database for user attempting restore - ERROR: RESTORE cannot process database databasename because it is in use by this session. It is recommended that the master database be used when performing this operation.
Steps to Reproduce: create database TEST, create user APRIL, for user APRIL, make TEST the default DB. backup the DB, then attempt a restore, should fail with error above
Actual Results: LiteSpeed does not internally change the connection context away from the default database (which is the restore target), causing restore to fail
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.