Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup Transaction Logs on all Databases Expand / Collapse
Author
Message
Posted Saturday, September 29, 2007 3:31 PM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, June 22, 2016 11:16 PM
Points: 609, Visits: 423
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
Posted Tuesday, July 15, 2008 10:42 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 1, 2015 2:58 AM
Points: 1,171, Visits: 931
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 »

Add to briefcase

Permissions Expand / Collapse