Hello Every body
Please advise me the steps i am following are correct I need to improve some more...
I want upgrade from sql server 2000 to SQL Server 2008,
Plese confirm the steps
1.Setup Test SQL Server 2000 similar to Production SQLServer 2000.
2.Setup other server with SQL Server 2008.
3.Install the Upgrade advisor in SQL Server 2008 system
4.Select the Play back(under "sql server 2000 server") in Upgrade advisor tool and fill the SQL Server2000 Server name and authontication.
5.Click on Capture play back(take the all the backups run some top 10 queries or application on top of SQL server 2000)
6.Please in shared drive(whcih can access by the SQL Server 2008 server)
7.Now click the "setup the test server"
8.Now click the upgrade test server 2008..
9.camapre the trace files
10.View the Trace files differance.
some body help me and plese confirm those steps are correct...I am in right direction..SNIVAS
View Complete Post