Do the LOGICAL drives have to exist on the new server?
Is there an alternative restore I can initiate on a database of the new
server that does not have the old drives designated?

Sincerely, the Newbie!

=======================================================================================
RESTORE DATABASE AppErrorsProd
FROM "AppErrorsProd FULL backup" with
move 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\AppErrorsProd_Data.MDF'
to 'S:\Program Files\Microsoft SQL
Server\MSSQL\Data\AppErrorsProd_Data.MDF',
move 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\AppErrorsProd_log.LDF'
to 'S:\Program Files\Microsoft SQL
Server\MSSQL\Data\AppErrorsProd_Data.LDF',
recovery

ERROR
Server: Msg 3234, Level 16, State 2, Line 1
Logical file 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\AppErrorsProd_Data.MDF' is not part of database
'AppErrorsProd'. Use RESTORE FILELISTONLY to list the logical file names.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Jon Brewer
SunGard Availability Services
MidRange DBA Group
(856) 866-4018



Jon Brewer/Recovery/Recovery
04/26/2005 03:09 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
How do you restore to a new server with different drives?





I'm trying this for the first time with some issues.

What would be the restore syntax for a restore with a backup to a new
server with different drivesets?

Jon Brewer
SunGard Availability Services
MidRange DBA Group
(856) 866-4018

MS Sql Server LazyDBA home page