Restore DataBase form

Question

Hi I want to give the user of my application to an option to restore the database from a backup file.. How can i do it... Please guide. i am working on VS 2008 and sql server 2008 windows application

B M Suchitra · Answer

My dear friend Kiran Karale You have not understood/read the question properly

Kiran Karale · Answer

Taking Backup of Database New Querty=> Backup Database Databasename to disk='c:\databasename.bak' // give any path Restore the Database restore database Databasename from disk = 'D:\kiran\ databasename .bak' with move ' Databasename ' to 'd:\kiran\ databasename .mdf' move ' Databasename_log' to 'd:\kiran\ databasename _log.ldf' move 'sysft_iitsm_fts' to 'd:\kiran\smartt25' // if use sql 2005 then use this line in 2008 skip this line