In my Instance Db engine Tuning Advisor is not opening. It's showing initialize MSDB for tuning error message. i have MSDB backup file i am using this cmd for Restore
RESTORE DATABASE [msdb]
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\msdb.Bak'
WITH REPLACE, FILE = 1, REPLACE, STATS = 10
error msg is:
Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
what is the problem....