Forum Discussion

KristjanS's avatar
KristjanS
Level 2
13 years ago

MS SQL 2005 Full and Log backups at the same time.

Hello, Im in the process of testing and implementing the Netbackup 7.1 Enterprise solution in our enviroement. Specifically for backing up MS SQL 2005 databases. Some of the databases require onl...
7.1.x and Earlier
Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
SQL
Windows
  • Mark_Solutions's avatar
    Mark_Solutions
    13 years ago

    NetBackup supports a single operation at any one time

    You need to schedule your backups so logs stop running when the full backup runs and do not resume until that has completed.

    You also need to ensure that your SQL does not have a logs maintenance setup as if that ran during the day then all subsequent NetBackup logs backups would fail until after the next Full backup.

    What you want is fine and many people do it, you just need to schedule it carefully

    The minimum frequency of a job by default is 1 hour so if you need 15 minute scheduling you need to use a workaround - I will try and dig the link out for you

    Hope this helps

Mark_Solutions's avatar
Mark_Solutions
Level 6
13 years ago

I dont believe you can run both at the same time

There are retry options that can be added to the scripts but that may not be a great help

You could use snapshots during which the database backup would snapshot the database almost instantly and then back up the snapshot so that should not interferr with the logs backups (haven't actually tried this)

Or you can use SQL to dump the transaction logs and back up those dumps every 15 minutes so that again it does not interferr with NetBackup

By default I dont think it will do what you want without errors but I am sure someone else will provide ,ore information or confirm what I am saying