PowerShell script to retrieve free space in MSDE 2000 database
This week I had the need to automate reporting of available free space in a MSDE 2000 database due to the 2 GB database limit being nearly reached.
I wrote a PowerShell script which uses the SQL Server 2008 Management Studio Express to retrieve the amount of free space in the specified database, and then sends the result to the specified e-mail address. The script are set up to run as a scheduled task until the application administrator have deleted old data in the database.
The script are uploaded to PoshCode, and are available from here.
About
My name is Jan Egil Ring and I live in Trondheim, Norway. I work as a Senior Consultant on the Infrastructure Team at Crayon Norway.
I`m holding different certifications such as MCITP: Enterprise Messaging Administrator and MCITP: Enterprise Administrator. For more details see my MCP Virtual Business Card.
I work mainly with Microsoft-products, and my favourite server product is Microsoft Exchange.
I`m a co-founder of the Norwegian Microsoft Technology User Group (MTUG), which is an assosication of local MTUG user groups in Norway.
I`m also a big fan of Windows PowerShell as you probably guessed based on the blog-title 
My intentions with this blog are sharing my experiences based on various projects and troubleshooting, as well as sharing different resource links to technologies I work with.
RSS-feed
Google Reader – My Shared Items- Delayed SMTP Acknowledgement Mike Crowley
- Combining Web Farm publishing with Software or Hardware Based Load Balanced CAS arrays Exchange
- Moving mailboxes, Exchange 2010 way Exchange
- Tips on Quest and Exchange Shell to Manage Groups and Group Members Krishna
- Exchange Email Address Template Objects in PowerShell michael
