Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hourly backups of SQL

Status
Not open for further replies.

kobus7102

Technical User
Jun 30, 2011
8
NL
Hi

I need help in scheduling backups for SQL to run hourly, but only until 20:00, then my daily backup runs. This runs for a few hours which has the hourly backups queuing, which sometimes doesn't work to well and ends up hanging. I would thus like my hourly backups to start at 06:00 and the last to run at 21:00 not running on Sundays either when my full backups run.

Any help please.
 
The NW group resource only allows to shrink the default interval (24:00 hrs).

For your solution you must use a crontab /task scheduler for more variety.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top