restore master problem

• acko

  Right there with Babe

  Points: 754

  More actions

  December 16, 2005 at 6:24 am

  #152672

  Hi

  How can i restore master database if i have backup before service pack instaled.

  Situation:

  1. backup master

  2. instal service pack

  3. problem happened, i have to restore master

  4. i do not have backup after instaling sp

  5. when i try to restore from last backup get following msg

  

  Thanks a lot

  acko

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  December 16, 2005 at 7:11 am

  #610041

  • 1. Uninstall SQL Server
  • 2. Install SQL Server to the version that it was when the backup was taken
  • 3. Restore the backup
  • 4. Apply the service pack

  The reason you must do it in this order is:

  PRB: You cannot restore system database backups to a different build of SQL Server (264474)

  K. Brian Kelley
  @kbriankelley

• acko

  Right there with Babe

  Points: 754

  More actions

  December 16, 2005 at 7:23 am

  #610047

  thanks a lot

  acko