General discussion

Locked

Microsoft SQL Server 7.0 Restore Problem

By jblaylock ·
I currently am running NT 4.0 with SQL 7.0 running on it. I have been given
the task of migrating our servers to Windows 2000. I have installed Windows
2000 Server and subsequently installed SQL 7.0. I have moved over my .BAK
files from where I backup the SQL databases every night but I continually
get errors while trying to restore my databases to the new Windows 2000
server. Can anyone give me some assistance as to what path I can follow or
maybe a URL for me to visit that better explains how I can restore these
databases to this new server with LESS problems. Thanks in advance.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Microsoft SQL Server 7.0 Restore Problem

by Joseph Moore In reply to Microsoft SQL Server 7.0 ...

I tried this (backup a 7.0 database and restoring it onto 2000 SQL) and got SQL error 42000, whick talked about using the WITH MOVE SQL-DMO command to do this.
From what I can find, you can't do this in Enterprise Manager. You have to do it in Query Analyzier.
So, first make an empty database with the same name as the SQL 7 database. Try to do the restore into this empty database.
Technet article Q221465 talks about using With Move with the Restore command.
And then download the SQL Books Online and look up Restore T-SQL for the right syntax:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Hope this helps.

Collapse -

Microsoft SQL Server 7.0 Restore Problem

by jblaylock In reply to Microsoft SQL Server 7.0 ...

Poster rated this answer

Collapse -

Microsoft SQL Server 7.0 Restore Problem

by jblaylock In reply to Microsoft SQL Server 7.0 ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums