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."
Previous
Next Post »

2 comments

Click here for comments
Anonymous
admin
September 13, 2013 ×

nice

Reply
avatar
September 13, 2013 ×

Thanks for appreciating..keep reading

Reply
avatar

If you have any question about any post, Feel free to ask.You can simply drop a comment below post or contact via Contact Us form. Your feedback and suggestions will be highly appreciated. Also try to leave comments from your account not from the anonymous account so that i can respond to you easily..