Evaluation and execution strategies for multiple instances in SQL Server 2008

Questions raised

After understanding the management policies in SQL Server 2008, we want to execute these policies on multiple instances in SQL Server 2008 and SQL Server 2005. Please give a detailed answer on how to achieve, thank you.

Expert answers

In SQL Server 2008, when an instance is created, it can be evaluated. But the database administrator needs to do a very tedious job: every instance that is managed in SQL Server needs to be executed individually. The most work the database administrator should do is to constantly change the execution strategy in the test environment before the product is formally run. However, many people do not want to import and export one after the other, but think it is best to apply to all servers at once. It would be nice if you could configure the server with a test server and then apply the policy to many other servers. Luckily, we can export the policy file as an XML file, the XML file can be used to store the policy, and the multiple instances can be evaluated quickly.

Export Policy File

Reference policy Management with examples, you can quickly export the policy as an XML file. Right-click on a policy-select the export policy. The following example selects a policy named AutoShrink off. Save the policy file to the local disk as shown in this example. In this case, the file name is AutoShrink off.xml.

An XML copy of a policy file can be used to conduct a policy assessment of a managed SQL Server instance, as shown in the preceding illustration. We first create a server group, and then register the managed instance.