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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-08-02 : 10:45:29
|
| Antillean writes "Hi.When using the wizard to backup a database the resulting file simply does not grow beyond a size of ... 0 Kb.This is a 50GB database.Similar database running on similar hardware take approximately 20 minutes and the backup file size is seen to increase in size as the backup get nearer completion.Regards,Antillean." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-02 : 10:58:36
|
| Welcome to SQL Team Antillean!Is there enough disk space?How big is the Log file - IME when this becomes massive the "effort" to make the backup becomes bigger too.(If you are NOT specifically doing Transaction log backups AND the database is NOT set to Recover Model = SIMPLE then I reckon my second idea is a liekly candidate for your problem)Kristen |
 |
|
|
|
|
|