March 23, 2008 at 9:30 pm
I made a backup of my production 2000 database and restored under sql 2005. The newly restored database compatability mode is 2005.
Do i need to perform any other task on the newly restored database? Will all the new functionality of 2005 be supported on my restored database?
March 23, 2008 at 10:59 pm
Update statistics, etc. Check this link and see whether need to apply to your case.
http://msdn2.microsoft.com/en-us/library/ms144267.aspx
"After upgrading the Database Engine to SQL Server 2005, complete the following tasks:"
March 23, 2008 at 11:56 pm
Vivien has provided a good link. Go thru that and also you can check:
🙂
March 24, 2008 at 12:21 am
thanks for the feedback.
March 24, 2008 at 1:00 am
You are welcome. 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply