SQLServerCentral / Discuss Content Posted by Wesley Brown / Article Discussions / Article Discussions by Author / Backup Transaction Logs on all Databases / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:23:24 GMT20RE: Backup Transaction Logs on all Databaseshttp://www.sqlservercentral.com/Forums/Topic404481-195-1.aspxHow could we recover the database if my transaction log gets corrupted / anything will happ.Suppose I have FullBackup say, Full1.bakafter this i have taken the differential backup say, diff1.bakand have schedule transaction file backup for every 1 hour say, trn1.baktrn2.bak.... it took upto trn5.bakif 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?Tue, 15 Jul 2008 22:42:29 GMTabmoreBackup Transaction Logs on all Databaseshttp://www.sqlservercentral.com/Forums/Topic404481-195-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Backup+%2f+Restore/30068/">Backup Transaction Logs on all Databases</A>[/B]Sat, 29 Sep 2007 15:31:38 GMTWesley Brown