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.
No comments yet.
Leave a comment
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
