MS SQL Server - space available

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

space available

MichaelTuanAnh

2006-10-24, 6:31 pm

anyone who let me know what happem if space available is 0MB.
thanks very much

Tibor Karaszi

2006-10-24, 6:31 pm

Depends on whether it is data or log file. First, if SQL Server can autogrow the file, it will. If
not:

Data file:
Modifications that result in extent need to be allocated will return error message 1105

Log file:
No modifications or anything that requires writing to the transaction log will be allowed. They will
fail with error message 9002.

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

"MichaelTuanAnh" < MichaelTuanAnh@discu
ssions.microsoft.com> wrote in message
news:A1D2FB2E-C9C1-4436-BA83- 5C9FEB1412A2@microso
ft.com...
> anyone who let me know what happem if space available is 0MB.
> thanks very much

Sponsored Links