search

microsoft / tigertoolbox

Toolbox repository for Tiger team
http://aka.ms/sqlserverteam
Other
1.48k stars 740 forks source link

BPCheck fails on SQL 2008 #144

Closed sherwin-a closed 5 years ago

sherwin-a commented 5 years ago

The sys.dm_os_volume_stats DMV does not exist in SQL 2008 and causes BPCheck to fail.

|-Starting Disk space Msg 208, Level 16, State 1, Procedure usp_bpcheck, Line 450 [Batch Start Line 7] Invalid object name 'sys.dm_os_volume_stats'.

pmasl commented 5 years ago

It only works starting with SQL 2008 R2 SP1. Will correct and upload. Thank you