MS SQL Backup

MS SQL Backup Management on Windows VPS :

1) First Login to your Windows Web Hosting Server through RDP
2) Create a folder for backup
3) After that login to MS SQL Server Management Studio Express
4) Click on New Query
5) Enter the query
6) Click on Execute

7) Now from Start, click on Control Panel > Scheduled Tasks > Add Schedule Task
8)  Click on Next > Browse
9)  Navigate the link and Open
10) Enter the task name
11) Perform backup > click on Next
12) Enter Password and reconfirm > Next
13) Click on Open advanced properties and Finish
14) Now Click on Start > Run the following :

“C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE” -d msdb -Q “execute sp_backupdatabases @path=’c:\backupname\'”

15)  Click on OK

Leave a Reply

Your email address will not be published. Required fields are marked *