Too lazy for BOL !

Use RESTORE FILELISTONLY to get the logical names of the devices...
Like so... then change me DB_Data, DB_Log to match yours...
Change drives to yours


-- RESTORE FILELISTONLY FROM DISK='\\sqlbackup\sqlbackup\adhoc\DB.bak'
RESTORE DATABASE [DB] FROM DISK='\\sqlbackup\sqlbackup\adhoc\DB.bak'
WITH
MOVE 'DB_Data' TO 'D:\MSSQL\DATA\DB_DATA.mdf',
MOVE 'DB_Log' TO 'D:\MSSQL\Log\DB_LOG.ldf',
RECOVERY

-----Original Message-----
From: Paul Schlieper
[mailto:mssqldba-ezmlmshield-x525046.[Email address protected]
Sent: Tuesday, April 26, 2005 3:15 PM
To: LazyDBA Discussion
Subject: RE: How do you restore to a new server with different drives?
Importance: Low

See RESTORE DATABASE, and specifically the WITH MOVE option, in BOL.

P


-----Original Message-----
From: Jon
[mailto:mssqldba-ezmlmshield-x78453010.[Email address protected]
Sent: Tuesday, April 26, 2005 3:10 PM
To: LazyDBA Discussion
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


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page