August 23, 2011 at 5:00 pm
Hi all
Need help in steps and scripts to be run and taken, wile migrating from sql 2000 to sql 2008 and also what modes to be put in and after we restore the data base how to keep the database upto date, like have to use log shipping or any other method.
Thanks for stoping by
August 23, 2011 at 5:16 pm
Hi
We are actualy migrating not upgradong and i dont have a clue what are best practices
Thank you
August 23, 2011 at 5:22 pm
Are you upgrading to SQL Server 2008 R2?
Upgrade SQL Server 2000 to 2008 R2
http://msdn.microsoft.com/en-us/library/ms144267.aspx
Upgrade SQL Server 2000 Log Shipping to SQL Server 2008
http://technet.microsoft.com/en-us/magazine/dd450972.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 23, 2011 at 5:34 pm
Hi
Yes we are migrating to r2
Thank you
August 23, 2011 at 5:43 pm
Did you get a chance to read the links?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 23, 2011 at 5:55 pm
Hi
No but i came across a lot of articles i couldent pick one, but i will go through yours too.
Thank you
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply