In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
functional testing
Testing changes in autoseeding requirements for SQL Server 2017 data file disk layout
Because the production environment holds the data files on different volumes and instance names, the full path to the data files will be different. To enable automatic seeding, reset the default datapath to meet the requirements of the 2017 disk layout.
Suppose the default path for the primary instance is c:\data\, and the default path for the secondary instance is d:\data\
Master Instance File Location
SQL Server 2016 Secondary Instance File Location
SQL Server 2017 Secondary Instance File Location
C:\data\
C:\data\
D:\data\
C:\data\group1\
C:\data\group1\
D:\data\group1\
Then, for SQL Server 2017, the data files are successfully deployed on the secondary instance to different volumes at different instance names, and the file path is not affected.
Test automatic seeding configuration, pause, disable, enable, database reinitialization without deleting secondary copies
We primarily tested scenarios such as creating an availability group with auto-seeding, temporarily preventing the primary replica from seeding more databases to the secondary replica, stopping auto-seeding of a secondary replica on an existing availability group, and enabling auto-seeding of a secondary replica on an existing availability group.
Test Backup Recovery Method Automation Script for Powershell SQLPS and SqlServer Modules
Test automation scripts create availability groups in SQL Server 2017.
For multi-instance servers, note the path order of $PSModulePath. For example, if you install the default instance of SQL Server 2014 first, and then install the named instance of SQL Server 2017, then the SQL PS module loaded by the automation script in Import-Module SQLPS is actually SQL Server 2014, and some cmdlets of AG are not updated, and an error will be reported when executed. Either adjust the order of SQLPS in $PSModulePath, or specify the full path where the module is located when Import-Module.
For SQL Server 2017 SQLPS module for backward compatibility, no longer updated, for the creation of AG some cmdlets execution will report errors. Download the SqlServer module from powershellgallery.com, and the function is normal.
Testing log backup, Checkpoint, insert data, full backup during auto-seeding
Test In the process of automatic seed setting, log backup can be performed, Checkpoint command can be executed manually, and data can be inserted. These operations are not affected. In other words, it will not be affected when the business is initialized. If you do a full backup, the full backup is blocked.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.