Re: Restoring Master and msdb databases

Also, note that you need to stop the SQL Server Agent service when restoring the MSDB database

"Ed Reber" <EdReber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:20B87E65-53B5-4AD2-A5EE-3B11747B590B@xxxxxxxxxxxxxxxx
Thank you for your help Russell, The last link is what I needed.

"Russell Fields" wrote:

Ed,

The SQL Server needs to be in Single-User mode, not just the master
database.
http://technet.microsoft.com/en-us/library/ms175535.aspx

Also, an older note: http://www.mssqlcity.com/FAQ/BackRest/ResMaster.htm

RLF

"Ed Reber" <EdReber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:32DDCAC0-ED48-485F-8FB0-A2694A72DA90@xxxxxxxxxxxxxxxx
>I was able to restore the msdb db by putting it into single user mode. I >am
> stioll having a problem restoring the master db.
>
> Thanks,
>
> "Ed Reber" wrote:
>
>> I installed Microsoft SQL Server 2005 at our DR Site. I would like to >> use
>> our
>> master and madb databases from our site here at DR. I backed up the
>> databases, but am having problems restoring them at our DR Site. When >> I
>> try
>> to restore the master db, I get the error that it needs to be opened >> in
>> single server mode. When I try to put the master db in single >> usermode, I
>> get
>> the error that single user cannot be set in database mnater. When I >> try
>> to
>> restore the msdb db, I receive the fiollowing error: Exclusive access
>> could
>> not be obtained because the database is in use.
>>
>> I know that other people have to have done this before. Can someone >> point
>> me
>> to the right link or advise on how to do this?
>>
>> Thanks,



.

Relevant Pages

  • XPe SQL Database Backup/Restore
    ... This is a general FYI to anyone having difficulty with restoring the XP ... Embedded Component Database. ... Microsoft SQL Server Management Studio Express ...
    (microsoft.public.windowsxp.embedded)
  • Re: Strategy for backup and restore
    ... > while restoring) cannot do. ... please do your self a favour and correctly backup databases using SQL Server ... that's to say BACKUP DATABASE ...
    (microsoft.public.sqlserver.msde)
  • Re: restore to another server of db with FT catalogs
    ... it is best to re-create the small FT Catalogs via normal procedures on ... successfully restoring a FT-enabled SQL Server 2000 ... existing database or are you restoring the database as a new database on the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FK Relation
    ... >Yes the detail table has cascading delete too(at database level). ... >I use to connect ADO and OLEDB provider for sql server. ... Do you have any triggers on the Master table that update the master based on ... Borland's ADO components use all the fields in the record's selected fields to ...
    (borland.public.delphi.database.ado)
  • New Login Question
    ... I have been programming with Sql Server 2000 for 2-3 years ... I noticed that at the bottom of the New login dialog there ... One selects a database to log in to ... dropdown always has master listed. ...
    (microsoft.public.sqlserver.security)