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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-08-09 : 16:16:26
|
| Hi,Assumption: When we do full/complete database backup it includes both the datafile and transaction log file backup.(since from same .bak we were able to restore the database including datafile and transaction log file) In one of the systems full backup finish successfully and took 9GB of space But immediately after that transaction log backup ran and that fails with insufficient hard disk error (15GB free on hard disk) 1) Isn't the transaction log backup logs the changes since last full backup so that in above cases it should have finished with less file size. 2) If we are doing full backups, sql server don't truncate the inactive part of log, if t-logs are included in full backup why we have to take t-log backup to be able to shrink the log file?Thanks--rubs |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-09 : 17:01:45
|
| The full backup does NOT include the transaction log. It only backs up as much of the transaction log as necessary in order for a consistent database to be restored. This is explained in SQL Server Books Online.You must run BACKUP LOG in order to backup the transaction log. The only time that you don't need to do this is if your database recovery model is SIMPLE.Tara |
 |
|
|
|
|
|
backup question