Solved

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

Posted on 2015-01-31
2
117 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

One of the frequent problems with the installations is when some file or registry entry is not removed from the system upon un-installation of the product. Clean removal is always highly desirable. One major reason for that is badly authored inst…
Among others, I monitor the Windows Installer zone and Installer zone. I find that many of the questions could be answered much more quickly if a Windows Installer verbose log were submitted with the question.   However, I do not always have t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

708 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