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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Unexpected Log File Growth during Differential Backup

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-18 : 09:33:29
Eli writes "I issued a
BACKUP DATABASE myDb to disk = 'file.bak' WITH DIFFERENTIAL
statement

I don't know but from a reason not clear to me the
BACKUP statement causes the database log file to increase
in size to severel GigaBytes and that filled the disk and the
whole backup command failed!

why does the differential backup enlarge the log file in
such manner and how can I avoid it ?"
   

- Advertisement -