Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Got a database in azure called Logging, which contains a table Log.

Select count(*) from log

returns 0

The database is empty.

Attempting to insert says it's full. Azure control panel reports it as being full (more than full, actually), but I don't know why or how to fix it.


Returns 1073741824

SELECT SUM(reserved_page_count) * 8192 FROM sys.dm_db_partition_stats

Returns 1081032704

Any ideas? The normal repair commands don't seem to be supported in azure.

share|improve this question

First, try issuing a "truncate table log" command and check again. While you're at it, run "select * from sys.all_objects where type = 'U'" to make sure you really have a single table there. Finally, make sure your table has a primary key: tables without primary keys have the bad tendency to grow without limit even if you delete elements (they just mark on ones as deleted and add new ones at the end).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.