I don't do any application data deletion and don't know when that happens so I run this code once a month. So far I see no excessive file allocation, but...

One-off SHRINKING IS NOT POSSIBLE with more than 6000 databases. You have to have an algorithm for this. Any suggestions?

It seems to me that most of you people agreess that it is OK to do a SHRINKFILE "within a reasonable amount of time" so what is that? One month...

Fragmentation on a NetApp SAN-disk is no problem - you do not need to do any defragmentation. We have skipped Diskkeeper which we used for the old local disks.

Well, e.g. we have a partitioned database which allocates a new file for each month. We remove unallocated space in all prvious mont if nessecary. The database had grown to...

We do shrink each file, but first we check if it contains a lot of unallocated space (e.g. > 10%):

.

.

-- Skip small files

IF @totalextents < 2000

BEGIN

PRINT 'Skipping file ID...

My suggestion is to look in the system tables to see if a database is backed up fully or not. We do this before the log backup:

--use Filer

--go

--IF OBJECT_ID('spF_BackupNewDB') IS...

In had the same problem to create an assembly on a remote server using an unc-path from my local SQL Management Studio (2008). I then used terminql services and started...

See if you can use my SP spF_build_import on http://www.sqlservercentral.com/scripts/contributions/1537.asp which will "Import database from source server using full and transaction log backups as recorded in msdb. Use it to...