Backup Error

[Mike2287]

Newbe to SQL

I have a new client who's backup hasn't been running. the error says not enough disk space. the database is 10 gig and there is 14 gigs of free space on the server. I tried adding a USB drive to the system and backing up to that but is also failed with the same error. anyone have any ideas what maybe causing this?

Thanks in advance for any help
Mike

 

[onpnt]

I'm sure it was just a test but please do not put backups on flash memory

How large are the transaction logs?


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[Mike2287]

Wasn't a flash, it's a 160gig segate external. Not sure how big the transaction logs are.

 

[SQLBill]

Open Enterprise Manager. Expand the tree until you see the database. Click on the database. In the right window pane, look at the graphic for the size of the database. It will show space used and space free. ALL OF THAT space is 'claimed' by SQL Server. Check the transaction log size. If that uses up all the space, then the database cannot expand if needed.

-SQLBill

Posting advice: FAQ481-4875