Thanks Perry. Is there any documented reference for this?

Hi Troy,

Thanks for your very detailed response - that was my impression of the licensing rules. Unfortunately the solution is based on a physical implementation (POSE) as there was no...

You can download the SQL Server 2014 tools from this link http://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx - you want the "SQL Server Management Studio Express (SQLManagementStudio)" option.

Just to keep the comedy going.....

If you have the license key from your SQL Server 2014 installer you should be able to use it on the SQL Server 2012 media....

Could you not just restore the old MSDB database to a dev/test/staging server somewhere and script out the jobs from there to import into your production server?

I think this is...

HowardW (7/31/2014)

---

Whether or not this is a valid licensing scenario (I agree with Grant - find out from MS or a reseller), the costs of licensing a whole 40 cores...

Thanks Grant - I'll make enquiries with Microsoft.

Thanks Grant - I'll make enquiries with Microsoft.

You could check using:

USE [master]

GO

SELECT *

FROM sys.master_files;

That will list all the files for all the DBs on the instance.

You could consider running File Monitor (http://technet.microsoft.com/en-gb/sysinternals/bb896642.aspx) and Process Monitor (http://technet.microsoft.com/en-gb/sysinternals/bb896645.aspx) to see if the new instance is trying to access any files that belong to the original instance.

We run several servers, however, for our main OLTP cluster each node is 12 core (2 sockets x 6 core) running 128GB RAM. This was a hardware refresh from 4...

Thanks for the easy points!

That has worked brilliantly.

Thank you for your help, this is a fantastic place to learn and ask questions.

We have the same messages when our DBs which are hosted on a SAN are being backed up via a snapshot. In our logs the order of the messages usually...

It appears that there is conflicting documentation about this option. If you see the BOL http://msdn.microsoft.com/en-us/library/ms181714(SQL.90).aspx, you'll notice that it explicitly says you can exceed the 'max degree of...