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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to backup SQL Transaction logs every 30 min.

Status
Not open for further replies.

jaspreet101

IS-IT--Management
Apr 22, 2005
19
0
0
US
Hello,

How can i backup my sql transaction logs every 30 mins.Wht all i have to configure.

Thanks
 
You set up your backup client just as the one that does the full backup of SQL. What you need to change is the backup level. That needs to be set to incremental to only backup the transaction logs. To actually having the backup start every thirty minute, you will have to create a new group and set the interval to 00:30.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top