First thing to check is whether the password for the account has expired. If not there is a free tool available from Microsoft which will help you diagnose any SPN...

You will need to check the purchase order when the licenses were bought or speak to your license vendor or Microsoft. It's not stored in any log or setup file.

Thanks

Licensing is done per core so if the server is 10 core then you will need to buy 10 licenses. However, what you need to do first is speak to...

I've used QA and Learning Tree in the past and both are good. QA have a lot of locations around the UK but if you are unable to get to...

Do you take server backups as well as database backups? I think that will be the only way you'll be able to recover the deleted data.

It's a lesson for you...

I keep all non production databases in simple recovery and take a full backup each night.

Thanks

You need to be on 2008 SP4 to upgrade to 2017.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-2017

Just as an aside make sure you test thoroughly before going into production as performance may be very different...

I'm in the UK and I know of at least 1 airline that uses SQL Server and I'm sure that many others will do. I'm curious as to why you...

There's your problem, you are trying to migrate from 2016 to 2012. You'll need to migrate to 2016 or above.

Thanks

Is your Express edition 2012 too??

Are you running 2012 Express edition??

Thanks

How are you doing the migration? You should be able to just backup the database and restore it to 2012 standard/enterprise edition.

Thanks

Nope, put a where clause in there using the ID field and you'll probably see a difference but as Lynn said why don't you test it yourself?

Thanks

The index won't be used so both the same.

Thanks

Go into your profile and there is an option to view the leaderboards.

Thanks