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

2009-01-29 Thread Eric Latendresse
: Thursday, 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.

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

2009-01-29 Thread David Reed
January 29, 2009 09:05 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-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

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

2009-01-29 Thread Rob Mensching
restoring 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 Anyon

[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