How to restore database while installing SQL Server 2008 R2 using IS 2010 Ver16

I have completed a self install of SQL server 2008 R2 using Install Shield 2010 Ver 16.  Works 100%.  Now I would like to have it restore a database whilst doing the SQL install.
I don't seem to be able to find where in IS that I can tell SQL to restore the database at the end on the install.
weephAsked:
Who is Participating?
 
Benjamin MOREAUConnect With a Mentor Project ManagerCommented:
If I understand well, you want to automate the SQL Installation and the database restore.

I think you can use Powershell to do that; it will be the better solution.

Read this (good) article for more information : http://www.codeproject.com/Articles/110908/SQL-DB-Restore-using-PowerShell
0
 
weephAuthor Commented:
Thanks for that. Worked well
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.