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...

Can't search back. Which site, Lynn?

No, you need to grow the tables if they aren't registering in the counters.

I'd recommend the book route as well.

If you want to go back and read through the archives, you can also use 4 Guys From Rolla[/url] as a good site...

You can still do it in a large company, just need to use groups and spend a little more time on it. Or lock things down and take requests for...

Haven't finished the Cowboys game yet, but Romo definitely looked off. :(, and that's my team. Good to see the Broncos win, but I suspect they might go quite a...

I'd recommend 4 Guys From Rolla[/url] as a site to learn about ASP.NET

Also be aware that a SQL file needs free space in it. It is not like a Word or Excel file in that it is the size of the data.

You can also right click the databases in SSMS and view the space. That can be easier to understand.