Backup of the T- logs

Question

Post reply

Backup of the T- logs

sandhyarao49

SSCrazy

Points: 2215
More actions
April 30, 2010 at 8:02 am

#222076

Hi,
I’m creating a maintenance plan to backup the T-logs of a particular Db in sql server 2008 Standard edition.
In the options only overwrite and append exists.
My requirement is to backup the T-log’s for every 15 mins and want the T- logs to be in the specified folder with the timestamps.(for every 15 mins)
Can anyone suggest me how to perform this task.
Regards,
Sandhya

Viewing 6 posts - 1 through 5 (of 5 total)

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

sandhyarao49 SSCrazy Points: 2215 More actions · Answer 1

Hi,

My exact question is how i make each log file to it's own, new file.

GregoryF SSCertifiable Points: 6296 More actions · Answer 2

The maintenance plan adds a unique time stamp to each T-Log dump in the file name

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

sandhyarao49 SSCrazy Points: 2215 More actions · Answer 3

Hi,

I tried , but it is appending to the existing logs.

Attcahed the screen shot.

Kindly let me know where to change the option.

MannySingh SSChampion Points: 12465 More actions · Answer 4

Do not use the "Backup Database across one or more file" no no

Select the databases you require trans log for:

check the radio button for "Create a Backup File for every database"

then check "Create a sub directory for each database"

then check "Verify database integrity"

choose a folder where you want to store the Trans Files. If the extension is not present..

Maninder
www.dbanation.com

SQL Dev-938873 Ten Centuries Points: 1280 More actions · Answer 5

Hi ,

I have configured the Maintenance Plan for T-Log Backup for every 2 minutes for a specific database( We can set multiple databases ).All T-logs are saved as individual files with the timestamps.

You can find the attached screenshots for the Maintenance plan Configuration for T-log and the file structure of all T-Logs.

I have tested it in SQL Server 2008.

Thanks & Regards

GaNeSH Kotagiri

GaNeSH