Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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).

Community Additions

ADD
Show:
© 2015 Microsoft