Post reply

Question about backups

  • February 18, 2009 at 10:48 am

    #218580

    Hello All,

    We have a production server which is being backed up using a 3rd party tool. I am trying to come up with a script to backup and restore the database using SQL so at some point we can retire the third part tool. I would like to test if my backup scripts are working correctly and if I am able to restore from the backup. With the third part tool we are doing a weekly full backup and an hourly log backup

    Now my question, if I run my script(they are jobs to create a weekly full, daily differential and a transaction log every 4 hours) will this affect the backup that is going on with the third party tool.

    Any one with any suggestion will be greatly appreciated,

    can 2 backup tools backup the same information into 2 different location without affecting each other.

    Thanks

    SK

  • February 18, 2009 at 10:56 am

    #946141

    shri_sastry (2/18/2009)

    Hello All,

    We have a production server which is being backed up using a 3rd party tool. I am trying to come up with a script to backup and restore the database using SQL so at some point we can retire the third part tool. I would like to test if my backup scripts are working correctly and if I am able to restore from the backup. With the third part tool we are doing a weekly full backup and an hourly log backup

    Now my question, if I run my script(they are jobs to create a weekly full, daily differential and a transaction log every 4 hours) will this affect the backup that is going on with the third party tool.

    Any one with any suggestion will be greatly appreciated,

    can 2 backup tools backup the same information into 2 different location without affecting each other.

    Thanks

    SK

    Testing your full and differential backups will not break you transaction log chain with your 3rd party tool, but running you t-log scripts will cause an issue with the log chain for the 3rd party tool.

  • February 18, 2009 at 11:14 am

    #946154

    Lyn,

    Thanks. So is there a way to test the transaction log backup of my script without affecting the 3rd party tool.

    Thanks

    Shri

  • February 18, 2009 at 11:19 am

    #946158

    Be sure to read BOL (Books Online), BACKUP LOG and BACKUP DATABASE. As you appear to be using SQL Server 2005, you could use the COPY_ONLY option but not sure if you could use it in a test restore.

  • February 18, 2009 at 12:21 pm

    #946211

    shri_sastry (2/18/2009)

    Hello All,

    I would like to test if my backup scripts are working correctly and if I am able to restore from the backup.

    Do you have a test/development server?

    Now my question, if I run my script(they are jobs to create a weekly full, daily differential and a transaction log every 4 hours) will this affect the backup that is going on with the third party tool.

    use COPY_ONLY option when backing up which will not disturb yout backup strategy

    can 2 backup tools backup the same information into 2 different location without affecting each other.

    I dont think you can do it because each tool be able to get exclusive locks on objects you are backing up. I am not sure though:D

Viewing 5 posts - 1 through 5 (of 5 total)

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