March 17, 2009 at 8:47 am
I have a SQL Server2005 SP2 'A'.Due to performance issues i want to move/replicate the same to Second Server 'B'.
How can i move the stystem databases?
Can i restore master DB directly to new one?//How do i change the name 'A' which is stored in master DB A while i restore it to B.
Thanks,
Arun
March 17, 2009 at 9:09 am
You don't want to move system databases from one server to another. You may want to move data from the system databases on one server to the other server, but if you copy the system databases from one to the other, you're more likely to break something than not.
What makes you want to move system databases? Is there something specific that you need replicated on B that's on A?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 17, 2009 at 11:39 am
Backup and Restore
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
March 17, 2009 at 2:15 pm
aomanakkuttan (3/17/2009)
I have a SQL Server2005 SP2 'A'.Due to performance issues i want to move/replicate the same to Second Server 'B'.How can i move the stystem databases?
Can i restore master DB directly to new one?//How do i change the name 'A' which is stored in master DB A while i restore it to B.
Thanks,
Arun
Microsoft has got a good article on this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply