Having recently done the same thing (and still in progress)

Here are some useful scripts:

Script 1 - determine LOBs per filegroup

select fg=filegroup_name(a.data_space_id), tbl=object_name(p.object_id), idx=i.name

from sys.allocation_units a

inner join sys.partitions p

on p.partition_id =...

Why does it concern you? You may have moved all the user database objects out of the Primary filegroup, but that is where the system database objects reside, and...

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