Dear Eric:

For whatever it's worth to you, we've been using SQL Express 2005 for a DB of about 70 tables and 50 users. Table sizes up to a couple...

I finally figured out how to restore the DB under a new name by using SQL Server Management's Tasks option. Not very intuitive, is it.

Thanks for your help.

Now I get the error message "Incorrect syntax near '='" I assume the error is at the first instance:

'Records'='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Records', etc.

Question: Don't I want this archived, renamed...

The command

Restore filelistonly from disk='backupfile' gave me the logical file names "Records" and "Records_log"

Executing

Restore database Records2009 from disk='path+filename.bak' with move datafile_name='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Records', logfile_name='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Records_log'

continued...

The Backup command executed OK. However, the Restore command

Restore database Records2009 from disk='path+filename.bak' with move datafile_name='C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\Records2009', logfile_name='C:\Program Files]Microsoft SQL Server\MSSQL.2\MSSQL\Data\Records2009'

resulted in the error messages "Incorrrect syntax...