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]

MS Sql Server LazyDBA home page