UNSOLVED

fborges1

updated

17 years ago

F

fborges1

13 Posts

0

733

July 14th, 2009 05:00

Backup transaction logs with Networker Module for Microsoft SQL

Hi all.

For incremental backup of Microsoft SQL can only be created when the SQL Server database options are properly configured. Where can I set this options on SQL Server? What paramenters need set?

Thank you,
Fernando
  • nsoto

    16 Posts

    247

    0

    Posted July 16th, 2009 17:00

    In order to be able to run incremental backups, SQL server requires the database being at "Full" recovery model (this is set to each database individually). You can refer to the SQL Server documentation for more information, but to make things easier for you, here's a Microsoft KB article that shows you how to set/change SQL recovery models:
    "Changing the Recovery Model of a Database":
    http://technet.microsoft.com/en-us/library/bb808756.aspx

    Make sure your SQL administrator is aware of any change done to the SQL server.