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

Responses(1)

nsoto

16 Posts

0

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.

View All

No Events found!

NetWorker

Backup transaction logs with Networker Module for Microsoft SQL