Discussion Locked

Microsoft SQL Server 7.0 Restore Problem

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by joseph moore

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.

This discussion is closed to new replies.