Export (0) Print
Expand All

Copying Databases from SQL Server 6.5 or Earlier

When you install SQL Server 2005, any existing databases are automatically upgraded. To copy an upgraded database, you can use any of the copy methods supported for SQL Server 2005 databases. For more information, see Copying Databases to Other Servers.

If a database that was created by using SQL Server 6.5 or earlier has not been upgraded to SQL Server 2005, you can convert it to SQL Server 2005 by using one of the following methods:

ms177398.note(en-US,SQL.90).gifNote:
Database backups that were created by using SQL Server 6.5 or earlier are in an incompatible format and cannot be restored in SQL Server 2005.

For information on using a SQL Server 6.5 database on SQL Server 2005, see sp_dbcmptlevel (Transact-SQL).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft