I finally pinned it down.

Thanks to the following articles

http://blogs.msdn.com/duncand/archive/2007/01/27/datadude-and-the-text-filegroup.aspx

http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2009/01/16/list-objects-in-a-filegroup-in-sql-server-2005.aspx

I have several of these still in the primary filegroup.

Working on a solution now to get the LOB Columns moved to a...

After shrinking the primary filegroup (1 file in it), I have no free space. It is currently sitting at 11583 total size and 11572 Used (the used is still...

Every 24hrs? Developer related?

Ouch - but can sympathize.

Good Luck with that :crying:

Thanks for the script suggestion. I like the proposed script and concept.

Shrinking the file is of lesser concern to me right now.

The heart of the matter seems to be...

I get the reason "because the server OS needs it and it is Microsoft after all" approach.

My response is typically along the lines "uh-huh sure".

At least I don't get the...

I would like to get this filegroup down to a reasonable size (500MB seems very large but is what I was able to get my Dev and QA environments down...

shrinking only brings me back to the 11GB though. Total size of the filegroup is 19GB and all it will let me reclaim is the 8GB free space.

Monthly for patches - per SLA. This is insisted at the monthly frequency by the IT Team.

If you do not experience a high volume of transactions / or are backing up to tape - then it looks like your Backup Plan makes sense.

Do a full nightly...

Page - 80's version of texting (who carries a pager these days?)

However, if the page is torn, then i don't know how to answer Gails question...

ROFLOL

Mirroring - Not really replication with or without consent - just cloning yourself.

Run tran log backups after completion of the full.

If you are running a nightly full, there is no need to do a diff that day with your databases being so...

Why I'm going to code or fix code? 😎 ... I'm not getting paid for that! That's the developer job. Yes, the DBA should be smart enough to identify the...

This is accurate. If you login with 'sa', and then change the password - you must disconnect that session and login again with the new password

Torn page - I'm using Guerrilla Glue - better than duct tape or superglue - and has many more uses.

As for the coding questions. A DBA does have a...