April 1, 2008 at 10:15 am
I'm restoring a database on as 2005 server from a database backup from a 2000 server. I don't have any DTS packages or database diagrams to worry about. If I restore the database from the backup and then set the compatibility Level to SQL Server 2005.
Is this now a SQL Server 2005 database or do I have to run it through some type of Upgrade?
Thanks
April 1, 2008 at 10:19 am
Once you restore, the compatibility Level will be set to 90 by default.
How about logins? You will need to import logins as well.
April 1, 2008 at 10:21 am
My compatibility level was set to 2000 by default so I had to change it. I've imported the logins without any issues and my application is running fine with the database on the new SQL Server 2005 server.
April 1, 2008 at 10:33 am
**BUMP**
Is this now a SQL Server 2005 database or do I have to run it through some type of Upgrade?
April 1, 2008 at 11:29 am
Your database is now upgraded to Sql Server 2005 after the restore. No need to do any other upgrade except latest Service Packs if needed.
Also don't forget to update statistics for databases after the restore...
NJ
April 1, 2008 at 11:34 am
Thanks, that's what I needed to know.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply