I'd also advise checking that the account that is doing the restore has the ability to 'Perform Volume Maintenance', this will enable instant file initialisation.

A quick search for...

Hi,

We (the data team) at my company actually just did a number of short Proof of Concepts (POC's) on this looking at SQLAzure, SQL Azure DW and RedShift ...

Thanks for the reply, you are correct running the following prevents execution.

DENY EXECUTE ON sp_executesql TO testuser

Thanks,

Nic

Hi,

Sorry I've not, could you not re-attach back to the 2014 instance and then back that up and restore it to your 2017? personally when moving versions editions...

Hi Andrew,

Thanks for taking the time to reply, I really appreciate it.
I think based on a variety of things our best bet is to stick with SQL...

Thank you both for the answers.

Regarding restoring the database and using MOVE, would this then require to me to restore the master key afterwards? or would that only...

Hi,
I'm sorry I don't understand what you are asking.

Are you saying you want to do an evaluation of SQL Server running on Windows? If so whats the...

Hi Steve,

Good idea. I'll give it a try and let you know how it goes.

Thanks,

Nic

Hi,

Thanks again for