[WiX-users] Restoring SQL Database with Sqlstring in WiX v3

2009-01-29 Thread Eric Latendresse
Anyone have any suggestions on how to debug this? I have checked the SQL server logs and there is nothing there pertaining to this WiX error. Thank you in advance for your help with this. This is the exact error: Error -2147217900: failed to execute SQL string, error detail: RESTORE DATABASE is

Re: [WiX-users] Restoring SQL Database with Sqlstring in WiX v3

2009-01-29 Thread Rob Mensching
from backup. -Original Message- From: Eric Latendresse [mailto:elatendre...@optimum-solutions.com] Sent: Thursday, January 29, 2009 08:15 To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Restoring SQL Database with Sqlstring in WiX v3 Anyone have any

Re: [WiX-users] Restoring SQL Database with Sqlstring in WiX v3

2009-01-29 Thread David Reed
-users] Restoring SQL Database with Sqlstring in WiX v3 Not much that is helpful. When I've had really hard SQL issues, I've always used the SQL profiler to dig through all the calls and find the one that is failing. Note: I have seen successful attaches of database files but never tried to do

Re: [WiX-users] Restoring SQL Database with Sqlstring in WiX v3

2009-01-29 Thread Eric Latendresse
, January 29, 2009 11:39 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Restoring SQL Database with Sqlstring in WiX v3 I've done restores successfully this way. Profiler will help determine the call(s) made and more details about why they failed. Eric, assuming