none
Differential Backup and Restore along with Log Shipping RRS feed

  • Question

  • Hello

    I have a database with 2 filegroups and 3 data files. I have been using Log Shipping to take the backups of transactional logs to backup severs. 

    I have the Full backup file that i used to restore the database (in restoring mode) on the backup servers. Log Ship files are applied to this database.

    Today i wanted to test something. So i Restored the Full backup on the backup server in Restoring mode. Then i took a differential backup on the Live database server and moved to backup Server. When i tried to restore the differential backup, i get error. Error is this....

     

    The file 'production_archive' cannot be moved by this RESTORE operation. 

     


    Could you please let me know what i am missing here? Any help here would be appreciated.

     

    Thank You

     

    Kashif

    Wednesday, March 9, 2011 3:45 AM

All replies

  • Hi Kashif,

    I guess you are trying to give with move option when you are restoring differential backup . You cannot specify location when you are applying differential restore .

    If this is not the case then please post the restore command .

    -------------------------------
    Thanks,Suhas V
    Wednesday, March 9, 2011 5:51 AM
  • So copy-paste DIFF.bak and try to restore, right? Have you used MOVE option within a RESTORE?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, March 9, 2011 7:54 AM
  • I was just using the Management Studio and not using any query to do this.

     

     

    Wednesday, March 9, 2011 4:04 PM
  • I was just using the Management Studio and not using any query to do this.
    Wednesday, March 9, 2011 4:05 PM