sql server mseq: Hi ..

I have upgrade my Server from SQL 7 to SQL 2000.
I have done a backup for the SQL 7.

How do i use the backup files ( *.dat ) from the SQL 7
to restore it at the new Server 2000?
I have encounter error of different file id.

Is there a way to recovery back from the backup files?

Really appreciate yr help ..

Just create your database, restore the database from device and add the
backup file. What you might have to do is click on the second tab ( I think
it is advanced) of the restore window, check force restore over existing
database, and alter the file and path names below to match the path of the
existing database. SQL 2000 definitely restores SQL 7 backups.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]

Use the RESTORE syntax.

Something like.....

RESTORE DATABASE myDB
FROM disk = 'c:\Mybackup.bak'
WITH MOVE 'myLogicalData' TO 'c:\mydatafile.mdf',
MOVE 'My_log' TO 'c:\myLog.ldf'
GO

--------> You can get the names of the Logical files of the backup by doing
a VERIFYFILELISTONLY from the backup.

Thanks,
Vikram

Vikram Jayaram
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.