Guys I'm going to be putting in a database mirroring solution for our Sharepoint 2007 farm. I will not be using SQL servers auto grow features instead I will manually set the size of all log files and database files. However since I'm not using auto grow I would like to be able to configure some type of alerting. For example, if I have a 20 gig file and I it only has 2 gigs of free space left I would like to receive an email alerting me that I need to check on the data file. So can anyone here suggest a method for accomplishing this?
There is way of doing this through SQL server in-built feature of AGENT ALERTS.
To configure this for your case , do the following.
Open sql server agent Right click alerts and select new alerts provide a name for this alert Set the type as SQL server performance condition alert. Choose SQL server: DATABASEs from OBJECT drop down box. Choose datafile size(kb) from counter Choose the exact databasename from instance drop down box. Then enter value (in KB) as your thershold limit .
You may set this alert to be sent to you via operator.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.