December 14, 2024
082223_2101_Howtomigrat15.png
Microsoft SQL Server (or Express), either locally on the backup manager server or remotely.

Microsoft SQL Server (or Express), either locally on the backup manager server or remotely.

Microsoft SQL Server Express has a configuration data storage limit of 10 GB. The Express Edition is sufficient for the evaluation and small environments (500 VMs).

1. Log in to the existing Veeam Backup and replication manager server.

2. Open the Veeam Backup & Replication Console.

3. Select and right-click all jobs.

4. Select Disable.

082223 2101 Howtomigrat1 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

5. Drop down the main menu and select Configuration Backup.

082223 2101 Howtomigrat2 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

6. Click Backup now on the Configuration Backup Settings page.

082223 2101 Howtomigrat3 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

7. Copy the configuration file from the backup repository to the new Backup and Replication manager server.

082223 2101 Howtomigrat4 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

8. Log in to the new Veeam Backup and Replication manager server.

9. Open the Veeam Backup & Replication Console, and click Connect.

082223 2101 Howtomigrat5 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

10. Drop down the main menu and select Configuration Backup.

082223 2101 Howtomigrat6 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

11. Click Restore on the Configuration Backup Settings page.

082223 2101 Howtomigrat7 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

12. Click Yes on the User Account Control page.

082223 2101 Howtomigrat8 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

13. Select Migrate on the Restore Mode page.

082223 2101 Howtomigrat9 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

14. Select this server in the Backup repository field on the Configuration Backup page.

15. Click Browse in the Backup file field.

082223 2101 Howtomigrat10 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

16. Select the backup configuration file and click Open.

082223 2101 Howtomigrat11 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

17. Click Analyze on the Configuration Backup page.

082223 2101 Howtomigrat12 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

18. Click Next on the Backup Contents page.

082223 2101 Howtomigrat13 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

19. On the Password page, enter the password of the configuration file in the Password field.

20. Enter the description in the Hint field.

21. Click Validate.

082223 2101 Howtomigrat14 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

22. Select Microsoft SQL Server from the Database drop-down list on the Target Database page.

23. Enter the instance name and Database name in the Connection session.

24. Select Windows authentication using the service account credentials in the Authentication session.

082223 2101 Howtomigrat15 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

25. Click Yes on the warning message.

082223 2101 Howtomigrat16 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

26. Select the Backup and replica catalog checkbox on the Restore Options page.

27. Select the Session history checkbox.

28. Select Enable required PowerShell execution policy for SCVMM checkbox.

29. Select Backup existing database before configuration restore (recommended).

30. Click Restore.

082223 2101 Howtomigrat17 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

31. Click Yes on the warning message.

082223 2101 Howtomigrat18 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

32. On the Restore page, ensure the Configuration restore is completed successfully and click Next.

082223 2101 Howtomigrat19 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

33. On the Credentials page, ensure all credentials are up-to-date and click Next.

082223 2101 Howtomigrat20 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

34. Ensure all credentials are up-to-date on the Cloud Credentials page and click Start.

082223 2101 Howtomigrat21 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

35. Click Finish on the Summary page.

082223 2101 Howtomigrat22 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

36. Open Veeam Backup & Replication console and click Connect.

082223 2101 Howtomigrat23 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

37. Select and right-click all jobs, and unselect Disable to enable all jobs.

082223 2101 Howtomigrat24 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

38. Ensure all jobs are re-enabled.

082223 2101 Howtomigrat25 - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

I hope you enjoy this post.

Cary Sun

Twitter: @SifuSun

Web Site: carysun.com

Blog Site: checkyourlogs.net

Blog Site: gooddealmart.com

ca16fbd3199de5f66b829b87082fb970?s=80&d=retro&r=g - How to migrate the Existing Veeam Backup and Replication to the new server with Microsoft SQL

Author: Cary Sun

Cary Sun has a wealth of knowledge and expertise in data center and deployment solutions. As a Principal Consultant, he likely works closely with clients to help them design, implement, and manage their data center infrastructure and deployment strategies.
With his background in data center solutions, Cary Sun may have experience in server and storage virtualization, network design and optimization, backup and disaster recovery planning, and security and compliance management. He holds CISCO CERTIFIED INTERNETWORK EXPERT (CCIE No.4531) from 1999. Cary is also a Microsoft Most Valuable Professional (MVP), Microsoft Azure MVP, Veeam Vanguard and Cisco Champion. He is a published author with several titles, including blogs on Checkyourlogs.net, and the author of many books.
Cary is a very active blogger at checkyourlogs.net and is permanently available online for questions from the community. His passion for technology is contagious, improving everyone around him at what they do.

Blog site: https://www.checkyourlogs.net
Web site: https://carysun.com
Blog site: https://gooddealmart.com
Twitter: @SifuSun
in: https://www.linkedin.com/in/sifusun/
Amazon Author: https://Amazon.com/author/carysun