Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, July 23, 2014 1:21 PM
Points: 609, Visits: 407
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: Friday, October 10, 2014 2:36 AM
Points: 1,158, Visits: 878
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