Solved

SQL Server 2016 Stability and Upgrade

Posted on 2016-08-18
2
67 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 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 41761173
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
ID: 41765326
Thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS I need to get the most old file from a folder in the SSIS package. 3 23
SQL Help 27 40
Webservices in T-SQL 3 30
SqlServer no dupes 25 34
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

813 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

8 Experts available now in Live!

Get 1:1 Help Now