This tip is on databases. Here you go — free on us — compliments of http://www.sozohosting.com/ and also compliments of http://www.biznesstechnologies.com/ :

Database Back Ups With Maintenance Plans MS SQL 2005 and 2008

Using SQL Studio management tool you can set up a maintenance plan to back up all your databases nightly (or whatever schedule you want) onto another drive (preferable one on another server).

We recommend you select the option to do a FULL backup on ALL databases since you could add new databases later and this maintenance plan you set up will start backing up the new databases. Select the option to back up each database in a different folder. When you select the maintenance plan folder in the SQL Studio management tool, select the Maintenance Wizard to set up the automatic database back up plan and set a schedule on how often backups recur. The schedule will fire as long as you have SQL Server agent running. SQL Studio management tool will show you if SQL agent is running if you look on the menus on the lower left. If it is not running, then go to your control panel, then open up services for that server, and scroll down till you see SQL Server Agent. Right click on SQL Server Agent and set it to automatic and start it.

For more information click on this link: http://www.sozohosting.com/knowledge/microsoft-sql-server-database-tips.cfm

PS. Backing up databases is one thing but you should back up your web apps also which you would have a different process for. For critical apps make sure your back ups go off site.

Categories: Uncategorized ,Web Hosting ,Web Hosting and Database Tips


Leave a Reply

You must be logged in to post a comment.