Restore backup database through command

Question

Hi Friends There are any way to restore backup database through SQL command ?

Senthilkumar · Answer

Hi There are two statements to back up and restore the database through the sql statement in query window. Backup Restore Backup database TO diskpath RESTORE database FROM path If you want to do it through the application then i have developed sample application. You can download it. http://www.c-sharpcorner.com/Blogs/8679/backup-and-restore-the-database-in-Asp-Net-web-application.aspx

Kunal Vaishya · Answer

Dear yes data base backup also we can use script to do like this if you want to use SqlCOmmmand then Set Command String and You can Execute it