December 9, 2010 at 8:09 am
I was asked to create a FULL backup of all databases on one of our servers before we begin the upgrade process. After backing up all the databases include master I began wondering what the compatiblity level was on them. Our server is running SQL 9.0.3077 yet all the application databases are at level 80 while the system databases (master,tempdb,model,msdb) are at 90. Is this normal? What does this effect?
December 9, 2010 at 8:30 am
It means you can't use the new features in SQL Server 2005 on any of those databases. This includes keywords such as ROW_NUMBER, and the dynamic management views.
John
December 9, 2010 at 8:55 am
Ah so would that explain why I could only run my 2000 script to get the backup information on it.
Does this have any effect when performing a restore? For example can i restore a level 90 to an 80 but not an 80 to a 90?
December 9, 2010 at 8:58 am
Wrong way round. You can restore a SQL Server 2000 database to SQL Server 2005, but as far as I know, you can't restore a SQL Server 2005 database to SQL Server 2000.
John
December 9, 2010 at 9:14 am
To add to John's reply, you definetely cannot restore a 205 database to a 2000 server.
Gethyn Elliswww.gethynellis.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply