migrating instance from 2008r to 2016 Enterprise i have a client that wants to migrate his data to sql server 2016 . currently they have 2008r and the databases are huge(total of 4 tb) on the instance. what is the best way to performe this with the least amount of down time? i thought about mirroring but im not sure it can be done  between the two versions. if so what are the steps to do so ? if im missing information please let me know. thanks
Best way to migrate a huge SQL Server database with low downtime over network Problem definition  Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB.  Having little to no downtime for this would be ideal.  Workload  Those databases are used for a .NET website and are constantly getting updated.   Having it not available over the weekend would be acceptable though. The currently in use DB would remain the only one in use until the switch over to the new one.  That switch would ideally be made just by changing DNS entries to point to the new DB server while making sure the DB is not being updated.  Also, time taken by this operation does not really matter as long as the switch from one server to the other (downtime) is kept low.  Approaches considered   Backup and restore  This has been done in the past but involved a high downtime even though it was done through an internal network, so more efficiently than through Internet Log shipping  As far as I understand, this approach would minimize downtime by configuring a master/slave and transferring  an exact copy of the master DB to its slave being read only. As mentioned above, no access to the slave would be necessary and we just need a way to have a replica of the master DB without data corruption.   It also seems to be quite efficient in terms of resources utilization and wouldn't impact to much the master performance.   I might be wrong about this approach so feel free to correct me. Database mirroring  I'm not too aware of that approach but it seems like a valid option. No need to have real time sync and performance of the master is quite important so asynchronous would be the way to go if this approach were to be chosen. Other options?  That server runs directly on bare metal hardware so lower level solutions are unfortunately not an option. Maybe there is a better way to get this done?   Constraints  As described, those databases are quite big to the point they are hard to maintain but that's an other problem.  The versions of SQL Server will be the same (Microsoft SQL Server 2012 Enterprise 64-bit).  It will have to be transferred over network between two datacenters so most probably over Internet. Having disks sent from one site to the other for an initial sync is unfortunately not an option. Having some sort of security for the transfer would be ideal but we will do the best of this situation.  That should give a quite good overview of our needs for this task and hopefully some of you had to face that situation before.
I haven't been able to find my favorite questions in the official Stack Exchange Android app.  Looking at my accounts page gives nothing on them. color code in SharePoint calendar LaTeX Classes or Styles for Schedules and/or Calendars? What happens if I beat Ganon in Zelda: Breath of the Wild? I'm close to maxing out my character and I want to beat Ganon solely for the TRUE ending, but I'm too scared of losing some of my personal favorites from the Guardian Spear++ to fighting those damned Guardians (it was so fun).  So, after beating Ganon    Do monsters disappear? - Including the corrupted Guardians, but also the blood moons, I don't want to just face off against the Yiga Clan... Am I gonna run out of resources? - As a survival game Zelda BOTW has some emphasis on the survival genre but to me it is a survival-esque action-adventure game. Are special weapons still available when you max out? - Like the Savage Lynel Spears or Swords) How to plot a graph from its adjacency matrix and coordinates of vertices? A similar question is . If we give all the data of the vertices's coordinates and the graph's adjacency matrix, how to plot it with tikz, pstrick or other tool in tex?   here are the data of adjacency matrix and coordinates  Coordinates:{{0.809,0.588},{0.309,0.951},{-0.309,0.951},{-0.809,0.588},{-1.,0.},{-0.809,-0.588},{-0.309,-0.951},{0.309,-0.951},{0.809,-0.588},{1.,0.}}  Adjacency matrix: {{0,1,0,0,1,0,1,0,0,1},{1,0,1,0,0,1,0,1,0,0},{0,1,0,1,0,0,1,0,1,0},{0,0,1,0,1,0,0,1,0,1},{1,0,0,1,0,1,0,0,1,0},{0,1,0,0,1,0,1,0,0,1},{1,0,1,0,0,1,0,1,0,0},{0,1,0,1,0,0,1,0,1,0},{0,0,1,0,1,0,0,1,0,1},{1,0,0,1,0,1,0,0,1,0}}   Sometimes the number of data is too large to put the data in the main tex file. It would be better to import the data from external files. . How can I execute `date` inside of a cron tab job? I want to create a log file for a cron script that has the current hour in the log file name. This is the command I tried to use:  0 * * * * echo hello &gt;&gt; ~/cron-logs/hourly/test`date "+%d"`.log   Unfortunately I get this message when that runs:  /bin/sh: -c: line 0: unexpected EOF while looking for matching ``' /bin/sh: -c: line 1: syntax error: unexpected end of file   I have tried escaping the date part in various ways, but without much luck. Is it possible to make this happen in-line in a crontab file or do I need to create a shell script to do this? What is the maximum number of downvotes a question can have I was just wondering what the maximum number of down votes a question can have before it is removed from StackOverflow. Port Forwarding to a VMware Workstation Virtual Machine Is gcc 4.8 or earlier buggy about regular expressions? Regulated AC power supply? When does $P(x)=\sum_{n=0}^{\infty}{\frac{n!}{n^n}\cdot x^n}$ with $x\in \mathbb{C}$ converge? Prove: If a sequence converges, then every subsequence converges to the same limit. How to use numpad / on a keyboard without a numpad? I've just got into Blender, and I like it a lot. But as I just switched from a stationary computer to a MacBook, I've got some new problems regarding the numpad. I can use 1-9 perfectly, But I have no idea how to emulate buttons like / (used to enter local view). I've searched the web for an answer, but I can't find any. Why is it wrong to serial voteup someone you like his answers?  Sometimes I just came to stackoverflow to read certain people answers(there are 4 guys currently) I have their profile bookmarked in my browser and in my free time at office I go to their profile and read their answers and learn a lot from them, but because I'm afraid to be a serial voter, I dont voteup them.   I think there is nothing wrong with that, if there is, please let me know. Query Feature and Usage based entitlements license Why is the first band on a resistor never black? I'm taking an electronic circuit analysis class, and I was asked to give the color of the 3rd band of a 1MΩ resistor. My answer was blue, thinking it could be black-brown-blue (01 * 1MΩ), but the automated quiz said the correct answer was green (brown-black-green).  So I did some research, thinking there were just multiple correct answers, and I read in a few places that the first band on a resistor is never black (0). Why is this? Does a black first band have some other meaning? It would really help me remember it if I knew the history or reasoning behind it.  This question has been answered. For further reading on zero-ohm resistors mentioned in the answers and comments here, I found these questions and answers helpful: Historical locks are sometimes applied to questions.   What is a historical lock? What is the purpose of a historical lock? How are questions affected by historical locking? When is it appropriate to lock a question for historical reasons?  When is it not appropriate? How do I request a historical lock for a question? What should I do if I notice a serious problem with a historically-locked question or one of its answers? How to re-enable tray icons for applications in Ubuntu? Continuous and preserves measurability $\implies$ preserves null sets. Why does Ubuntu fail to run .exe files? / How do I run .exe?