Windows 2003 server sql server 2012

In this tutorial, we’ll learn how to copy or move an SQL Server from one server to another. Unlike manual migration options, we will perform the migration automatically, and transfer not just the SQL server itself, but also all configurations, schemas, databases – and the actual applications that the server runs (and that you need to run on the new server).

This tutorial works for Server 2003, Server 2008, Server 2012, Server 2016 and even Server 2019. Transfer can be physical-to-physical (P2P), physical-to-virtual (P2V), virtual-to-virtual (V2V), as well as transfer to Cloud servers.

The goal of this tutorial is to copy server applications to the new server completely, and generically: any application, even custom or in-house applications, will be moved to the new server, including their configurations, databases and of course files.

Note that the transfer we are doing is native transfer. The applications are really transferred to the new server, becoming installed on it, and retaining their configurations. This does not rely on any containerization or app virtualization processes, and delivers true, native migration.

The tutorial is below, and before that – a video tutorial and a few common questions about Windows Server migration.

Video tutorial – SQL Server migration, including applications

How to perform SQL server migration to a new Windows server

Before the migration:

1. 1. Audit your servers: Make sure you know what the server is responsible for, and which applications are running on it. Make sure you know how to verify that an application has indeed been transferred successfully to a replacement server, and that users are able to work with it as before.

Tip: If your organization is not using a centralized management tool (e.g. Microsoft SCCM) to monitor your servers, you can download the free Microsoft Assessment and Planning (MAP) Toolkit here. You can also use Zinstall’s free server diagnostic at this link. It allows for quick check-up of server’s entire software and hardware list.

2. Schedule your migration time slot: Migrations take time, and during that time, your users may be affected to some extent. If possible, try and schedule the actual migration to be performed after hours or during a weekend. Note that you don’t actually have to stay there yourself at that time: application migration can be performed remotely or launched in advance in unattended mode.
3. Verify your backups are up to date, and are actually restorable: Any major upgrade may go wrong, and without a valid up-to-date backup, you risk losing everything you’ve had on the server. Make sure to verify that the backup you have is not damaged and ready to be restored if needed!
4. Decide on replacement type: Once you have decided to replace a server, you have several options regarding what the replacement will be. It may be a physical Windows 2012, 2016 or 2019 server, a virtual server running on premise, or even a Cloud-based server running off premise. WinServ supports any of those transfers, so migration difficulty does not vary significantly with your choice.

Applications, profiles, shares and data migration

Here is the process for performing a migration for one Windows server to another:

1. Fully update and patch the target server.
2. Add the target server to the domain.
3. Run WinServ on the source server and on the target server.
4. At this stage, you can either transfer directly over the network, or perform an indirect migration – capturing the source server to a container on network storage / cloud storage, and then deploying from that container on the new server.
5. Before you start the transfer, you also have an option to pick and choose applications and data that you want to transfer. Or, just run the transfer to migrate everything.
6. Press “Go” on the target server in order to initiate the transfer.

Depending on the amount of transferred data and applications, the actual transfer may take several hours to complete. You will see progress indication throughout the process.

Dealing with incompatible applications:

Some legacy 3rd party applications running on Windows Server 2003 may be incompatible with Windows Server 2008 or Windows Server 2012. Such applications are generally legacy DOS, 16-bit or 32-bit only software, which has not been updated for newer OS versions. It is strongly recommended to eliminate these applications from the production environment as soon as possible.

If these applications cannot be eliminated immediately, and are mission-critical for continued operation of the organization, the recommended option to preserve them operation is to perform a virtualized migration of those applications, into a virtual Server 2003 instance running on newer replacement server. Then, continue to take the steps required to phase those applications out and stop running the virtualized 2003 instances.

Such P2V (physical to virtual) migration should be done using WinServ as well.

After the migration:

Once the migration process is complete, it is time to verify the results.

1. You may need to adjust your domain’s DNS to point to the new server where needed. For example, changing the CRM-SERVER DNS entry to the new server’s address.
2. Same goes for login scripts and GPO policy.
3. Launch every application and console you use, and verify they load correctly.
4. Using a client workstation, verify that clients can access the migrated server correctly and their applications run without issues.

Congratulations! Your SQL server migration is now complete.

Распознавание голоса и речи на C#

UnmanagedCoder 05.05.2025

Интеграция голосового управления в приложения на C# стала намного доступнее благодаря развитию специализированных библиотек и API. При этом многие разработчики до сих пор считают голосовое управление. . .

Реализация своих итераторов в C++

NullReferenced 05.05.2025

Итераторы в C++ — это абстракция, которая связывает весь экосистему Стандартной Библиотеки Шаблонов (STL) в единое целое, позволяя алгоритмам работать с разнородными структурами данных без знания их. . .

Разработка собственного фреймворка для тестирования в C#

UnmanagedCoder 04.05.2025

C# довольно богат готовыми решениями – NUnit, xUnit, MSTest уже давно стали своеобразными динозаврами индустрии. Однако, как и любой динозавр, они не всегда могут протиснуться в узкие коридоры. . .

Распределенная трассировка в Java с помощью OpenTelemetry

Javaican 04.05.2025

Микросервисная архитектура стала краеугольным камнем современной разработки, но вместе с ней пришла и головная боль, знакомая многим — отслеживание прохождения запросов через лабиринт взаимосвязанных. . .

Шаблоны обнаружения сервисов в Kubernetes

Mr. Docker 04.05.2025

Современные Kubernetes-инфраструктуры сталкиваются с серьёзными вызовами. Развертывание в нескольких регионах и облаках одновременно, необходимость обеспечения низкой задержки для глобально. . .

Создаем SPA на C# и Blazor

stackOverflow 04.05.2025

Мир веб-разработки за последние десять лет претерпел коллосальные изменения. Переход от традиционных многостраничных сайтов к одностраничным приложениям (Single Page Applications, SPA) — это. . .

Реализация шаблонов проектирования GoF на C++

NullReferenced 04.05.2025

«Банда четырёх» (Gang of Four или GoF) — Эрих Гамма, Ричард Хелм, Ральф Джонсон и Джон Влиссидес — в 1994 году сформировали канон шаблонов, который выдержал проверку временем. И хотя C++ претерпел. . .

C# и сети: Сокеты, gRPC и SignalR

UnmanagedCoder 04.05.2025

Сетевые технологии не стоят на месте, а вместе с ними эволюционируют и инструменты разработки. В . NET появилось множество решений — от низкоуровневых сокетов, позволяющих управлять каждым байтом. . .

Создание микросервисов с Domain-Driven Design

ArchitectMsa 04.05.2025

Архитектура микросервисов за последние годы превратилась в мощный архитектурный подход, который позволяет разрабатывать гибкие, масштабируемые и устойчивые системы. А если добавить сюда ещё и. . .

Многопоточность в C++: Современные техники C++26

bytestream 04.05.2025

C++ долго жил по принципу «один поток — одна задача» — как старательный солдатик, выполняющий команды одну за другой. В то время, когда процессоры уже обзавелись несколькими ядрами, этот подход стал. . .

SQL Server is the world’s most powerful data platform and it is constantly evolving. From release to release significant new features are added. Besides the features and functionality, one of the typical question DBAs have is which are the Operating System requirements for each version and edition of SQL Server.

In this post you can find this information for all versions and editions gathered from different MSDN Library articles. In the end of each table there is a reference to the source document on MSDN in case you need to find more information (i.e. 32-bit vs. 64 bit, etc.).

Operating System Requirements for SQL Server:

Learn More About What’s New in SQL Server 2022 – Enroll to the Course!

Feel free to check our course on Udemy, titled “SQL Server 2022: What’s New – New and Enhanced Features“.

Via the course, you will learn all about the new features and enhancements in SQL Server 2022, via a rich set of high-quality lectures, infographics and step-by-step live demonstrations.

Learn More on Udemy

Enroll to our Master Class “Essential SQL Server Administration Tips”

If you really want to learn sophisticated SQL Server administration techniques, then you should check our on-demand online course titled “Essential SQL Server Administration Tips” (special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Learn More

Featured Online Courses:

• AI Essentials: A Beginner’s Guide to Artificial Intelligence
• SQL Server 2022: What’s New – New and Enhanced Features
• Working with Python on Windows and SQL Server Databases
• Introduction to Azure Database for MySQL
• Boost SQL Server Database Performance with In-Memory OLTP
• Introduction to Azure SQL Database for Beginners
• Essential SQL Server Administration Tips
• SQL Server Fundamentals – SQL Database for Beginners
• Essential SQL Server Development Tips for SQL Developers
• Introduction to Computer Programming for Beginners
• .NET Programming for Beginners – Windows Forms with C#
  
• SQL Server 2019: What’s New – New and Enhanced Features
• Entity Framework: Getting Started – Complete Beginners Guide
  
• Data Management for Beginners – Main Principles
  
• A Guide on How to Start and Monetize a Successful Blog

Related SQL Server Administration Articles:

• Essential SQL Sever Administration Tips
• How to Patch a Standalone SQL Server Instance
• The SQL Server Browser Service and UDP Port 1434
• The Maximum Number of Concurrent Connections Setting in SQL Server
• Top 10 SQL Server DBA Daily Tasks List
• There is no SQL Server Failover Cluster Available to Join
• Encrypting a SQL Server Database Backup
• …more

Rate this article: (2 votes, average: 5.00 out of 5)

Loading…

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub

Views: 12,266