Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

SQL Server 2005 Master database Restore to a Different Server Expand / Collapse
Author
Message
Posted Wednesday, September 30, 2009 3:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 19, 2014 1:28 PM
Points: 2, Visits: 43
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.
Post #796059
Posted Wednesday, March 10, 2010 7:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 27, 2014 9:39 AM
Points: 12, Visits: 295
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
Post #880239
Posted Wednesday, September 28, 2011 1:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 2:52 PM
Points: 1, Visits: 369
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)
Post #1182770
Posted Wednesday, September 28, 2011 2:03 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:38 AM
Points: 1,787, Visits: 1,325
Two plus year old post.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Post #1182805
Posted Thursday, September 29, 2011 8:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:54 AM
Points: 6,414, Visits: 13,796
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"
Post #1183220
Posted Thursday, September 29, 2011 2:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:35 PM
Points: 191, Visits: 898
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.

Post #1183456
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse