How to easy implement projet of patching différent version of SQL server 2008,2012,2016,2019 within projet of upgrade and migration ?
Answers
Answered by
0
Explanation:
PLEASE MARK AS BRAINLIST ANSWER.
Answered by
1
Answer:
Scenario: Suppose you have a large database, say 500 GB, in Simple recovery mode. You do a full backup weekly on Sunday night and the other 6 nights you do differential backups. This database is on SQL Server 2012 (Source). You have another SQL Server that has SQL Server 2017 instance (Destination) and you want to upgrade and migrate this large database. These two SQL Servers are in different data centers. Your network bandwidth between the 2 data centers is 10 GB. The only available window to do the migration is on Saturday morning and the expectation is to complete the migration with testing afterwards within 2 hours. The SLA does not allow any more time.
Similar questions