Solved

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

Posted on 2015-01-31
2
121 Views
Last Modified: 2015-02-07
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.
0
Comment
Question by:weeph
2 Comments
 
LVL 9

Accepted Solution

by:
Benjamin MOREAU earned 500 total points
ID: 40581815
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
 

Author Closing Comment

by:weeph
ID: 40595992
Thanks for that. Worked well
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been scripting applications way too long and can never remember how to create an ISS file.  So I decided to write this article to act as my own knowledge base for future reference, and hope you will also benefit. An ISS file is a response …
Monitor input from a computer is usually nothing special.  In this instance it prevented anyone from using the computer.  This was a preconfiguration that didn't work.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now