Backup Transaction Logs on all Databases

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

abmore Hall of Fame Points: 3628 More actions · Answer 1

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?

Cookies on SQLServerCentral