• Replies 6 replies
  • Subscribers 340 subscribers
  • Views 42 views
  • Users 0 members are here
Related

SQL Server Backup Question

Former Member
Former Member $organization

Back when our site was first installed (before my time), our production SQL Server was setup to be backed up using Symantec Backup Exec.  We run a weekly full backup, and nightly incremental backups.  The database was also configured to use the simple recovery model.

I'd like to change part of this - I want to move to the full recovery model and start doing SQL Server backups (and obviously transaction log backups).  I don't want to stop the Backup Exec backups (if it's not broken, don't fix it!).

Can I run both Backup Exec and SQL Server backups at the same time (with the database set to full recovery) without messing up the transaction log backups?

The research I've done implies I can, however I thought I'd ask the experts here.

Thanks in advance.

 -steve carlock

Santa Barbara Center for the Performing Arts/The Granada

 

Parents
  • Former Member
    Former Member $organization

    Absolutely that is exactly what we do.
    Naomi

    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Naomi Williams
    Sent: Wed Nov 04 16:32:02 2009
    Subject: [Tessitura Technical Forum] SQL Server Backup Question

    Back when our site was first installed (before my time), our production SQL Server was setup to be backed up using Symantec Backup Exec.  We run a weekly full backup, and nightly incremental backups.  The database was also configured to use the simple recovery model.

    I'd like to change part of this - I want to move to the full recovery model and start doing SQL Server backups (and obviously transaction log backups).  I don't want to stop the Backup Exec backups (if it's not broken, don't fix it!).

    Can I run both Backup Exec and SQL Server backups at the same time (with the database set to full recovery) without messing up the transaction log backups?

    The research I've done implies I can, however I thought I'd ask the experts here.

    Thanks in advance.

     -steve carlock

    Santa Barbara Center for the Performing Arts/The Granada

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • Former Member
    Former Member $organization

    Absolutely that is exactly what we do.
    Naomi

    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Naomi Williams
    Sent: Wed Nov 04 16:32:02 2009
    Subject: [Tessitura Technical Forum] SQL Server Backup Question

    Back when our site was first installed (before my time), our production SQL Server was setup to be backed up using Symantec Backup Exec.  We run a weekly full backup, and nightly incremental backups.  The database was also configured to use the simple recovery model.

    I'd like to change part of this - I want to move to the full recovery model and start doing SQL Server backups (and obviously transaction log backups).  I don't want to stop the Backup Exec backups (if it's not broken, don't fix it!).

    Can I run both Backup Exec and SQL Server backups at the same time (with the database set to full recovery) without messing up the transaction log backups?

    The research I've done implies I can, however I thought I'd ask the experts here.

    Thanks in advance.

     -steve carlock

    Santa Barbara Center for the Performing Arts/The Granada

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
  • $organization in reply to Former Member

    Steve -

     

    We do pretty much the same thing. Use SQL Backup to do a full backup nightly and then transactional logs at increments during the day. We script a copy of those backups and log files to our test server so we constantly have at least luke warm data over there. We use Backup Exec nightly to get the full backup file and save it in another location as well.

    I've successfully restored from this backup with no loss of data (but we were lucky, it died at night when there was little activity on the system).

    Good luck!

    Heather

    Seattle Rep

  • $organization in reply to Former Member

    Timing is everything. In our case, we run BUE full backups nightly and incremental trans logs every two hours. We then added SQL full backups and found this caused our incrementals to fail.

     

    What we found was if the BUE full was done PRIOR to the SQL full, the increment will fail with the error: “V-79-57344-33938: The Backup Exec SQL Agent was not used to create the last full backup of this database. You must use the SQL Agent to run a full backup before you run a differential backup or transaction log backup”

     

    By setting the SQL full to run first, then the BUE full to run AFTER the SQL, the trans logs run without fail.

     

    If the BUE full runs first and then the SQL full runs after the BUE full, the BUE trans logs will fail.

     

    At least – that is what occurred in our instance.

     

    Randy

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams
    Sent: Wednesday, November 04, 2009 3:42 PM
    To: Randall A. Mitchell
    Subject: Re: [Tessitura Technical Forum] SQL Server Backup Question

     

    Absolutely that is exactly what we do.
    Naomi

    From: Tessitura Technical Forum <forums-technical@tessituranetwork.com>
    To: Naomi Williams
    Sent: Wed Nov 04 16:32:02 2009
    Subject: [Tessitura Technical Forum] SQL Server Backup Question

    Back when our site was first installed (before my time), our production SQL Server was setup to be backed up using Symantec Backup Exec.  We run a weekly full backup, and nightly incremental backups.  The database was also configured to use the simple recovery model.

    I'd like to change part of this - I want to move to the full recovery model and start doing SQL Server backups (and obviously transaction log backups).  I don't want to stop the Backup Exec backups (if it's not broken, don't fix it!).

    Can I run both Backup Exec and SQL Server backups at the same time (with the database set to full recovery) without messing up the transaction log backups?

    The research I've done implies I can, however I thought I'd ask the experts here.

    Thanks in advance.

     -steve carlock

    Santa Barbara Center for the Performing Arts/The Granada

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!


    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!