Script to backup transaction log

Question

Script to backup transaction log

sntiwary

Hall of Fame

Points: 3475
More actions
February 7, 2004 at 1:43 pm

#84150

How to write a Script to backup the transaction log each hour for some databases in a server and keep the backup files of 1 week old ?.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Take a look at BACKUP in BOL. I bet you also find scripts here in the script section

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Probably the most easy way is to use the database maintenance plan wizard from inside EM. It allows you to specify how often to backup, what to backup and how long to keep...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

HeziDog SSC Eights! Points: 982 More actions · Answer 3

Or just check out this article/script and schedule it as a job that runs every hour ... http://www.sqlservercentral.com/scripts/contributions/829.asp