STEP-1 ------ Create Backup Job thorugh SQL Server Management Studio Express 1. Create Folder 'COSBackup' under 'D' Drive 2. Run SQL Server Management Studio Express. 3. In the tree view, expand Server Objects. Right Click on 'Backup Devices', Click on 'New Backup Device'. 4. The Backup Device dialog opens. DeviceName = COSDBBackup File = D:\COSBackup\COSSOFTDB.bak 5. Right Click on 'COSDBBackup' under Server Objects => Backup Devices. Click on 'Back Up a Database' 6. The Backup Up Database dialog opens. Source => Database: COS_2015. Click OK STEP-2 ------ Batch File (DataBackup2008.bat) sqlcmd -S MYSERVER\OFFICESERVERS -E -Q "BACKUP DATABASE MASTER TO TESTBACKUP" ..where "MYSERVER" is the name of the SQL Server physical machine. (SONY) ..where "OFFICESERVERS" is the name of the SQL Server. (SQLEXPRESS2008) ..where "MASTER" is the name of the database. (COS_2015) ..where "TESTBACKUP" is the name of the backup job. (COSDBBackup) Ref.: http://www.fmsinc.com/free/newtips/sql/SQLServerExpressDatabase/Automated_Backup.asp