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)
 Backup doesn't seem to do anything

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
Go to Top of Page
   

- Advertisement -