Can't restore SQL7 from LiveDB to TestDB

[kluca]

We're trying to set up a test environment and want to copy our live database to to test.
QUESTION:
How do I get a backup from 1 server to show up as a restorable DB on another server.
WHAT I'VE DONE:
We're using MSSQL 7

Using Server Enterprise Manager(SEM) on the Live Server
Right click on Databases
All Tasks
Backup
Database complete
Moved the backup file to the Test Server
Using SEM on the Test Server
All Tasks
Restore
Restore as Database - e.g., newdb
Parameters - show backups of database - e.g., livedb
Nothing shows up even if I create a DB that matches the live DB name.

 

[tlbroadbent]

The list of backups comes from the backup tables on msdb. Moving the backup files to the new server doesn't update the tables.

You will need to Restore: From device. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[kluca]

Thanks for the response.
Does restoring from device mean that the backup must be to device or can I restore from device using the database complete backup?

 

[tlbroadbent]

Backups are always done to a "device" or file. You can always select the "device" or file you want to restore from without using the backup list in Enterprise Manager. You just need to select the full backup file as the "device". Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.