Backup Transaction Logs on all Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Wesley Brown » Backup Transaction Logs on all Databases

Backup Transaction Logs on all Databases

Rate Topic

Display Mode

Topic Options

Author

Message

Wesley Brown

Posted Saturday, September 29, 2007 3:31 PM

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379

Comments posted to this topic are about the item Backup Transaction Logs on all Databases

http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org

Post #404481

abmore

Posted Tuesday, July 15, 2008 10:42 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:06 AM
Points: 1,134, Visits: 818

How could we recover the database if my transaction log gets corrupted / anything will happ.

Suppose I have FullBackup say, Full1.bak
after this i have taken the differential backup say, diff1.bak
and have schedule transaction file backup for every 1 hour say, trn1.bak
trn2.bak.... it took upto trn5.bak

if my trn3.bak corrupts then in this case how can i restore the database?

2nd condition if my diff1.bak corrupts then how could i restore the database?

Post #534868

« Prev Topic | Next Topic »

Permissions