Post reply

How do I restore the complete SQL-Server 2005 Default Instance?

  • August 14, 2008 at 5:44 am

    #189334

    Yetserday the complete default-instance of a SQL-Server 2005 was deinstalled. I have backups of all databases including the backup of the msdb and the master DB. I also have the data and logfiles of all userdatabases, but not of the master DB.

    I've tried to reinstall the default instance and servicepack 2. Then I've started the sql-server in single user mode and tried to restore the master DB. Then I got the message:

    Msg 3154, Level 16, State 4, Line 1

    The backup set holds a backup of a database other than the existing 'Master' database.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    What can I do to recover the whole default instance?

    Roland

  • August 14, 2008 at 6:30 am

    #857991

    Hi,

    I've found the mistake... I have to use the "with replace" switch wilth the restore statement.

    Complete:

    RESTORE DATABASE Master FROM disk=N'F:\MSSQL2005\Backup\masterDumpDat.bak' with replace

    Roland

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply