Results 1 to 4 of 4

Thread: Restore msdb

  1. #1
    Join Date
    Oct 2007
    Posts
    22

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Stop sql agent service then try again.

  3. #3
    Join Date
    Oct 2007
    Posts
    22
    Great.....
    Thanks rmiao
    it really works fine now

    thanks again

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •