Take automatic backup of Sql server Database

Introduction: In previous article i have explained How to convert/downgrade SQL Server 2012,2008 database to SQL Server 2005 or lower version and  How to take Sql server database backup and How to create Sql server database script and Create database from that script .Now in this article i will explained how to take automatic backup of your Sql server database.Just follow the steps:

1. Open notepad and paste the command


2. sqlcmd -S MYSQLSERVER -Q "BACKUP DATABASE Northwind TO
   DISK = 'D:\MyDataBase.bak' WITH INIT, NAME = N'Automatic back up of database',
   STATS = 1"
   pause


3. Change the "MYSQLSERVER " with the name of your server.


4. Change "MyDataBase" with the name of your database.


5. Now save the notepad file with the extension .bat e.g. DbBackup.bat


6. Now whenever you click on this DbBackup.bat file it will create the backup of your database at the specified location. Here in our case in D drive.

Now over to you:

"If you like my work; you can appreciate by leaving your comments, hitting Facebook like button, following on Google+, Twitter, Linked in and Pinterest, stumbling my posts on stumble upon and subscribing for receiving free updates directly to your inbox . Stay tuned for more technical updates."

• Tweet
• Share
• Share
• Share

Related Post