April 1, 2010 at 4:33 am
I am having a SQl-2000 over a win-2003 SBS. Now I am having new server win-2008 & SQL-2008 standard.
Can I move my data base from SQL-2000 to SQL-2008. Is QL-2008 supports direct restoration of backup.
To do so shall I need to take any other preliminary steps
April 1, 2010 at 4:54 am
Hi,
It is very much similar to restoring to SQL 2005.
Restore the backup to SQL 2008 instance; Change the compatibility level; Change the procedures and other objects accordingly,Setting up logins etc.,
[font="Verdana"]Renuka__[/font]
April 1, 2010 at 7:06 am
It's best to use the Microsoft supplied tool, SQL Server 2008 Upgrade Advisor, to check to see if you have any compatibility issues before you do the restore. But, as described in the previous post, the restore itself is pretty straight forward. In addition to the above advice, I'd also suggest you plan to rebuild all statistics with a full scan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 2, 2010 at 4:26 am
Dear Ranuka,
Thank you for sharing your knowledge. In the men time I just want to get clarify about the
collation path for restoring the data base. As I had faced this problem of collation when I am moving
data from SQL-2005 to SQL-2008. So is there any such same problems with moving SQL-2000 to 2008.
Regards,
Balraj
Banglore
April 2, 2010 at 6:39 am
especially ensure the first thing you do after restoring or attaching the database to SQL Server 2008
is to run
DBCC UPDATEUSAGE
see the following link
http://msdn.microsoft.com/en-us/library/ms188414.aspx?ppud=4
you may have to leave the compatibility level at 80 it depends on the application using the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply