Link to home
Start Free TrialLog in
Avatar of Antonio C
Antonio CFlag for Italy

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
Avatar of lcohan
lcohan
Flag of Canada image

Before upgrading the current SQL Server please make sure to at least run the upgrade advisor called now "Data Migration Assistant" https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017 to see if there are any breaking changes at the SQL database level and also please make sure to take a FULL backup of all databases prior to the upgrade and keep it safe just in case.
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.
ASKER CERTIFIED SOLUTION
Avatar of Seth Simmons
Seth Simmons
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 ?
Avatar of Antonio C

ASKER

Yes
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?
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.