Does Microsoft support Database Compatibility Level to be 80 in SQL Server 2008?
www.myTechMantra.com Welcome, Guest. Please login or register.
December 22, 2014, 12:21:47 pm
Home Help Search Login Register
News: MyTechMantra.com - Latest Microsoft SQL Server Forums

+  Latest SQL Server Forums, BizTalk Server Forums and Sharepoint Server Forums - MyTechMantra.com
|-+  SQL Server 2008 Forums
| |-+  SQL Server 2008 Performance Tuning for Hardware
| | |-+  Does Microsoft support Database Compatibility Level to be 80 in SQL Server 2008?
« previous next »
Pages: [1] Print
Author Topic: Does Microsoft support Database Compatibility Level to be 80 in SQL Server 2008?  (Read 3306 times)
Amit
Newbie
*

Karma: +0/-0
Posts: 23


« on: March 08, 2009, 11:10:05 pm »

Does Microsoft support Database Compatibility Level to be 80 in SQL Server 2008?
Logged
ankit
Guest
« Reply #1 on: March 08, 2009, 11:17:18 pm »

Yes, it is truly supported.
You can restore SQL Server 2000 database to SQL Server 2005 or SQL Server 2008 and it is very much supported by Microsoft. However you need to keep this in mind that once the database from SQL 2000 is restored to SQL Server 2005 and later versions, then you cannot take the back up from SQL Server 2005 or SQL Server 2008 and restore it to a lower version SQL Server. This is not supported feature. One option in such scenario will be to DTS the data to SQL Server 2000.
Logged
Pages: [1] Print 
« previous next »
Jump to:  


Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 1.1.12 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!