Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)


By quasar00,

This vbscript is used to alert and email receipients on Filegroup space usage
Ouput:  '% Space Avail. , Space Avail. Filesize, MaxSize, FileName, DBname, FileGroup
The process takes three arguments - SqlserverName ,
Threshold for percentage of available space to check ,
Mininum MaxFileSize to check
Execute the script either from the command line or schedule the script via Sql Server Agent
Command line execution:  cscript.exe sp_dba_spacealert_dmo.vbs sqlservername Threshold MaxfileSize
Sql server agent : cscript sp_dba_spacealert_dmo.vbs  sqlservername Threshold MaxfileSize
The process uses sqlmail which can be installed on any server within your organization

Total article views: 315 | Views in the last 30 days: 1
Related Articles

Disk Space (Space Available vs. Available Free Space)

Space Available vs. Available Free Space


How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75

  When you do  SQL Server maintenance one of important aspect is available space on server drive be...


Quickly Viewing Available Space

As everyone moves to SQL Server 2005 from SQL Server 2000, there are quite a few pieces of informati...


Space available in a DB

Script for checking space of db


Sql 2000, Database don't have available space

Sql 2000, Database don't have avialable space


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones