Posts

Showing posts from July, 2016

Take Backup of SQL Database Using Batch file

Step for Take Backup 1.Open Notepad 2.Paste following Code in notepad 3.Save this file as backup.bat Code snippets echo off cls echo -- BACKUP DATABASE -- set DATABASENAME=MobileRecharge :: filename format Name-Date (eg MyDatabase-2009.5.19.bak) set DATESTAMP=%DATE:~-4%.%DATE:~7,2%.%DATE:~4,2% set BACKUPFILENAME=D:\%DATABASENAME%-%DATESTAMP%.bak set SERVERNAME=DESKTOP-0BOTN0I\SQLEXPRESS echo. sqlcmd -E -S %SERVERNAME% -d master -Q "BACKUP DATABASE [%DATABASENAME%] TO DISK = N'%BACKUPFILENAME%' WITH INIT , NOUNLOAD , NAME = N'%DATABASENAME% backup', NOSKIP , STATS = 10, NOFORMAT" echo. pause Instruction 1. MobileRecharge is database name replace this name with your database which you want to take backup 2. Here we specify D:/ for take backup 3.DESKTOP-0BOTN0I\SQLEXPRESS is server name replace with your server name 4.Run the file and see the backup in D:/ Drive 5.If you want to take backup Automatically Schedule this file in Task Scheduler...