Solved

SQL Server 2016 Stability and Upgrade

Posted on 2016-08-18
2
45 Views
Last Modified: 2016-08-22
We would like to take the leap from SQL Server 2008 32 bit to  SQL Server 2016 x64 however, I have a couple of questions about the upgrade best practices.

1. Is it best to detach and reattach the databases from SQL Server 2008 32 bit to  SQL Server 2016 64 bit? Or should we backup our SQL Server 2008 32 bit databases and restore them to the SQL Server 2016 64 bit instance?

2. How stable is SQL 2016? Is it even worth waiting for SP1 to come out?

3. Those using  SQL 2016, have you found any upgrade issues or performance problems?

4. For SQL Vmware VMs do you make the drives containing the databases thin provisioned or thick provision eager zeroed?

Thanks

-Current server version: Windows server 2008 64 bit with  SQL Server 2008 32 bit.
-Future server version:  Windows server 2012 R2 64 bit with  SQL Server 2016 64 bit.
0
Comment
Question by:CityInfoSys
2 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 total points
Comment Utility
I have upgraded a couple of servers and dev-computers to SQL 2016 and I had no issues. You can go write away.

I always prefer to detach and reattach because I am sure from the moment it is detached that nobody will connect and modify the old database.

I can't say for VMWare.
0
 
LVL 1

Author Comment

by:CityInfoSys
Comment Utility
Thanks
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now