Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeBoy
Starting Member
7 Posts |
 Posted - 2008-03-10 : 05:12:18
|
| I have this database "DB1" which is in FULL recovery mode.I run full daily backup -Monday to Saturday DB1_Mon.bak DB1_Tue.bak DB1_Wed.bak DB1_Thur.bak DB1_Fri.bak DB1_Sat.bak Come Sunday - for the first time I have run transaction log backup. DB1_Sun.trnAnd now, I need to restore DB1 - but the only full backup that I have is the Monday - "DB1_Mon.bak"Is my database complete if I restore only "DB1_Mon.bak" plus the "DB1_Sun.trn"?Jeboy |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-03-10 : 10:44:12
|
| No, the transaction log backup will only have the transactions since the last full backup. |
 |
|
|
|
|
|
Backup and Restore(full + transaction log)