MS SQL Server - Out of disk space

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Out of disk space

danielp

2006-11-16, 7:12 pm

What is the impact to SQL Server 2000 (sp1) databases should the disk
run out of space?

Tibor Karaszi

2006-11-16, 7:12 pm

It depends on whether there is free space in the database files or not. If the database files are
full and cannot autogrow, you get below errors when more space is needed to accommodate your
modifications:

1105 for data files
9002 for log files

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"danielp" < danielsmith611@gmail
.com> wrote in message
news:1163694924.709204.294940@e3g2000cwe.googlegroups.com...
> What is the impact to SQL Server 2000 (sp1) databases should the disk
> run out of space?
>

Sponsored Links