Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The General tab of the Log Shipping Policy wizard Wizard allows you to specify the basic properties of the log shipping policy.

...

  • Create Backup and Restore Jobs using the SQL Server Agent.
  • Create Backup and Restore Jobs using the SQL Safe Backup Agent.

How does SQL Safe determine that a log shipping policy is okay?

...

  • Whether the transaction log backup on the primary database has completed on schedule.
  • Whether the transaction log restore on the secondary database has completed without warnings or errors.
  • Whether the data on the secondary database is stable.

How do you control when a log shipping policy is compliant?

...

  • Select a time limit for the log backup to occur. This is the leeway time allowed for the log backup to occur. If the log backup occurs within this period from the scheduled time, the policy is still compliant.
  • Select an age limit for the secondary's data. This is the tolerance level for how old the data in the secondary database can be.

Once you define some policy settings, click 

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...

NEXT to select the primary database.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...