[Script Of July 10] How to check if SQL Server database files are marked as sparse files

July 10 Script Download:  The script is available for download from http://gallery.technet.microsoft.com/How-to-check-if-SQL-Server-af01ebb9 (SQL) and http://gallery.technet.microsoft.com/How-to-check-if-SQL-Server-23bace0c (powershell).  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  Only files associated with a database snapshot should be marked as sparse files. If a regular database is marked as a…

2