-
Restore msdb
Dear sir,
using : SQL Server 2000
there is no user logged in , i am the only user and not using msdb anyway
i am trying to restore msdb database;
RESTORE DATABASE msdb
FROM DISK = 'D:\MSSQL\BACKUP\msdb.bak'
WITH RECOVERY, Replace,
MOVE 'msdbdata' TO 'C:\MSSQL\data\msdbdata.mdf',
MOVE 'msdblog' TO 'C:\MSSQL\data\msdblog.ldf'
i get this error:
Server: Msg 3101, Level 16, State 2, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
kindly help me out
-
Stop sql agent service then try again.
-
Great.....
Thanks rmiao
it really works fine now
thanks again
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|