Search code examples
sql-serverbackupinstallshielddatabase-restore

How to restore a database from a backup in installshield

I'm using MSI Project with InstallShield 2010.

I have a .bak file, a backup of a SQL database (I am using SQL Server 2008 R2). How can I restore it using InstallShield?

I was looking in SQL Scripts tab and I didn't find anything about restoring backups.

Thanks for your time!

Solution

  • say suppose you have xyz.bak as a bakup and you want to restore it on to your sqlserver 2008r2 try running following query in ssms

    Restore database DatabaseName from disk='path of your bak file'

    this will restore your database.