How to take database Backup and restore using command T-Sql - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

How to take database Backup and restore using command T-Sql

In this article I am going to explain how to take database Backup and restore using command T-Sql.


Description:
We have only 2 commands for database backup, backup database and backup log. Backup database takes backs up the full database and backup log backs up transaction log.

Backup database
Backup database [demo] to disk='D:\demo.bak'

Backup log
backup log [demo] to disk='D:\demolog.bak'

Restore database
restore database [demo] from disk='D:\demo.bak' 









What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon