Let us know. That's a strange one. If you aren't getting notes on what's causing growth, I'll ping soem MS people. Might be worth burning a case with them to...

Nelson, excellent points. I hadn't thought about it in those terms, but there is definitely value in those situations.

One more, you might find a great person that you want to...

Sorry, Matt is correct. I've typically created them with a process that is always running at startup, so they've always appeared to be there. That's a good thing to note...

I agree and think w3schools is really basic. But check it out and see what you think.

The 4 Guys site is good, but you'd really need to go back to...

And the db still grew?

You're correct. Once the db is restored, the size of it doesn't matter. It's the logs that have to be restored.

Did it ever catch up? I'm almost wondering if you...

Nice catch, George. Didn't notice that. Thanks for the note.

If you see "operating system error" in your log, it means that a Windows error is bubbling up. In this case, it's the same error you might get in Word...

There are tools like Quest's Spotlight (or Foglight) and maybe Patrol from BMC, that will monitor this.

The way I used to do it was track backup sizes from a script...

SQLSentry (http://www.sqlsentry.net) will handle jobs across servers. Red Gate has Multi Script (http://www.red-gate.com/products/SQL_Multi_Script/index.htm), which runs scripts across multiple servers.

You can designate a master/target server relationship which means that one instance...

Tables with #, are local temp tables. Only available to that connection. When that connection ends, the table is gone. However, if you execute multiple things, those tables are available.

Tables...

ShrinkFile should be able to shrink the file. I've seen issues with log files, but it seems data files usually shrink.

I understand your wanting to save space, but be sure...

Let the boss know someone submitted a Connect item on this error.

It looks from some searches that this is a master db error. Is that what you got? Anything in...

Roy is correct. The FAQ says any recovery model works.

There may not be anything to clean up. You might just be out of space. Data files grow over time as data is added, and most of these are not...