Tuesday, July 2, 2013

[SQL 2012] Install sql2012 with sp1 in 1 install

[SQL 2012] Install sql2012 with sp1 in 1 install

Install sql2012 with sp1 in 1 install

Posted: 01 Jul 2013 06:17 PM PDT

Hi therei am trying to automate sql 2012 installation and i dont want to install sql2012 and sp1 separately. I want it in 1 install file.I am trying to slipstream sql2012 and sp1 installation similar to sql2008r2and sp2 http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspxIs there any way we can do this in sql 2012? or does MS release installer which has sql2012 with sp1 in it? Danny

SQL Server 2012 Upgrade Advisor: The network path was not found

Posted: 02 Jul 2013 01:05 AM PDT

We installed the SQL Server 2012 GUI tools, including "Upgrade Advisor," on a new virtual machine. We can connect to the old SQL Server 2008 R2 clustered databases just fine over port 1433 using SQL Server Management Studio 2012, but Upgrade Advisor is a mixed bag. Here are the steps we are taking:- Click on "Start," "All Programs," "Microsoft SQL Server 2012," "SQL Server 2012 Upgrade Advisor"- Fill in the server name with a valid SQL Server Network Name- Select "SQL Server" as the only component to be analyzed- Fill in the instance name with a valid named instance- Use Windows Authentication (the default)- The "SQL Server Parameters" window displays valid database names, meaning that we have a successful connection to the desired SQL Server instance at this point- Leave all of the databased selected (the default)- Click the "Run" button- The "Upgrade Advisor Progress" window spins for a while and eventually generates the following error:[code="plain"]TITLE: mscorlib------------------------------The network path was not found.------------------------------BUTTONS:OK------------------------------[/code]Why would Upgrade Advisor be able to display the database names after making a successful connection only to fail later saying that it cannot find the network path?I have seen Google references that mentioned the creation of an alias as a work around, but I have not found the right permutation. (For example, [url]http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6d1d9d4-c07f-460f-a8f4-c6f66839578a/sql-2012-upgrade-advisor-the-network-path-was-not-found[/url] .)I opened a support call with Microsoft, and I was told flatly that Upgrade Advisor is *NOT A SUPPORTED PRODUCT*. Go figure... Yeah, I am disappointed in the response, but it's not worthwhile to chase Microsoft on this one.Does anyone have any ideas?

Multiple SQL Standard Instances on 4 Processor/32-core Server

Posted: 01 Jul 2013 09:28 PM PDT

We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for 3rd-party apps.Is there any issue with simply installing two instances of SQL Standard on the server - one for 2012 and one for 2008 R2 ? Each instance will use up to 64GB out of the 192GB and 16 cores. If we did this with Enterprise, the licensing would be a fortune and the Enterprise features are not needed.

scripting table triggers

Posted: 01 Jul 2013 04:02 AM PDT

I recently did a "poor man's" backup by using SSMS to script table creates for all my tables. After I had done this I noticed that the one table that I have a trigger on did not include "trigger create" scripting. Is there a way in SSMS to script the table AND any triggers in one step?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog