SQL Server 2005 Master database Restore to a Different Server

Question

SQL Server 2005 Master database Restore to a Different Server

Viewing 6 posts - 31 through 35 (of 35 total)

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

rosejr Grasshopper Points: 16 More actions · Answer 1

Ok, so follow Duncan's steps to avoid the same instance conflict, then run these sp's to address the duplicate server on the network?

Thanks for your help.

Michael-401546 Mr or Mrs. 500 Points: 557 More actions · Answer 2

Hey All,

My task and your mission if you choose to accept it is... Move a named instance (all databases, jobs and users) from a standalone server to a cluster. I will need to change the server name, instance name, drive letters and instance number (MSSQL.*) in the process (THIS IS NOT MY IDEA, Pointy haired boss has nothing better to do). Is there a KB that goes through the steps or should I follow the steps above.

Thanks

LostFromTheStart

nishant-434966 Newbie Points: 9 More actions · Answer 3

As master holds information for other system databases, bringing one from other server, its not able to find msdb/tempdb ( as they point to location on source server)

Meet George Jetson SSChampion Points: 11626 More actions · Answer 4

Two plus year old post.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

actually its only a year old, but hey there's nothing like resurrecting the dead 😀

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

vikingDBA SSCertifiable Points: 5356 More actions · Answer 6

It almost sounds like the backup file set contains multiple backups. Might have to use the FILE= clause of the restore command to specify the one that is to be restored.