January 13, 2010 at 6:06 am
I have been tasked with migrating our sql servers
to new hardware, about 6 of them are standard 2005
servers that have publications that are subscribed
to from the main 'reporting' server. All of these are
moving to new hardware (all to internal disks as we
do not have san storage). I plan to sequence it as
follows: 1 - Get the main 'reporting' machine up and
running first, and start subscribing to the existing
publications from live servers
2 - Restore the most recent backup of the live servers
to the new hardware then get the developers to change
the connection strings on the webservers to start
writing data to the new servers.
The question I have of all the seasoned pro's out there
is, do you think this is the best sequence? And what
'catches' or 'gotchas!' should I watch out for?
Many thanks all
voltron
January 13, 2010 at 6:18 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic846818-361-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2010 at 6:56 am
Ok sorry about that. Should I remove the other one?
January 13, 2010 at 7:45 am
Threads can't be deleted. That's why I put the redirection in here and the request for no more replies. Just leave this thread alone and people can answer in the other one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply