What are the challenges you face when working across database platforms? Take the survey
Options

Supplying path on differential restore

PowerwayPowerway Posts: 29
edited May 31, 2007 9:27PM in SQL Backup Previous Versions
Let's say I restored a full backup from one server on another server. Put the database files in a different location. I left the database in recovering state.

I then go to restore a differential. Red-Gate does not let me change the paths of the log and data files like SQL Server does. Therefore I cannot restore the differential.

Or am I missing something?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Does SQL Server allow you to perform a differential restore and move (using the MOVE option) the database files to a new location at the same time? Could you pls provide a sample command to do this? Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.