What is the impact to SQL Server 2000 (sp1) databases should the disk
run out of space?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?
>
Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts
Wednesday, March 21, 2012
Out of disk space
What is the impact to SQL Server 2000 (sp1) databases should the disk
run out of space?It depends on whether there is free space in the database files or not. If t
he 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?
>sql
run out of space?It depends on whether there is free space in the database files or not. If t
he 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?
>sql
Subscribe to:
Posts (Atom)