Post reply

Microsoft Shadow Copy - How to Use It

  • June 27, 2005 at 8:56 am

    #109554

    We are looking at using Mocrosoft Shadow Copy with Hitachi Quick Shadow to backup and restore SQL Server Databases.  Does anyone have any experience with it they like to share?

    I believe backing up and restoring a database should be simple.  But can I apply transaction log backups to a specific time?  How do I get the database into Load Pending so I can apply them?

    Are shadow copy backups recorded by SQL Server?

    David Bird

  • June 30, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 1, 2005 at 1:39 am

    #570247

    Hi David,

    I don't know anything about Shadow Copy, but I would recommend you use a native SQL Server backup or something that is supported like SQL LiteSpeed. 

    I've had people try to Ghost SQL Server databases with dire consequences  and also SAN snapshots don't seem to be that flash in my experience.

    I would assume that if you do a backup with Shawdow Copy you would not be able to apply transaction log backups as SQL Server would not be able to match both backup sets.

    Just my thoughts...

    Angela

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply