Monday, August 26, 2013

[SQL 2012] Does this sound like a reasonable plan for an in-place upgrade to SQL2012?

[SQL 2012] Does this sound like a reasonable plan for an in-place upgrade to SQL2012?

Does this sound like a reasonable plan for an in-place upgrade to SQL2012?

Posted: 26 Aug 2013 02:49 AM PDT

First, before anyone yells at me that in-place upgrades are crazy talk and just install SQL2012 clean, I have *NO* control over these machines, and likely little input into the process anyways. This is for a migration of our in-house Sharepoint to another facilitys' SQL infrastructure, and one of the Sharepoint guys asked me about upgrading.Anyways.The plan the SP guy suggested would be for the new facility to snapshot their SP SQL server (presuming it's a VM,) then take backups of all the DBs on the SQL, then in-place upgrade. The bail-out plan would be to (if needed) restore the VM snapshot, then if needed restore the DBs from the backups taken just after the snapshot.To me, this sounds like a reasonable plan presuming a clean load of a new SQL Server isn't an option. You've got backups of the DBs, plus you can restore the VM back to how it was before you did anything.Thanks,Jason A.(as for why I'm worrying about this if I'm not going to be involved? If someone asks me a question I want to give them the best answer I can.)

Running SQL 2005 SSIS packages that read FoxPro files in SQL 2012

Posted: 26 Aug 2013 02:44 AM PDT

We are in the process of upgrading to a new SQL 2012 server but we have many packages that load data from dbf files created with FoxPro into one of our databases. We have not converted the packages and run them with DTS but we get the following error:Error: 2013-08-26 11:05:27.36 Code: 0xC0209303 Source: BenchmarkLoad Connection manager "OLEDB NPIONE.Investment.middleTierSQL" Description: The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".End ErrorError: 2013-08-26 11:05:27.36 Code: 0xC020F42A Source: BenchmarkLoad Connection manager "OLEDB NPIONE.Investment.middleTierSQL" Description: Consider changing the PROVIDER in the connection string to SQLNCLI11 or visit http://www.microsoft.com/downloads to find and install support for SQLNCLI.1.End ErrorI searched for OLEDB and ODBC drivers for SQL 2012 64 bit but cannot find any that is newer than the 2005 that we have. What can I do short of changing the source files to overcome this issue?Thanks in advance,Eduardo

SQL Server 2012 install failing on home laptop

Posted: 25 Aug 2013 06:54 AM PDT

SQL Server 2012 install is failing on my home laptop, which is running Windows 7 Home Premium SP1.I've attached a Word doc containing screenshots of each dialogue window as I progress through install. You'll see the window where install fails has green process bar 1/3 over and status is: Install_sql_engine_core_inst_loc_Cpu64_1033_Action.The main error message is:TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup------------------------------Windows Installer error message: The system cannot read from the specified device.Windows Installer file: D:\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msiWindows Installer log file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130825_104925\sql_engine_core_inst_loc_Cpu64_1033_1.logDoes this point to bad iso image on DVD? (I wish it was possible to install directly from web), or is this pointing to some other problem anyone has encountered before?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog