How to take Sql server database backup

Introduction: In previous articles i explained  How to convert/downgrade SQL Server 2012,2008 database to SQL Server 2005 or lower version and Take automatic backup of Sql server Database and How to create Sql server database script and Create database from that script .
In this article i am going to explain how to take the backup of Sql server database manually through command/query.

Description: Taking backup of database at regular interval is always recommended because the data may be very important. Sometimes you need to take quick Sql server database backup. Its not a complex task but if you are unfamiliar then here is the syntax:-

Backup database [database name] to disk=’path where you want the file.bak’

e.g. In the query editor of the Sql Server type the following :

backup database MyDatabase to disk='d:\Mybak.bak' with stats=10

Note: If you want to copy the database over the network then you can also use UNC path. The syntax will be as:

 Backup database [database name] to disk=’\\servername\path.bak’

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

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..