I've modified some of my database tables and in the existing version(ver1.3) of my database and i named the new version as ver1.5.
now when i've detached ver1.3 database and attaching ver 1.5 to server it is taking the .ldf file from the folder ver1.3.(I'm maintaning the each version in a saperate folder)
I want to create an independent .ldf file for ver 1.5 also. i dont want to depend on old version for .ldf file.
Does anyone know how I would go about upgrading a database version to 'C.0.6.43'? I am getting an error and it is telling me to upgrade my database to this version.
If I am upgrading the SQL Server 2005 32 bit to 64 bit (only DB Server), Do Applications that communicate with Database need to be upgraded to 64 bit as well???
hi experts, i have a postcode database that i need to update. the database cnotains of 6tables, the file i ahev has all the information at once, so i have to organize it and insert records into the appropriate tables. this is the first time i'm doign this so i would like to know what the best way to do? do i need to create a stored procedure or a script, or may be something special and efficient that i do not know yet. any advise will be very appreciated thanks in advance
I have a WinXP Pro sp2 system that I have installed SQL Express in one case and in another caes I have installed SQL Express sp1. When trying to upgrade either to the next service pack, I get a "Setup Failed" on the "SQL Server Database Services". When I look at the log file, the following is the error:
... MSI (s) (F8!28) [14:43:23:980]: PROPERTY CHANGE: Adding EditionTypechecksum.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 property. Its value is 'Express Edition with Advanced Services'. <Func Name='GetSkuIt'> GetServiceUserGroup failed for SQLEXPRESS, 5 Error Code: 0x80070534 (1332) Windows Error Text: No mapping between account names and security IDs was done. Source File Name: sqlcasqlcax.cpp Compiler Timestamp: Fri Feb 9 22:35:05 2007 Function Name: SetInstanceProperty Source Line Number: 1223
Error Code: 1332 MSI (s) (F8!28) [14:43:27:235]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
I upgraded from 6.5 to 7.0 SP3. Now when I save (write) an invoice it takes about 10-12 seconds, at 6.5 it was 1-3 seconds. SQL Server and my Materials App are the only thing running on this box. This is the only area that has gotten slower everything else works great. I have 3 users saving invoices and about 15 people total using the system at one time. It's a compaq DL580 loaded with memory, database is 2,195MB in size. Same 6.5 client to access system as before. Should I rebuild/reindex the database? Is there something from the old 6.5 version I need to remove?? Thanks in advance!!!
Oke here is the problem. I hope sombody can help me with it.
After a lot of discussion, I finaly got the people that control the MS SQL server with my appertment as far to allow me to upgrade my access database to the MS SQL server. After this I've created an access project. Devellopping in access I concluded I made a mistake in the rowsource property of one of the tablefields. The people that control the MS SQL server don'n allow me to make changes to the database structure from within access. So I've to write a SQL statement to change this.
I have one 32-bit SQL 2000 server that is our enterprise-wide reporting server (we'll call it RS) and another 32-bit SQL 2000 server that serves as a stored proc data source for certain reports on that server (we'll call it DS). I am about to go through an upgrade/migration of DS to 64-bit SQL 2005 and was wondering if:
it is possible to just change the data source location on RS and point the old reports against the new DS server? there are any necessary steps to take within RS to make the data source (DS reference on RS) compatible with the destination (report on RS)? it is possible/easy to bulk-migrate all the RDL's for a particular data source from RS to DS?
Does anyone know any of the answers to these questions?
I just upgraded from Windows 7 to Windows 10, and now I can't connect to SQL Server 2008 R2 nor 2014 Express. The logs on both say it can't open master.mdf because it was originally formatted with a sector size 4096 but now it's 3072. But no sector sizes were changed. The only thing that changed was going from Windows 7 (64-bit) to Windows 10 (64-bit). How can this be resolved?
Copy mssqlsystemresource.mdf of a recently upgraded server and paste to an old server have same effect of upgrading via .exe installation?
My idea is to save time and administrative efforts in upgrades (Service Packs and/or Cumulative Updates) using this method.
According to BOL:
The Resource database makes upgrading to a new version of SQL Server an easier and faster procedure. In earlier versions of SQL Server, upgrading required dropping and creating system objects. Because the Resource database file contains all system objects, an upgrade is now accomplished simply by copying the single Resource database file to the local server.
I'm having problems upgrading the SQL express 2005 database engine services to 2005 standard 32 bit. I've also tried to install sql 2005 service pack 1 "SQLServer2005SP1-KB913090-x86-ENU.exe" and it did the same thing, upgraded everything except the database engine services. After that I tried another install from the run command "Z:Setup.exe SKUUPGRADE=1" and that failed at the same place as well.
My windows version is is 5.2 (build 3790.srv03_sp1_rtm.050324-1447:service pack 1
Below is a copy of the error log file from the install, any help would be greatly appreciated.
=== Verbose logging started: 11/7/2006 9:06:34 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (68:CC) [09:06:34:789]: Resetting cached policy values MSI (c) (68:CC) [09:06:34:789]: Machine policy value 'Debug' is 0 MSI (c) (68:CC) [09:06:34:789]: ******* RunEngine: ******* Product: z:SetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (c) (68:CC) [09:06:34:789]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (68:CC) [09:06:34:789]: Grabbed execution mutex. MSI (c) (68:CC) [09:06:34:805]: Cloaking enabled. MSI (c) (68:CC) [09:06:34:805]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (68:CC) [09:06:34:805]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (A0:24) [09:06:34:805]: Grabbed execution mutex. MSI (s) (A0:E0) [09:06:34:805]: Resetting cached policy values MSI (s) (A0:E0) [09:06:34:805]: Machine policy value 'Debug' is 0 MSI (s) (A0:E0) [09:06:34:805]: ******* RunEngine: ******* Product: z:SetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (s) (A0:E0) [09:06:34:867]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (A0:E0) [09:06:34:867]: Machine policy value 'TransformsSecure' is 1 MSI (s) (A0:E0) [09:06:34:899]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (A0:E0) [09:06:34:977]: File will have security applied from OpCode. MSI (s) (A0:E0) [09:06:44:055]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (s) (A0:E0) [09:06:44:086]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'z:SetupSqlRun_SQL.msi' against software restriction policy MSI (s) (A0:E0) [09:06:44:086]: SOFTWARE RESTRICTION POLICY: z:SetupSqlRun_SQL.msi has a digital signature MSI (s) (A0:E0) [09:06:53:289]: SOFTWARE RESTRICTION POLICY: z:SetupSqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (A0:E0) [09:06:53:289]: End dialog not enabled MSI (s) (A0:E0) [09:06:53:289]: Original package ==> z:SetupSqlRun_SQL.msi MSI (s) (A0:E0) [09:06:53:289]: Package we're running from ==> C:WINDOWSInstaller4cc6a2.msi MSI (s) (A0:E0) [09:06:53:367]: APPCOMPAT: looking for appcompat database entry with ProductCode '{778634FA-DB0F-4D0F-B55F-FB0461B36C44}'. MSI (s) (A0:E0) [09:06:53:367]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (A0:E0) [09:06:53:367]: Detected that this product uses a multiple instance transform. MSI (s) (A0:E0) [09:06:53:367]: MSCOREE already loaded, using loaded copy MSI (s) (A0:E0) [09:06:53:367]: Applying multiple instance transform ':SqlRun01.mst'... MSI (s) (A0:E0) [09:06:53:367]: Looking for storage transform: SqlRun01.mst MSI (s) (A0:E0) [09:06:53:367]: Validating transform 'SqlRun01.mst' with validation bits 0x809 MSI (s) (A0:E0) [09:06:53:367]: Transform 'SqlRun01.mst' is valid. MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: Patch MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary. MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: Applying regular transform to database. MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Validation 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Signature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RegLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AppSearch 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CompLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CustomAction 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Directory 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Registry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CreateFolder 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Icon 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAction 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ReserveCost 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TypeLib 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Feature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: PublishComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceControl 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleDependency 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleSignature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceInstall 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroup 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlConfig 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ActionText 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSku 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlStart 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Dialog 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlCollation 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlProducts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Control 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlEvent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlCondition 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListView 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ComboBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CheckBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: EventMapping 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RadioButton 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Upgrade 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TextStyle 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: UIText 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Shortcut 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Environment 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'DisablePatch' is 0 MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (A0:E0) [09:06:53:367]: Looking for storage transform: InstID01.mst MSI (s) (A0:E0) [09:06:53:367]: Validating transform 'InstID01.mst' with validation bits 0 MSI (s) (A0:E0) [09:06:53:367]: Transform 'InstID01.mst' is valid. MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: Patch MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary. MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: Applying regular transform to database. MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Property 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Validation 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Signature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RegLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AppSearch 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CompLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CustomAction 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Directory 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Registry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CreateFolder 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Icon 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAction 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ReserveCost 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TypeLib 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Feature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: PublishComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceControl 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleDependency 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleSignature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceInstall 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroup 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlConfig 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ActionText 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSku 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlStart 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Dialog 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlCollation 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlProducts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Control 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlEvent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlCondition 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListView 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ComboBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CheckBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: EventMapping 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RadioButton 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Upgrade 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TextStyle 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: UIText 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Shortcut 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Environment 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_BaselineCost 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_BaselineFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_BaselineData 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_PatchCache 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Looking for storage transform: InstName02.mst MSI (s) (A0:E0) [09:06:53:367]: Validating transform 'InstName02.mst' with validation bits 0 MSI (s) (A0:E0) [09:06:53:367]: Transform 'InstName02.mst' is valid. MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: Patch MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary. MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: Applying regular transform to database. MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Property 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Validation 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Signature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RegLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AppSearch 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CompLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: DrLocator 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Binary 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CustomAction 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Directory 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Registry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CreateFolder 3: -2147287038 MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Icon 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: InstallUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdminUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlAction 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ReserveCost 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: TypeLib 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Feature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: MsiAssembly 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: PublishComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ServiceControl 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleDependency 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleSignature 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ServiceInstall 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlGroup 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlConfig 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlScript 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ActionText 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlSku 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlStart 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Dialog 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlCollation 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlProducts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: FeatureComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Control 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ControlEvent 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ControlCondition 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ListBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ListView 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ComboBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: CheckBox 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: EventMapping 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: RadioButton 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Upgrade 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: TextStyle 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: UIText 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Media 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Shortcut 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: RemoveFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Environment 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_BaselineCost 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_BaselineFile 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_BaselineData 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_PatchCache 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: APPCOMPAT: looking for appcompat database entry with ProductCode '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'. MSI (s) (A0:E0) [09:06:53:382]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (A0:E0) [09:06:53:382]: Transforms are not secure. MSI (s) (A0:E0) [09:06:53:382]: Transforming table Property.
MSI (s) (A0:E0) [09:06:53:382]: Transforming table Property.
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Property 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Transforming table Property.
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Property 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Command Line: USERNAME=NW COMPANYNAME=WSDOT PIDKEY=********** INSTALLSQLSHAREDDIR=C:Program FilesMicrosoft SQL Server INSTANCENAME=AUTODESKVAULT INSTALLSQLDIR=F:Program FilesMicrosoft SQL Server INSTALLSQLDATADIR=F:Program FilesMicrosoft SQL Server SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=********** ENABLERANU=1 STPSETUPTHREADID=5032 STPSETUPPROCESSID=5992 EXTERNALCONTROL=1 ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_SharedTools,SQL_BC_DEP TRANSFORMS=:SqlRun01.mst;:InstID01.mst;:InstName02.mst MSINEWINSTANCE=1 UPGRADE=SQL_Engine REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=5992 MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{3185FC73-41E0-43F4-97DF-2254C4D7C667}'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding TRANSFORMS property. Its value is ':SqlRun01.mst;:InstID01.mst;:InstName02.mst'. MSI (s) (A0:E0) [09:06:53:382]: Product Code passed to Engine.Initialize: '' MSI (s) (A0:E0) [09:06:53:382]: Product Code from property table before transforms: '{778634FA-DB0F-4D0F-B55F-FB0461B36C44}' MSI (s) (A0:E0) [09:06:53:382]: Product Code from property table after multiple instance transforms: '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}' MSI (s) (A0:E0) [09:06:53:382]: Product Code from property table after transforms: '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}' MSI (s) (A0:E0) [09:06:53:382]: Product not registered: beginning first-time install MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (A0:E0) [09:06:53:382]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (A0:E0) [09:06:53:382]: User policy value 'SearchOrder' is 'nmu' MSI (s) (A0:E0) [09:06:53:382]: Adding new sources is allowed. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (A0:E0) [09:06:53:382]: Package name extracted from package path: 'SqlRun_SQL.msi' MSI (s) (A0:E0) [09:06:53:382]: Package to be registered: 'SqlRun_SQL.msi' MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (A0:E0) [09:06:53:382]: Machine policy value 'DisableMsi' is 1 MSI (s) (A0:E0) [09:06:53:382]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (A0:E0) [09:06:53:382]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (A0:E0) [09:06:53:382]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (A0:E0) [09:06:53:382]: Running product '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}' with elevated privileges: Product is assigned. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'NW'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'WSDOT'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTANCENAME property. Its value is 'AUTODESKVAULT'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTALLSQLDIR property. Its value is 'F:Program FilesMicrosoft SQL Server'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTALLSQLDATADIR property. Its value is 'F:Program FilesMicrosoft SQL Server'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding SECURITYMODE property. Its value is 'SQL'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding UPGRADEUSER property. Its value is 'sa'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding UPGRADEPWD property. Its value is '**********'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding ENABLERANU property. Its value is '1'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '5032'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '5992'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_SharedTools,SQL_BC_DEP'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding MSINEWINSTANCE property. Its value is '1'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding UPGRADE property. Its value is 'SQL_Engine'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '5992'. MSI (s) (A0:E0) [09:06:53:382]: TRANSFORMS property is now: :SqlRun01.mst;:InstID01.mst;:InstName02.mst MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '150'. MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccApplication Data MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccFavorites MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccNetHood MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccMy Documents MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccPrintHood MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccRecent MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccSendTo MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccTemplates MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccLocal SettingsApplication Data MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccMy DocumentsMy Pictures MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart MenuProgramsAdministrative Tools MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart MenuProgramsStartup MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart MenuPrograms MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart Menu MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccDesktop MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts MSI (s) (A0:E0) [09:06:53:429]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller4cc6a2.msi'. MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'z:SetupSqlRun_SQL.msi'. MSI (s) (A0:E0) [09:06:53:429]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (A0:E0) [09:06:53:429]: Machine policy value 'DisableRollback' is 0 MSI (s) (A0:E0) [09:06:53:429]: User policy value 'DisableRollback' is 0 MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 11/7/2006 9:06:53 === MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (A0:E0) [09:06:53:429]: Doing action: INSTALL MSI (s) (A0:E0) [09:06:53:445]: Running ExecuteSequence MSI (s) (A0:E0) [09:06:53:445]: Doing action: ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C Action start 9:06:53: INSTALL. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C property. Its value is 'C:Program Files'. Action start 9:06:53: ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C. MSI (s) (A0:E0) [09:06:53:445]: Doing action: CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 Action ended 9:06:53: ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 property. Its value is 'C:Program FilesCommon Files'. Action start 9:06:53: CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128. MSI (s) (A0:E0) [09:06:53:445]: Doing action: SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C Action ended 9:06:53: CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C. MSI (s) (A0:E0) [09:06:53:445]: Doing action: SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A Action ended 9:06:53: SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A. MSI (s) (A0:E0) [09:06:53:445]: Doing action: SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8 Action ended 9:06:53: SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8 property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8. MSI (s) (A0:E0) [09:06:53:445]: Doing action: ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF Action ended 9:06:53: SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:Program Files'. Action start 9:06:53: ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF. MSI (s) (A0:E0) [09:06:53:445]: Doing action: CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F Action ended 9:06:53: ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F property. Its value is 'C:Program FilesCommon Files'. Action start 9:06:53: CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F. MSI (s) (A0:E0) [09:06:53:445]: Doing action: CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683 Action ended 9:06:53: CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F. Return value 1. MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683 property. Its value is 'C:Program FilesCommon Files'. Action start 9:06:53: CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683. MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F Action ended 9:06:53: CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E Action ended 9:06:53: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 9:06:53: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E Action ended 9:06:53: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 9:06:53: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. MSI (s) (A0:E0) [09:06:53:476]: Doing action: ProgramMenuFolder.ConfigurationTools1033 Action ended 9:06:53: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding ProgramMenuFolder.ConfigurationTools1033 property. Its value is 'C:Documents and SettingsAll UsersStart MenuPrograms'. Action start 9:06:53: ProgramMenuFolder.ConfigurationTools1033. MSI (s) (A0:E0) [09:06:53:492]: Doing action: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: ProgramMenuFolder.ConfigurationTools1033. Return value 1. MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'C:Program Files'. Action start 9:06:53: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetMDACSxS Action ended 9:06:53: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding MDACSXS property. Its value is '1'. Action start 9:06:53: SetMDACSxS. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetInstanceName Action ended 9:06:53: SetMDACSxS. Return value 1. MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlInstanceName property. Its value is 'AUTODESKVAULT'. Action start 9:06:53: SetInstanceName. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetCollation Action ended 9:06:53: SetInstanceName. Return value 1. Action start 9:06:53: SetCollation. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetSecurityMode Action ended 9:06:53: SetCollation. Return value 1. MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlSecurityMode property. Its value is 'SQL'. Action start 9:06:53: SetSecurityMode. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetUpgradeUser Action ended 9:06:53: SetSecurityMode. Return value 1. MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlUpgradeUser property. Its value is 'sa'. Action start 9:06:53: SetUpgradeUser. MSI (s) (A0:E0) [09:06:53:492]: Skipping action: ErrorDisableNetworkProtocols (condition is false) MSI (s) (A0:E0) [09:06:53:492]: Skipping action: SetCluster (condition is false) MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetClusterSec Action ended 9:06:53: SetUpgradeUser. Return value 1. Action start 9:06:53: SetClusterSec. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetSaPwd Action ended 9:06:53: SetClusterSec. Return value 1. Action start 9:06:53: SetSaPwd. MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetUpgradePwd Action ended 9:06:53: SetSaPwd. Return value 1. MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlUpgradePwd property. Its value is '**********'. Action start 9:06:53: SetUpgradePwd. MSI (s) (A0:E0) [09:06:53:492]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: SetUpgradePwd. Return value 1. MSI (s) (A0:D0) [09:06:53:523]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI40E.tmp, Entrypoint: StreamSupportFiles MSI (s) (A0:C8) [09:06:53:523]: Generating random cookie. MSI (s) (A0:C8) [09:06:53:523]: Created Custom Action Server with PID 4592 (0x11F0). MSI (s) (A0:A8) [09:06:53:554]: Running as a service. MSI (s) (A0:A8) [09:06:53:554]: Hello, I'm your 32bit Impersonated custom action server. Action start 9:06:53: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap 1: 0 2: Iterating through _sqlSupportFiles entries Streamed sqlca.D20239D7_E87C_40C9_9837_E70B8D4882C2 to C:Program FilesMicrosoft SQL Server90Setup Bootstrapin{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}sqlca.dll MSI (s) (A0:E0) [09:06:53:664]: Doing action: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:90) [09:06:53:679]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI40F.tmp, Entrypoint: Do_LogInstallStart Action start 9:06:53: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap Property(SQL): CA DLL Path = C:Program FilesMicrosoft SQL Server90Setup BootstrapBin{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}sqlca.dll <Func Name='LaunchFunction'> Function=Do_LogInstallStart <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: Do_LogInstallStart PerfTime Start: Do_LogInstallStart : Tue Nov 07 09:06:53 2006 <Func Name='Do_LogInstallStart'> <EndFunc Name='Do_LogInstallStart' Return='0' GetLastError='203'> PerfTime Stop: Do_LogInstallStart : Tue Nov 07 09:06:53 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:E0) [09:06:53:773]: Doing action: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:04) [09:06:53:804]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI410.tmp, Entrypoint: GetDefaultDomain Action start 9:06:53: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=GetDefaultDomain <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: GetDefaultDomain PerfTime Start: GetDefaultDomain : Tue Nov 07 09:06:53 2006 <Func Name='GetDefaultDomain'> MSI (s) (A0!F4) [09:06:53:820]: PROPERTY CHANGE: Adding DefaultDomain property. Its value is 'WSDOT'. MSI (s) (A0!F4) [09:06:53:820]: PROPERTY CHANGE: Adding QuotedDefaultDomain property. Its value is 'WSDOT'. MSI (s) (A0!F4) [09:06:53:820]: PROPERTY CHANGE: Adding QuotedComputerName property. Its value is 'NWUCWFAUTODESK'. PerfTime Stop: GetDefaultDomain : Tue Nov 07 09:06:53 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:E0) [09:06:53:820]: Doing action: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:8C) [09:06:53:851]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI411.tmp, Entrypoint: RestoreSetupParams Action start 9:06:53: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=RestoreSetupParams Skipping Action: RestoreSetupParams (Condition is false) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:E0) [09:06:53:867]: Doing action: LaunchConditions Action ended 9:06:53: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:E0) [09:06:53:867]: Note: 1: 2205 2: 3: LaunchCondition MSI (s) (A0:E0) [09:06:53:867]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition` Action start 9:06:53: LaunchConditions. MSI (s) (A0:E0) [09:06:53:867]: Skipping action: Collation.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 (condition is false) MSI (s) (A0:E0) [09:06:53:867]: Doing action: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: LaunchConditions. Return value 0. MSI (s) (A0:C0) [09:06:53:882]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI412.tmp, Entrypoint: ShutdownServiceManager Action start 9:06:53: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=ShutdownServiceManager <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: ShutdownServiceManager PerfTime Start: ShutdownServiceManager : Tue Nov 07 09:06:53 2006 <Func Name='ShutdownServiceManager'> <EndFunc Name='ShutdownServiceManager' Return='0' GetLastError='2'> PerfTime Stop: ShutdownServiceManager : Tue Nov 07 09:06:53 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:E0) [09:06:53:914]: Doing action: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:D4) [09:06:53:929]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI413.tmp, Entrypoint: Write_sqlWellKnownAccountNames Action start 9:06:53: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=Write_sqlWellKnownAccountNames <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: Write_sqlWellKnownAccountNames PerfTime Start: Write_sqlWellKnownAccountNames : Tue Nov 07 09:06:53 2006 <Func Name='Write_sqlWellKnownAccountNames'> MSI (s) (A0!10) [09:06:53:945]: PROPERTY CHANGE: Adding AdministratorsGroup property. Its value is 'BUILTINAdministrators'. MSI (s) (A0!10) [09:06:53:945]: PROPERTY CHANGE: Adding PerformanceMontiorUsersGroup property. Its value is 'BUILTINPerformance Monitor Users'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding PerformanceLogUsersGroup property. Its value is 'BUILTINPerformance Log Users'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding UsersGroup property. Its value is 'BUILTINUsers'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding NetworkServiceAccount property. Its value is 'NT AUTHORITYNETWORK SERVICE'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding SCMNetworkServiceAccount property. Its value is 'NT AUTHORITYNetworkService'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding LocalSystemAccount property. Its value is 'NT AUTHORITYSYSTEM'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding LocalServiceAccount property. Its value is 'NT AUTHORITYLOCAL SERVICE'. MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding SCMLocalServiceAccount property. Its value is 'NT AUTHORITYLocalService'. <EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='0'> PerfTime Stop: Write_sqlWellKnownAccountNames : Tue Nov 07 09:06:53 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (A0:E0) [09:06:53:961]: Skipping action: PropSetSQLAutoStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false) MSI (s) (A0:E0) [09:06:53:961]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 9:06:53: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (A0:A8) [09:06:53:976]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI414.tmp, Entrypoint: CheckIIS Action start 9:06:53: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=CheckIIS <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: CheckIIS PerfTime Start: CheckIIS : Tue Nov 07 09:06:54 2006 <Func Name='CheckIIS'> MSI (s) (A0!6C) [
'You have to have a BackUps folder included into your release!
Private Sub BackUpDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BackUpDB.Click Dim addtimestamp As String Dim f As String Dim z As String Dim g As String Dim Dialogbox1 As New Backupinfo
addtimestamp = Format(Now(), "_MMddyy_HHmm") z = "C:Program FilesVSoftAppMissNewAppDB.mdb" g = addtimestamp + ".mdb"
'Add timestamp and .mdb endging to NewAppDB f = "C:Program FilesVSoftAppMissBackUpsNewAppDB" & g & ""
Try
File.Copy(z, f)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
MsgBox("Backup completed succesfully.") If Dialogbox1.ShowDialog = Windows.Forms.DialogResult.OK Then End If End Sub
Code Snippet
'RESTORE DATABASE
Private Sub RestoreDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
RestoreDB.Click Dim Filename As String Dim Restart1 As New RestoreRestart Dim overwrite As Boolean overwrite = True Dim xi As String
With OpenFileDialog1 .Filter = "Database files (*.mdb)|*.mdb|" & "All files|*.*" If .ShowDialog() = Windows.Forms.DialogResult.OK Then Filename = .FileName
'Strips restored database from the timestamp xi = "C:Program FilesVSoftAppMissNewAppDB.mdb" File.Copy(Filename, xi, overwrite) End If End With
'Notify user MsgBox("Data restored successfully")
Restart() If Restart1.ShowDialog = Windows.Forms.DialogResult.OK Then Application.Restart() End If End Sub
Code Snippet
'CREATE NEW DATABASE
Private Sub CreateNewDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
CreateNewDB.Click Dim L As New DatabaseEraseWarning Dim Cat As ADOX.Catalog Cat = New ADOX.Catalog Dim Restart2 As New NewDBRestart If File.Exists("C:Program FilesVSoftAppMissNewAppDB.mdb") Then If L.ShowDialog() = Windows.Forms.DialogResult.Cancel Then Exit Sub Else File.Delete("C:Program FilesVSoftAppMissNewAppDB.mdb") End If End If Cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesVSoftAppMissNewAppDB.mdb;
Jet OLEDB:Engine Type=5")
Dim Cn As ADODB.Connection 'Dim Cat As ADOX.Catalog Dim Tablename As ADOX.Table 'Taylor these according to your need - add so many column as you need. Dim col As ADOX.Column = New ADOX.Column Dim col1 As ADOX.Column = New ADOX.Column Dim col2 As ADOX.Column = New ADOX.Column Dim col3 As ADOX.Column = New ADOX.Column Dim col4 As ADOX.Column = New ADOX.Column Dim col5 As ADOX.Column = New ADOX.Column Dim col6 As ADOX.Column = New ADOX.Column Dim col7 As ADOX.Column = New ADOX.Column Dim col8 As ADOX.Column = New ADOX.Column
Cn = New ADODB.Connection Cat = New ADOX.Catalog Tablename = New ADOX.Table
'Open the connection Cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesVSoftAppMissNewAppDB.mdb;Jet
OLEDB:Engine Type=5")
'Open the Catalog Cat.ActiveConnection = Cn
'Create the table (you can name it anyway you want) Tablename.Name = "Table1"
'Taylor according to your need - add so many column as you need. Watch for the DataType! col.Name = "ID" col.Type = ADOX.DataTypeEnum.adInteger col1.Name = "MA" col1.Type = ADOX.DataTypeEnum.adInteger col1.Attributes = ADOX.ColumnAttributesEnum.adColNullable col2.Name = "FName" col2.Type = ADOX.DataTypeEnum.adVarWChar col2.Attributes = ADOX.ColumnAttributesEnum.adColNullable col3.Name = "LName" col3.Type = ADOX.DataTypeEnum.adVarWChar col3.Attributes = ADOX.ColumnAttributesEnum.adColNullable col4.Name = "DOB" col4.Type = ADOX.DataTypeEnum.adDate col4.Attributes = ADOX.ColumnAttributesEnum.adColNullable col5.Name = "Gender" col5.Type = ADOX.DataTypeEnum.adVarWChar col5.Attributes = ADOX.ColumnAttributesEnum.adColNullable col6.Name = "Phone1" col6.Type = ADOX.DataTypeEnum.adVarWChar col6.Attributes = ADOX.ColumnAttributesEnum.adColNullable col7.Name = "Phone2" col7.Type = ADOX.DataTypeEnum.adVarWChar col7.Attributes = ADOX.ColumnAttributesEnum.adColNullable col8.Name = "Notes" col8.Type = ADOX.DataTypeEnum.adVarWChar col8.Attributes = ADOX.ColumnAttributesEnum.adColNullable
'You have to append all your columns you have created above Tablename.Columns.Append(col) Tablename.Columns.Append(col1) Tablename.Columns.Append(col2) Tablename.Columns.Append(col3) Tablename.Columns.Append(col4) Tablename.Columns.Append(col5) Tablename.Columns.Append(col6) Tablename.Columns.Append(col7) Tablename.Columns.Append(col8)
'Append the newly created table to the Tables Collection Cat.Tables.Append(Tablename)
'User notification ) MsgBox("A new empty database was created successfully")
'Restart application If Restart2.ShowDialog() = Windows.Forms.DialogResult.OK Then Application.Restart() End If
End Sub
Code Snippet
'COMPACT DATABASE
Private Sub CompactDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
CompactDB.Click Dim JRO As JRO.JetEngine JRO = New JRO.JetEngine
'The first source is the original, the second is the compacted database under an other name. JRO.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program
Data Source=C:Program FilesVSoftAppMissNewAppDBComp.mdb; JetOLEDB:Engine Type=5")
'Original (not compacted database is deleted) File.Delete("C:Program FilesVSoftAppMissNewAppDB.mdb")
'Compacted database is renamed to the original databas's neme. Rename("C:Program FilesVSoftAppMissNewAppDBComp.mdb", "C:Program FilesVSoftAppMissNewAppDB.mdb")
'User notification MsgBox("The database was compacted successfully")
I'm working on an ASP.Net project where I want to test code on a localmachine using a local database as a back-end, and then export it tothe production machine where it uses the hosting provider's SQL Serverdatabase on the back-end. Is there a way to export tables from oneSQL Server database to another in such a way that if a table alreadyexists in the destination database, it will be updated to reflect thechanges to the local table, without existing data in the destinationtable being lost? e.g. suppose I change some tables in my localdatabase by adding new fields. Can I "export" these changes to thedestination database so that the new fields will be added to thedestination tables (and filled in with default values), without losingdata in the destination tables?If I run the DTS Import/Export Wizard that comes with SQL Server andchoose "Copy table(s) and view(s) from the source database" and choosethe tables I want to copy, there is apparently no option *not* to copythe data, and since I don't want to copy the data, that choice doesn'twork. If instead of "Copy table(s) and view(s) from the sourcedatabase", I choose "Copy objects and data between SQL Serverdatabases", then on the following options I can uncheck the "CopyData" box to prevent data being copied. But for the "CreateDestination Objects" choices, I have to uncheck "Drop destinationobjects first" since I don't want to lose the existing data. But whenI uncheck that and try to do the copy, I get collisions between theproperties of the local table and the existing destination table,e.g.:"Table 'wbuser' already has a primary key defined on it."Is there no way to do what I want using the DTS Import/Export Wizard?Can it be done some other way?-Bennett
Ok say I would like to build a table for of the following questions(say 6 questions for the sake of argument): Do I just stored the index of the radiobuttonlist. What are some resources that I could look at. Should I make a look up table.
5) If money were no object, I would live . . . Prefer not to say On a tropical island In a New York penthouse In an English castle On a Texas ranch In a Malibu beach house In a mountain retreat (Selected) On the moon None of the above
1 ---> 2 ---> 3 ---> 4 ---> 5) --->6 This is the question we are looking at. 6 --->
How should I create the database table for the above example.
I am new to SSIS. I have been struggling with this for the past one week. I have a weird task. I need to import several tables from one database to a different server with a new database name. We need to do this at the end of every year. The main problem here is that the number of tables varies every year. You may not have all the tables as last year or may have more tables. So I need to create a dynamic task that takes care of this every year without changing the package.
I have performed the following tasks **
1. Create a new dynamic database. ( I have used Execute SQL Task to do this) 2. Copy all the table structures ( I have used Execute SQL Task to do this)
3. Import Data. This is the main problem. I was trying to create a dynamic connection string with variables as suggested in several forums but I finally came to know that this cannot be done if the table structures are different as the metadata cannot be refreshed at runtime.
4. The final step to create a process to validate the data (the count from each table for both source and destination. I think this can be done with Sql task.
What is the best method to do this? My DBA does not like “Transfer SQL Objects Task” or “transfer Database Task”. I would like to create this as a dynamic process.
In SSMS, I connect Object Explorer to a partially contained database using a contained user login with password. This user has a database role of dbdatareader. When I try to expand the Tables in the database, I get the error:
The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
Is there a way to set permissions for the contained user so that this could be done?
I'm using SQL Server Management Studio Express and I'm trying to figure out how to copy a table(s) from my local database to my web hosting database. I know how to do it in 2000, but it's completely different now. Is this feature not allowed on SSMSE? If so, then how do I deploy database tables to a web host?Also, how do you add local database(s) to SSMSE? I tried to use 'attach database' in SSMSE and it wouldn't allow me to navigate to My Documents folder where the database resides. Thanks...
I am fairly new to VS 2005 and SQL Server CE. I have developed a Desktop Windows application using VB 2005 and the SQL Compact Edition Database. This application will sell to users via web download.
When they download a service patch, or updated version, I wish for them to retain the data in their present database. In other words, fill the new database with the old data. The new table structures will remain intact except for added columns at the end.
Question is how to save the old data and update the new database with it. Is there an easy way to do this, or do I need to write a module to save a database copy, and update the new database with content at install time?
hi, I have a access database. In this database there are 10 tables and this tables are related to each other. I want to move these tables to another database according to a field in XYZ table (vertical fragmentation).
for example there is name coloumn in the XYZ table and I want to take only joe lines and other tables related to that from database A and move it to database B
I have two Databases with the same name that reside in different servers. The two servers are linked servers. Each database consists of 5 Tables. The tables have identical names in each database.
The database in ServerA has 5 tables with data, the database in ServerB also has 5 tables with the same schema as ServerA, however the 5 identical tables in ServerB contain no data.
I need to populate the 5 tables in ServerB with the Data from the 5 tables in ServerA.
What SQL code or script can i use to populate the 5 tables in ServerB
i am using visual web developer 2005 and SQL Express 2005 with VB as the code behindi have two databases . i want to copy all the tables with all the contents from one database to another database programaticallyhow to achieve this ?please help me
We're going to be upgrading our Server from 6.5 to 7.0. In addition we're getting a new SQL Server Box.
Which of the following is better: a) Install SQL 6.5 on the new box, restore the DB from old box to the new box, then install 7.0 on the new box and use the upgrade wizard to upsize the DB. (We'll have room to leave the 6.5 devices on the box after upgrading.) or b) Install SQL 7.0 on the new box and upsize the db across the network (100megabit network cards).
Thanks,
Kevin M. Tupper EZLinks Golf, Inc. http://www.ezlinksgolf.com
I'm following a white paper and have run chkupg65 and am stuck at resolving keyword conflicts. I see many TechNet references about fixing them...but none about how. A little help? Below are the conflicts: Keyword conflicts Column name: SyncModification.ACTION[SQL-92 keyword] Column name: Jobs.EXPIREDATE[SQL-92 keyword] Column name: SqlStoreTable.SIZE[SQL-92 keyword] Column name: JobDetails.TIME[SQL-92 keyword] Column name: SchedulerSafeDelete.TIME[SQL-92 keyword] Column name: SMSEvent.TIME[SQL-92 keyword] Column name: SyncModification.TIME[SQL-92 keyword] Column name: vJobDetails.TIME[SQL-92 keyword] Column name: vSMSEvent.TIME[SQL-92 keyword] Column name: Sites.TIMESTAMP[SQL-92 keyword] Column name: QueryExpressions.VALUE[SQL-92 keyword]
Does anyone know of a good book or resource on what's the best way to upgrade 6.5 to 2k? Or generally how would you do that considering you need to do on more then 50 servers?
So I'm using Visual Studio's one click deployment to install/update software for users. SQL Express 2005 is the default, and I need to get all current and new users to update to SQL Express 2005 SP2. Ontop of that, I need to change the sa password for all current users (I should be able to manually set it for the new guys).
The problem I'm having is that instead of just updating the current SQL Express engine installed, it creates a new instance of the SQL Express engine when installing SQL Express SP2.
Is there anyway to just update SQL Express to SP2? Is there an easy way to change the sa password when doing so?
I have an application which installs MySQL 3.23. It's hard-coded. Irealize there are newer versions, so I am thinking, what's easiest:1) install the application with its default 3.23 and then run a scriptto convert 3.23 to 4.1 or later,or2) modify the application to install a newer version of MySQL from thestart.
I'm in the process of upgrading a gazillion apps from using .MDB files to using SQLCE 3.5. (Or, at least planning the upgrade). Is there an easy way to save existing .MDB files as .SDFs? Also, we have an occasional app that's web based (eg. certification exam, where we have 10 people take it online at the same time, in one day, and the database keeps the score, questions, etc.); is it a good idea to move that kind of app to SQLCE from MDB?
