.gif)
11 Apr
MS SQL Backup
MS SQL Backup Management on Windows VPS :
1) First Login 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