Seems like a disk full type of error to me as well. I would check for free disk space.

How much did that barn cost? I need one that is about 60'x100'

I appreciate the explanations. There is a lot of content worth reading from this thread.

Rich Weissler (12/28/2011)

I could tell you, but I fear the answer would be a bit...

Separating your data into different data files is something that largely depends on usage patterns and the scheme you employ to break out the data. There are many different...

No problem.

Agreed - so much less controversial than reindeer. But I don't like the taste of keys as much as reindeer;-)

You are welcome.

For blocking, here is what Microsoft uses in Activity Monitor.

SELECT

[Session ID] = s.session_id,

[User Process] = CONVERT(CHAR(1), s.is_user_process),

[Login]...

Bhuvnesh (12/28/2011)

can u suggest...

Yes, the backup_size field is stored in bytes so your formula is accurate.

The compressed_backup_size is also stored in bytes so the same formula applies there.

You're welcome.

Government (the triplicate post made me think of government paperwork)

If your mdf file is full then shrinking is out of the question and is not even applicable for discussion since you can't shrink a full file.

If your file is...

I am putting the finishing touches on an article. Anybody interested in reviewing/critiquing it?