Restore/attach database in MS SQL Espress 2005

Got a problem you cannot solve? Try here.
r.federiconi
Posts: 4
Joined: Wed Sep 16, 2009 7:54 am

Restore/attach database in MS SQL Espress 2005

Postby r.federiconi » Wed Sep 16, 2009 12:04 pm

HI,
we bought InstallAware studio 9, how can I restore/attach database in MS SQL Espress 2005?

neillans
Posts: 536
Joined: Sat Nov 04, 2006 6:21 am
Location: Scottish Borders, UK
Contact:

Postby neillans » Thu Sep 17, 2009 3:34 pm

You can do this using a T-SQL command through any of the MS SQL plugins available (either ours or third party).
Andy Neillans

DevilSun
Posts: 19
Joined: Wed Jul 01, 2009 6:11 pm
Location: Oregon

Postby DevilSun » Fri Sep 18, 2009 11:46 am

Very true, it's up to the T-SQL you write. Just remember, you can issue T-SQL commands to remote SQL servers, but that machine may not have the database to restore/attach physically available (i.e. running install from current machine point to remote SQL server)...so for this reason, we create the database entirely through a script.


Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 73 guests