HEELPBOOK - Don't forget to clean up your TempDB regularly (Not in Production Environment) #############################

Cleaning up your TempDB is pretty simple: just restart your MS SQL Server Service. And...to make it just a little bit easier (if possible)...you might want to schedule it . 

Start with creating a Batch-file (for example: 'Restart SQL Services.bat')

Start Notepad and copy/paste the following text:


@ECHO OFF
NET STOP SQLSERVERAGENT
NET STOP MSSQLSERVER
NET START MSSQLSERVER
NET START SQLSERVERAGENT


* Save the file and rename it to 'Restart SQL Services.bat'.

* Now go to Start Menu -> Control Panel -> Scheduled Tasks -> Add Scheduled Task.

* Click trough the wizard and select 'Command Prompt', setup the schedule and fill in the right credentials.

* Before you hit Finish, don't forget to select: 'Open advanced properties for this task when I click Finish'.


Within the Advanced Properties Window @ 'Run':

Select the Batch-file you've created and that's it!


############ ARTICLE INFO #############

Article Month: July
Article Date: 20/07/2012
Permalink: http://heelpbook.altervista.org/2012/dont-forget-to-clean-up-your-tempdb-regularly-not-in-production-environment/
Source: http://clinthuijbers.wordpress.com/2010/08/03/dont-forget-to-clean-up-your-tempdb-regularly/
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook
Linkedin: http://it.linkedin.com/pub/stefano-maggi/27/73a/b20