• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

The restore of MASTER DB

Dear all,

right now we are builting up a new SQL 2005 server and will apply SP2 patch to it so that the master DB can be restore without any problem.

as the new hardware will be in different name, any problem on restoring the master DB you experienced before ?

restoring the msdb and model should not have any problem once the master DB is restored .

DBA100.
0
marrowyung
Asked:
marrowyung
  • 3
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I am not aware of any issues in regards to hardware for sql server restores.
0
 
Matt BowlerDB team leadCommented:
Not entirely sure that I've understood your question. If you apply service pack 2 to SQL Server you will increment the build number. You will not be able to restore a master database backup taken from a pre-SP2 instance. Only backups of master taken from an instance of the same build level will be able to be restored.

However you should be able to restore across different instances without problems, as long as user database files are in identical locations.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
marrowyungAuthor Commented:
MattSQL,

I just want to restore the master DB to a new server with different server name, I will install the same service pack, any other concern that make me can't restore the master DB?

Previous it seems taht there are problem when master DB restore to different machine as the SQL server name different !

any experience?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I had only once so far in my life to perform a master db restore, and indeed on another server name, but I had no issues during the restore.
0
 
marrowyungAuthor Commented:
ok ok .thansk. let wait for more input before I close.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now