April 30, 2010 at 2:49 pm
Hello Guru,
I wanted to setup transaction log backup in my SQL Server 2008 so that I will have:
•Database_Log_1.trn
•Database_log_2.trn
•Database_log_3.trn
Can any help and advice?
Thanks,
Edwin
April 30, 2010 at 7:22 pm
You're in the 2005 forum, but I don't think that matters in this case, but some of us have not used 2008 so we might give the wrong answer if there is a difference.
You could create a maintenance plan, which can create a separate file with each backup, then delete old backups after x # of days.
(I'm no guru, just another person trying to learn SQL)
April 30, 2010 at 9:09 pm
If you need a specific format for the file - then you have to create your own procedure/code that generates the file name and backs up the database/transaction log.
The default naming in maintenance plans uses a date stamp on the file name - which I prefer because then you can see very easily the order of the files for restoring.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 3, 2010 at 6:52 am
Just remember that you have to have FULL backups in place first in order to support log backups.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2010 at 7:02 am
Lots of scripts here for you: http://www.sqlservercentral.com/Search/?q=backup+log&t=s
May 3, 2010 at 9:36 am
Hi Steve and all,
I 'm very appreciated your help and advice.
Best regards,
Edwin
January 5, 2012 at 10:14 pm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply