I am moving databases between SQL Server 2005 to SQL Server 2008
1.DBCC CHECKDB(DBNAME) on SQL Server 2005
2.Full backup of the Database and Restore into SQL Server 2008 with verify Optiom
3.Move the users
4.Run DBCC CHECKDB(DBANME) on SQL Server 2008
5.Run Re-idexing Job on SQL Server 2008
5.Run updatestatistic job
6.Sign off from installtion..
above I am going to follow is correct or I need to do some thing more.....
Please suggest me.
thanks in advance
View Complete Post