Well, well, well...

It works with PowerShell's Optimize-Volume, but not defrag.exe

Optimize-Volume -DriveLetter L -Analyze -Defrag -Verbose

(Drives are thin-provisioned)

Thanks for looking, I previously read a similar article that had the same sort of reply, "Contact NetApp about OptimalUnmapGranularity".

I was hoping to see if anyone else had similar issues....

Sorry the sysadmin set it up, not me. It is a cluster and it is NetApp SAN attached storage with a 64K file allocation size.

It was 4 years ago, I really do not remember.

Sorry

Posted Date 1/21/2010 6:30:21 PM

have you tried manually issuing checkpoints prior to the emptyfile?

It would probably also be helpful to have the database set to SIMPLE.

You may find this helpful:

(Just some extra code for your dev work)

Sql to get most recent full backup file for a specific database in sql server

As long as you have the right version, absolutely.

You may find this helpful:

TechEd: 80 minute video of Corruption Survival Techniques presentation[/url]

You may be able to do page restores if you have all the pre-requisite's

REBUILD has to rollback when cancelled.

REORGANIZE does not.

Have you tried google?

You could suspend mirroring. Patch and reboot the mirror partner. Resume, wait for sync, and fail over. Then repeat on the other side.

Similarly with log shipping. ...

Can you check these two counters in perfmon?

SQL Server, Memory Manager

Target Server Memory (KB)

Total Server Memory (KB)

SQL Server, Memory Manager Object

Looks to me like the order goes Piecemeal Restore of RW then online restore of read only. You also need to be running Enterprise:

https://www.simple-talk.com/sql/backup-and-recovery/partial-backup-and-restore/

http://msdn.microsoft.com/en-us/library/ms177425.aspx

Have you tried RESTORE DATABASE { database_name } <filegroup> [ ,...n ] WITH RECOVERY ?

Recover a Database Without Restoring Data (Transact-SQL)