Unanswered: restore a sql server 6.5 db to sql server 2000
for disastor recovery purposes i have a user request to restore a sql server 6.5 base backup(.dat file) into sql server 7.0 or 2000. can this be done in a restore on a different server?? all servers are windows 2000
Note: To run the SQL Server Upgrade Wizard, you must have an instance of SQL Server 2000 already installed on your computer.
1. On the Start menu, point to Programs/Microsoft SQL Server-Switch, click SQL Server Upgrade Wizard, and then click Next.
2. Select Named pipe; then click Next.
3. In Export server (6.5), in the Server name box, enter the name of the local or remote computer on which SQL Server 6.5 resides.
4. In the Administrator password ('sa') box, enter the sa password for SQL Server 6.5, and then click Next.
Note: Unless you have changed it, the system administrator (sa) password for SQL Server 2000 is blank.
5. Include the databases to upgrade. Move any database not to include in the disk space estimation to the Exclude list, and then click Next.
6. Select Use the default configuration or edit the default; then click Edit.
The SQL Server Upgrade Wizard layout utility appears, showing the proposed layout of the SQL Server 2000 data files.
7. Click Advanced.
8. Click an object in the Proposed database layout box to view details in the Object details box.
9. The Drive summary box shows the estimated size of all SQL Server 2000 data files and the free disk space left on all of the local fixed disks. On the Options menu, select Freespace includes 6.5 files to view the free space that would exist if the SQL Server 6.5 data files were deleted.
10. Click Accept to return to the Database Creation dialog box.
11. Click Cancel to quit the SQL Server Upgrade Wizard.