Antonio C
asked on
Upgrade SQL 2008
I should upgrade Sql 2008-r2 to sql2016 directly in the same instance and same server
do you have any suggestions or contraindications
do you have any suggestions or contraindications
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't do it at all if you can avoid it, instead do a clean install. But, if you must do it, then follow a very careful process, such as described by the other posters.
is your Sql 2008-r2 running on Windows Server 2012 ?
ASKER
Yes
ASKER
Hi, I executed Data Migration Asssistant
has been in assessment in progress for about 16 hours
is it right that it lasts so long for a DB of only 30GB?
has been in assessment in progress for about 16 hours
is it right that it lasts so long for a DB of only 30GB?
No - that is very unlikely to take soo long - I in my servers for a few mins for DB's ~1TB in size as the toll is not looking at data much but just code objects and metadata.
Also please check each iten from the "Pre upgrade Checklist" as noted here https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-ver15 to make sure your in-place upgrade will go smooth. BTW you must run at least SQL Server 2008 R2 + SP3 or later in order to be able to perform the in-place upgrade to SQL 2016.