Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smith7255
Starting Member
5 Posts |
 Posted - 2007-01-05 : 10:50:53
|
| Is it possible to backup a database on SQL Server 6.5 and restore it to a database on SQL Server 2000? The application does not support 2000, but the data is only for historical purposes. I can create a front end from something else. I don't have the space to upgrade to SQL 2000 on the current server. Will I have to upgrade before I can restore it to another server with SQL 2000? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-01-05 : 11:29:06
|
| You cannot restore a SQL Server 6.5 backup to SQL Server 2000.You can use DTS to transfer the data from a 6.5 database to a SQL Server 2000 database.CODO ERGO SUM |
 |
|
|
smith7255
Starting Member
5 Posts |
Posted - 2007-01-05 : 11:56:21
|
| Oh! That shouldn't be too much of a problem. Thank you! |
|
|
|
|
|
|
Restore from 6.5 to 2000