The following article explains how to backup your MS SQL Server Express database using Management Studio Express. The backup can then be used at a later date to restore the database if information is lost. The backup file needs to have a .bak file extension.
To backup your database, please follow these steps:
1) Log into your server through Remote Desktop Connection (instructions for connecting to your server through RDC can be found here).
2) Create a folder to store your backups, for example c:\backups\
3) Log into MS SQL Server Management Studio Express on your Windows VDS.
4) Click New Query.
![](http://www.webecs.com/kb/Attachments/db25e62e-04ae-44b0-835d-a596.gif)
5) Enter the information found here.
6) Click Execute.
![](http://www.webecs.com/kb/Attachments/534bd49c-e18d-444b-8836-74a2.gif)
7) From the Start menu, click Control Panel, select Scheduled Tasks and click Add Schedule Task.
8) Click Next.
9) Click Browse.
![](http://www.webecs.com/kb/Attachments/e9412cbe-c600-4419-8ceb-3911.gif)
10) Navigate to C:\Program Files\Microsoft SQL Server\90\Tools\Binn\, select SQLCMD.EXE and click Open.
11) Enter a name for the task, select when to perform the backup and click Next.
![](http://www.webecs.com/kb/Attachments/f526b544-c659-4c8d-8011-c675.gif)
12) Enter your password twice and click Next.
13) Check Open advanced properties... and click Finish.
![](http://www.webecs.com/kb/Attachments/dac57398-1ea6-47f4-91c2-9def.gif)
14) In the Run section, paste the following information exactly as you see it (including the quotes):
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -d msdb -Q "execute sp_backupdatabases @path='c:\backups\'"
15) Click OK.