I tried to restore the database from a backup file during the initial
install and am getting this error below. Is there WiX log or something
where I can get some more info on how to debug this? Below is my code
and I think this should work. Anyone have any ideas? Thanks in advance
for you help.
<Component Id="SuiteDatabaseComponent"
Guid="d6e96011-3252-4e85-80b5-b1ff64045e88">
<File Id="DatabaseBackup"
Name="SuiteBlank.bak" Source="..\..\Database\Backups\SuiteBlank.bak" />
<CreateFolder/>
<!-- installs database -->
<sql:SqlDatabase Id="db1"
Server="[SQLSERVER]"
Instance="[SQLINSTANCE]" Database="Suite"
CreateOnInstall="yes"
ConfirmOverwrite="yes"
DropOnUninstall="no" User="SQLUser">
<!-- define where the database
files are saved -->
<sql:SqlFileSpec Id="mdf"
Name="Suite_Data"
Filename="[DATABASEDIR]Suite_Data.mdf"
Size="2MB"
GrowthSize="2MB"/>
<sql:SqlLogFileSpec Id="ldf"
Name="Suite_Log"
Filename="[DATABASEDIR]Suite_Log.ldf"/>
</sql:SqlDatabase>
<sql:SqlString Id='RestoreDB'
SqlDb='db1' ContinueOnError='no' ExecuteOnInstall='yes'
SQL="RESTORE DATABASE Suite FROM DISK = '[DATABASEDIR]SuiteBlank.bak'
WITH MOVE 'Suite_Data' TO '[DATABASEDIR]Suite_Data.mdf', MOVE
'Suite_Log' TO '[DATABASEDIR]Suite_Log.ldf',REPLACE"/>
</Component>
Error -2147217900: failed to execute SQL string, error detail: RESTORE
DATABASE is terminating abnormally., SQL key: RestoreDB SQL string:
RESTORE DATABASE Suite FROM DISK = 'G:\Database\SuiteBlank.bak' WITH
MOVE 'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE
Eric Latendresse
-----Original Message-----
From: David Reed [mailto:david.r...@microsoft.com]
Sent: Friday, January 23, 2009 11:44 PM
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] Creating SQL Database with WiX v3
It really depends on what those 9k scripts are doing.
If your scripts are a raft of INSERT statements or other transactions,
then you can probably switch to CSVs and bulk load (much faster), which
is what we do with AdventureWorks now for SQL Server 2008 samples. The
WiX3 code for ours is checked into CodePlex here along with the MSBuild
scripts, etc:
http://www.codeplex.com/SqlServerSamples/SourceControl/ListDownloadableC
ommits.aspx
In our experience with AdventureWorks' installers, switching to a
backup/restore is likely to bloat the size of your installer quite a bit
because the BAK files aren't nearly as compressible (if at all) as
script files are...
________________________________________
From: Eric Latendresse [elatendre...@optimum-solutions.com]
Sent: Friday, January 23, 2009 13:10
To: General discussion for Windows Installer XML toolset.
Subject: [WiX-users] Creating SQL Database with WiX v3
I am creating a SQL database with my installer. Right now I have
approximately 9000 scripts to be run after the database is created. This
is taking around 20mins for the install to complete. Is there anything I
can do to speed this process up? I thought about running a single
script to restore the database from a backup file of the database, but
thought I'd ask if there was a better way.
Eric Latendresse
------------------------------------------------------------------------
------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------
------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
