Backup SQL Server Express 2008R2

Open up SQL Server Management Express Studio, and Expand Databases

For this example, we will be backing up a SharePoint Server, so we will be backing up the WSS_Content Database

Right click on the database and then in the menu choose Tasks -> Back up…

Get everything setup to your local disk or remote folder that you want to do the automated dump to. In this case i am doing to the D:/ Drive

Enter the name you want to save it as, and hit OK.

Since We Are Really awesome DBA’s, were going to verify by using “options” and then “verify”

from there at the top select “script action to file”

Save it to a local file

From here all we need to do is schedule the script, open up Task Manager

Create a new task using the Wizardwhen asked to select a program browse to C:Program FilesMicrosoft SQL Server100ToolsbinnSQLCMD.exe (or wherever the location of SQLCMD.exe is)

There are 2 arguments that need to be set: -S SERVER_INSTANCE_NAME  -i “PATH_OF_SQLBACKUP_SCRIPT”
where SERVER_INSTANCE_NAME  is the name of the instance of SQL server that contains your database e.g. (local) and PATH_OF_SQLBACKUP_SCRIPT is the path of your backup script e.g. “C:Program FilesMicrosoft SQL ServerDatastoreBackup.sql”

from there all you have to do is schedule the times.

That’s it!

For Hosted Database Servers visit www.zwiegnet.com/go