We have SQL Server 2008 R2, which is in production & cannot be shutdown at this stage. I have installed SQL Server 2016 Standard Edition. Can I copy the databases, users and logins, with .ldfs
, .mdfs
& .ndfs
, or use backups to restore to the server running 2016 Standard Edition?
Note that my SQL Server 2008R2 Enterprise databases do not utilize any of the Enterprise features.