ENHANCEMENT REQUEST: Customer request that restore task performed on the MSDB place the MSDB data
Description: Customer didn't click "kill all connections" while setting up a restore task on the MSDB database. When restore was ran customer got the error message "RESTORE DATABASE is terminating abnormally. Exclusive access could not be obtained because the database is in use."
Steps to Reproduce: 1. Open the Litespeed console. 2. Start the backup wizard. 3. Make a abckup of the MSDB database. 4. Start the restore wizard. 5. On the specify restore designation page do not choose "kill all current connections before restore". 6. Complete the restore wizard and run the restore. 7. Click to preview script. 8. Note" Kill all current connections" option is not included.
Actual Results: Database restore will fail if customer doesn't choose to kill all current connections.
Expected Results: All current connections are killed by default without user intervention.
Build Version and Platform:126.96.36.1993 Windows 2003 SQL 2005.
WORKAROUND: Select "Kill all user connections" from GUI, or include cmmand with tsql script to restore msdb
STATUS: This enhancement has been submitted to Development for consideration in a future version of LiteSpeed.