SystemCenterServiceManager2010SP1災(zāi)難恢復(fù)指南

1、PAGE PAGE System Center Service Manager 2010 SP1 災(zāi)難恢復(fù)指南Microsoft Corporation發(fā)布日期：2010 年 12 月 1 日作者John Downing適用于System Center Service Manager2010 SP1反饋請(qǐng)將有關(guān)此文檔的建議和意見發(fā)送到 HYPERLINK mailto:scsmdocs?subject=Service%20Manager%202010%20SP1%20Disaster%20Recovery%20Guide scsmdocs本文檔按“原樣”提供。本文檔中描述的信息和視圖（包括 U

2、RL 和其他 Internet 網(wǎng)站引用）如有變更，恕不另行通知。使用本文檔的風(fēng)險(xiǎn)需要您自己承擔(dān)。文中描述的某些示例僅供說明并且屬于虛構(gòu)，并無意聯(lián)系或暗示任何真實(shí)對(duì)象。本文檔未提供對(duì)任何 Microsoft 產(chǎn)品中的任何知識(shí)產(chǎn)權(quán)的任何合法權(quán)利。您可以復(fù)制本文檔供內(nèi)部參考之用，也可以修改本文檔供內(nèi)部參考之用。 2010 Microsoft Corporation。保留所有權(quán)利。Microsoft、ActiveX、SharePoint、SQL Server、Windows、Windows Server 和 Windows Vista 是 Microsoft 公司集團(tuán)的商標(biāo)。所有其他商標(biāo)均為其各自所

3、有者的財(cái)產(chǎn)。修訂歷史記錄發(fā)布日期更改2010 年 4 月 16 日本指南的原始發(fā)行版2010 年 4 月 29 日更正更正了產(chǎn)品名稱2010 年 10 月 25 日添加了有關(guān)如何啟動(dòng) SQL Server 腳本向?qū)б圆东@ SQL Server 登錄和對(duì)象級(jí)別權(quán)限的部分。內(nèi)容 TOC o 1-5 h HYPERLINK l _Toc278901205 System Center Service Manager 2010 SP1 災(zāi)難恢復(fù)指南 PAGEREF _Toc278901205 h 5 HYPERLINK l _Toc278901206 本節(jié)內(nèi)容 PAGEREF _Toc278901206

4、 h 5 HYPERLINK l _Toc278901207 Disaster Recovery Scenarios Overview PAGEREF _Toc278901207 h 5 HYPERLINK l _Toc278901208 Service Manager Management Server PAGEREF _Toc278901208 h 5 HYPERLINK l _Toc278901209 Data Warehouse Management Server PAGEREF _Toc278901209 h 6 HYPERLINK l _Toc278901210 Service M

5、anager Databases PAGEREF _Toc278901210 h 6 HYPERLINK l _Toc278901211 Self-Service Portal PAGEREF _Toc278901211 h 7 HYPERLINK l _Toc278901212 Prepare for Service Manager SP1 Disaster Recovery PAGEREF _Toc278901212 h 7 HYPERLINK l _Toc278901213 本節(jié)內(nèi)容 PAGEREF _Toc278901213 h 7 HYPERLINK l _Toc278901214

6、Deployment Strategy for Service Manager 2010 SP1 PAGEREF _Toc278901214 h 8 HYPERLINK l _Toc278901215 Backing Up Service Manager 2010 SP1 Management Servers PAGEREF _Toc278901215 h 8 HYPERLINK l _Toc278901216 In This Section PAGEREF _Toc278901216 h 9 HYPERLINK l _Toc278901217 在 Service Manager 2010 中

7、備份和還原加密密鑰 PAGEREF _Toc278901217 h 9 HYPERLINK l _Toc278901218 Backing Up Service Manager 2010 SP1 Databases PAGEREF _Toc278901218 h 10 HYPERLINK l _Toc278901219 In This Section PAGEREF _Toc278901219 h 11 HYPERLINK l _Toc278901220 如何啟動(dòng) SQL Server 腳本向?qū)?PAGEREF _Toc278901220 h 11 HYPERLINK l _Toc278901

8、221 How to Start the SQL Server 2008 R2 Script Wizard PAGEREF _Toc278901221 h 13 HYPERLINK l _Toc278901222 Backing Up Unsealed Management Packs in Service Manager 2010 SP1 PAGEREF _Toc278901222 h 14 HYPERLINK l _Toc278901223 本節(jié)內(nèi)容 PAGEREF _Toc278901223 h 14 HYPERLINK l _Toc278901224 How to Back Up Un

9、sealed Management Packs PAGEREF _Toc278901224 h 14 HYPERLINK l _Toc278901225 Implement Service Manager SP1 Disaster Recovery PAGEREF _Toc278901225 h 15 HYPERLINK l _Toc278901226 本節(jié)內(nèi)容 PAGEREF _Toc278901226 h 15 HYPERLINK l _Toc278901227 Service Manager 2010 中的數(shù)據(jù)庫恢復(fù) PAGEREF _Toc278901227 h 16 HYPERLIN

10、K l _Toc278901228 本部分中的內(nèi)容 PAGEREF _Toc278901228 h 16 HYPERLINK l _Toc278901229 Service Manager 2010 中的災(zāi)難恢復(fù) PAGEREF _Toc278901229 h 16 HYPERLINK l _Toc278901230 管理服務(wù)器災(zāi)難恢復(fù) PAGEREF _Toc278901230 h 17 HYPERLINK l _Toc278901231 部署策略 PAGEREF _Toc278901231 h 17 HYPERLINK l _Toc278901232 升級(jí)附加的 Service Manag

11、er 管理服務(wù)器 PAGEREF _Toc278901232 h 17 HYPERLINK l _Toc278901233 本部分中的內(nèi)容 PAGEREF _Toc278901233 h 17 HYPERLINK l _Toc278901234 如何還原 Service Manager 加密密鑰 PAGEREF _Toc278901234 h 18 HYPERLINK l _Toc278901235 如何恢復(fù) Service Manager 管理服務(wù)器 PAGEREF _Toc278901235 h 19 HYPERLINK l _Toc278901236 如何恢復(fù)數(shù)據(jù)倉庫管理服務(wù)器 PAGE

12、REF _Toc278901236 h 19 HYPERLINK l _Toc278901237 如何提升 Service Manager 管理服務(wù)器 PAGEREF _Toc278901237 h 21 HYPERLINK l _Toc278901238 Import Unsealed Management Packs in Service Manager 2010 SP1 PAGEREF _Toc278901238 h 22 HYPERLINK l _Toc278901239 In This Section PAGEREF _Toc278901239 h 22 HYPERLINK l _T

13、oc278901240 How to Import Management Packs PAGEREF _Toc278901240 h 22PAGE 23System Center Service Manager 2010 SP1 災(zāi)難恢復(fù)指南災(zāi)難恢復(fù)指南描述如何備份和還原加密密鑰，如何還原發(fā)生故障的 Service Manager 和數(shù)據(jù)倉庫管理服務(wù)器，以及如何還原數(shù)據(jù)庫。本節(jié)內(nèi)容 HYPERLINK l z979127da843a4999a5aa430c88376fd9 在 Service Manager 2010 中備份和還原加密密鑰描述如何備份和還原加密密鑰。 HYPERLINK l z

14、91debb99e6844d55916d5f5ea36abf37 Service Manager 2010 中的災(zāi)難恢復(fù)描述如何恢復(fù)承載 Service Manager 和數(shù)據(jù)倉庫管理服務(wù)器的計(jì)算機(jī)。 HYPERLINK l z5d2325f57dde4a7b9e80f186b55a82dc Service Manager 2010 中的數(shù)據(jù)庫恢復(fù)描述如何恢復(fù)承載 Service Manager 數(shù)據(jù)庫的計(jì)算機(jī)。Disaster Recovery Scenarios OverviewThis topic provides an overview of the disaster recovery

15、 processes for each of the major parts of a smlongsp1 installation. Service Manager Management ServerYou can take two approaches to restore a failed Service Manager management server. You can replace the management server, or you can promote an additional management server to the primary role if an

16、additional management server exists. The option to replace it or promote it depends largely on your timeframe. If you can quickly bring up another computer, then you might choose that option; otherwise, you can promote an additional management server to the primary role and then add another manageme

17、nt server later. Promoting an additional management server involves the following procedures:1.Promote an additional Service Manager management server. For more information, see HYPERLINK l za9dc5ef76e8c4fe1a14e61b492815580 如何提升 Service Manager 管理服務(wù)器 in this guide.2.When a replacement server is avai

18、lable, install an additional Service Manager management server. For more information, see How to Install an Additional Management Server in the HYPERLINK /fwlink/?LinkId=198071 System Center Service Manager 2010 SP1 Deployment Guide (/fwlink/?LinkId=198071).If promoting an additional Service Manager

19、 management server is not an option, you have to install a replacement management server. Installing a replacement Service Manager management server involves the following procedures:1.Start with a new computer that has the same computer name as the computer that failed.2.Restore the encryption key

20、that you saved from the original Service Manager management server. For more information, see HYPERLINK l zf83b5b3d30df4f26aaa3fe39c4beb8ac 如何還原 Service Manager 加密密鑰 in this guide.3.Install a Service Manager management server. For more information, see Service Manager 2010 SP1 Deployment Scenarios i

21、n the HYPERLINK /fwlink/?LinkId=198071 System Center Service Manager 2010 SP1 Deployment Guide (/fwlink/?LinkId=198071).Data Warehouse Management ServerThere is only one recovery scenario possible for the data warehouse management server; you must install a new data warehouse management server on a

22、computer with the same computer name as the computer that failed. Installing a replacement data warehouse management server involves the following procedures:1.Start with a new computer that has the same computer name as the computer that failed.2.Restore the encryption key that you saved from the o

23、riginal data warehouse management server. For more information, see HYPERLINK l zf83b5b3d30df4f26aaa3fe39c4beb8ac 如何還原 Service Manager 加密密鑰 in this guide.3.Install a data warehouse management server. For more information, see Service Manager 2010 SP1 Deployment Scenarios in the HYPERLINK /fwlink/?Li

24、nkId=198071 System Center Service Manager 2010 SP1 Deployment Guide (/fwlink/?LinkId=198071).Service Manager DatabasesRecovery procedures are the same for both the Service Manager database and the data warehouse database. You use a computer with the same name, and then you restore the Microsoft SQL

25、Server databases by using the same instance as the original. Recovery of a Service Manager database and a data warehouse database involves the following procedures:1.Start with a new computer that has the same computer name and with the same SQL Server instance as the computer that failed.2.Restore

26、the SQL Server database or databases. For more information, see HYPERLINK l z5d2325f57dde4a7b9e80f186b55a82dc Service Manager 2010 中的數(shù)據(jù)庫恢復(fù) in this guide.Self-Service PortalDisaster recovery for a failed 自助服務(wù)門戶 is simple. The computer name is not critical on the replacement server. Install 自助服務(wù)門戶 on

27、the replacement computer, and then create a new encryption key. For more information, see Self-Service Portal Deployment Scenarios in the HYPERLINK /fwlink/?LinkId=198071 System Center Service Manager 2010 SP1 Deployment Guide (/fwlink/?LinkId=198071).Prepare for Service Manager SP1 Disaster Recover

28、yThis section describes the steps you must take before problems occur. The steps you take to recover from a disaster are predicated on having completed the steps outlined here. In general, preparing your Service Manager environment for disaster recovery involves the following:1.Deploying smshortsp1

29、with management servers and databases on separate computers.2.Backing up the encryption keys on the management servers and 自助服務(wù)門戶.3.Backing up the SQL databases.4.Backing up your unsealed management packs.本節(jié)內(nèi)容 HYPERLINK l z609696e84e8e4ec584bcbdb1573e272d Deployment Strategy for Service Manager 2010

30、 SP1Describes the deployment strategy you must use to prepare for disaster recovery. HYPERLINK l z0f16fd6468804ae28e50fa8c560eedd2 Backing Up Service Manager 2010 SP1 Management ServersDescribes the steps you can take to back up Service Manager management servers. HYPERLINK l zbe17adf8e0694dbf95239f

31、d25defe9eb Backing Up Service Manager 2010 SP1 DatabasesDescribes the steps you can take to back up Service Manager databases. HYPERLINK l z6c01238e5651437592a378efed73105c Backing Up Unsealed Management Packs in Service Manager 2010 SP1Describes the steps you can take to back up unsealed management

32、 packs.Deployment Strategy for Service Manager 2010 SP1As a best practice, deploy your management servers and associated databases on separate computers. Isolating the management servers and databases provides for a successful recovery operation. You must have a functioning database to restore a fai

33、led management server. Recovery of a management server is impossible if the management server and the associated database are on the same physical computer and that computer fails. For more information, see the topic Installing Service Manager on Four Computers in the HYPERLINK /fwlink/?LinkId=19807

34、1 System Center Service Manager 2010 SP1 Deployment Guide (/fwlink/?LinkId=198071).Backing Up Service Manager 2010 SP1 Management ServersWhen smshortsp1 is deployed, an encryption key is created and stored in the registry on the management servers and 自助服務(wù)門戶. The matching encryption key is created o

35、n the associated databases. In addition, the computer name of the management server and 自助服務(wù)門戶 is stored on the associated databases. The encryption keys for the Service Manager management server and 自助服務(wù)門戶 are stored in the Service Manager database. The matching encryption key for the data warehous

36、e management server is stored in the DWStagingAndConfig database. By backing up the SQL Server databases, you have backed up the encryption key.Regardless of whether you encounter a software or hardware failure of a management server or 自助服務(wù)門戶, your recovery process centers around restoring a comput

37、er that has the same computer name. The following overview outlines the steps to follow to recover from a management server failure.1.Restore the encryption keys before you run Setup and install the new management servers.2.Install the new management server on a computer that has the same name as th

38、e original.3.When you install the management server, you have to select Use an existing database and then specify the name of the computer hosting the associated database.In This Section HYPERLINK l z979127da843a4999a5aa430c88376fd9 在 Service Manager 2010 中備份和還原加密密鑰Describes how to back up the Servi

39、ce Manager encryption key.在 Service Manager 2010 中備份和還原加密密鑰部署了 Service Manager 之后，會(huì)創(chuàng)建加密密鑰，以便能夠加密 Service Manager 管理服務(wù)器、數(shù)據(jù)倉庫管理服務(wù)器、自助服務(wù)門戶及其關(guān)聯(lián)的數(shù)據(jù)庫之間的數(shù)據(jù)。在完成 Service Manager 安裝之后，災(zāi)難恢復(fù)策略立即由備份加密密鑰的用戶決定。備份加密密鑰并將其存儲(chǔ)在安全位置之后，可以在 Service Manager 和數(shù)據(jù)倉庫管理服務(wù)器上從軟件或硬件故障中恢復(fù)。使用加密密鑰備份或還原向?qū)浞莺瓦€原管理服務(wù)器和自助服務(wù)門戶上的加密密鑰。此向?qū)挥?

40、Service Manager 安裝媒體上的 ToolsSecureStorageBackup 文件夾中。注意 在此版本中，此向?qū)О瑢?duì) Operations Manager 的引用。此問題將在將來的版本中解決。備份加密密鑰1.使用本身是管理員組成員的帳戶登錄到承載 Service Manager 管理服務(wù)器或數(shù)據(jù)倉庫管理服務(wù)器的計(jì)算機(jī)。2.在 Windows 資源管理器中，打開安裝媒體上的 ToolsSecureStorageBackup 文件夾。3.雙擊“SecureStorageBackup.exe”文件以啟動(dòng)加密密鑰備份或還原向?qū)А?.在“簡介”頁上，單擊“下一步”。5.在“備份或還原

41、?”頁上，選擇“備份加密密鑰”，然后單擊“下一步”。6.在“提供位置”頁上，鍵入加密密鑰的路徑和文件名。例如，如果想要為 MyServer 服務(wù)器上的 Backup 文件夾共享中的加密密鑰指定文件名 SMBackupkey.bin，請(qǐng)鍵入 MyServerBackupSMBackupkey.bin，然后單擊“下一步”。7.在“提供密碼”頁上的“密碼”框中，鍵入至少包含八個(gè)字符的密碼。在“確認(rèn)密碼”框中，重新鍵入相同密碼，然后單擊“下一步”。注意 如果丟失或忘記了密碼，則無法找回密碼。8.在收到“安全存儲(chǔ)備份完成”消息之后，單擊“完成”。還原加密密鑰1.使用本身是管理員組成員的帳戶登錄到承載 S

42、ervice Manager 管理服務(wù)器或數(shù)據(jù)倉庫管理服務(wù)器的計(jì)算機(jī)。2.在 Windows 資源管理器中，打開安裝媒體上的 ToolsSecureStorageBackup 文件夾。3.雙擊“SecureStorageBackup.exe”文件以啟動(dòng)加密密鑰備份或還原向?qū)А?.在“簡介”頁上，單擊“下一步”。5.在“備份或還原?”頁上，選擇“還原加密密鑰”，然后單擊“下一步”。6.在“提供位置”頁上，鍵入加密密鑰的路徑和文件名。例如，如果想要為保存在 MyServer 服務(wù)器上的 Backup 文件夾共享中的加密密鑰指定文件名 SMBackupkey.bin，請(qǐng)鍵入 MyServerBack

43、upSMBackupkey.bin，然后單擊“下一步”。7.在“提供密碼”頁上的“密碼”框中，鍵入用于備份加密密鑰的密碼。在“確認(rèn)密碼”框中，重新鍵入相同密碼，然后單擊“下一步”。8.在收到“安全存儲(chǔ)密鑰還原完成”消息之后，單擊“完成”。Backing Up Service Manager 2010 SP1 DatabasesThere are up to five databases in a smlongsp1 environment:ServiceManagerDWDataMartDWRepositoryDWStagingAndConfigReportServerThe first fo

44、ur databases in this list need to connect and exchange data with the Service Manager and data warehouse management servers. Data is encrypted during these exchanges. On the management servers, the encryption keys are backed up and restored as necessary as explained in this guide. For more informatio

45、n about the encryption keys on the management servers, see HYPERLINK l z0f16fd6468804ae28e50fa8c560eedd2 Backing Up Service Manager 2010 SP1 Management Servers. For the servers hosting a database, the encryption keys are stored in the databases themselves.If a computer hosting a database fails, all

46、that is needed is the ability to restore the databases (which include the encryption keys) to a computer with the same name as the original computer. Your disaster recovery strategy for the Service Manager databases should be based on general SQL Server 2008 disaster recovery procedures. For more in

47、formation, see HYPERLINK /fwlink/?LinkId=131016 SQL Server 2008 Books Online: Planning for Disaster Recovery (/fwlink/?LinkId=131016).As part of your disaster recovery preparation, you will need to run a script to capture the Security log to preserve user role information for each database. After yo

48、u deploy Service Manager and if necessary, run the Data Warehouse Registration Wizard. You will use the SQL Server Script Wizard to create a script that captures SQL Server logon and object level permissions. Then, if you need to restore a new server for the Service Manager databases, you can use th

49、is script to recreate the necessary logon and object level permissions needed. The wizard used to generate scripts in SQL Server 2008 differs from the wizard in SQL Server 2008 R2. Instructions for both SQL Server 2008 and SQL Server 2008 R2 are presented in this guide.In This Section HYPERLINK l zf

50、2b74c4b42224d23a342be2d60dcdc31 如何啟動(dòng) SQL Server 腳本向?qū)escribes how generate a script to capture SQL Server 2008 logon and object level permissions. HYPERLINK l z29d7a6fde0bd43c8b7f0f052d0242286 How to Start the SQL Server 2008 R2 Script WizardDescribes how generate a script to capture SQL Server 2008

51、 R2 logon and object level permissions.如何啟動(dòng) SQL Server 腳本向?qū)г跒?zāi)難恢復(fù)準(zhǔn)備步驟中使用以下過程生成腳本，以捕獲 SQL Server 登錄名和對(duì)象級(jí)別權(quán)限。您需要在承載 Service Manager 和數(shù)據(jù)倉庫數(shù)據(jù)庫的計(jì)算機(jī)上以及承載 SQL Server Reporting Services (SSRS) 的計(jì)算機(jī)上執(zhí)行此過程：DWDataMartDWRepositoryDWStagingAndConfigServiceManagerReportServer啟動(dòng) SQL Server 腳本向?qū)?.使用具有管理員權(quán)限的帳戶登錄到承載 S

52、ervice Manager 數(shù)據(jù)庫的計(jì)算機(jī)。2.在 Windows 桌面上，單擊“開始”，指向“程序”，再指向“Microsoft SQL Server 2008”，然后單擊“SQL Server Management Studio”。3.在“連接到服務(wù)器”對(duì)話框中，執(zhí)行以下步驟：a.在“服務(wù)器類型”列表中，選擇“數(shù)據(jù)庫引擎”。b.在“服務(wù)器名稱”列表中，選擇 Server Manager 數(shù)據(jù)庫的服務(wù)器和實(shí)例。例如，選擇“computerINSTANCE1”。c.在“身份驗(yàn)證”列表中，選擇“Windows 身份驗(yàn)證”，再單擊“連接”。4.在“對(duì)象瀏覽器”窗格中，展開“數(shù)據(jù)庫”。5.右鍵單擊

53、數(shù)據(jù)庫名稱，指向“任務(wù)”，然后單擊“生成腳本”。對(duì)于本示例，右鍵單擊“ServiceManager”，指向“任務(wù)”，然后單擊“生成腳本”。6.在“腳本向?qū)А睂?duì)話框中，執(zhí)行以下步驟：a.在“歡迎使用生成 SQL Server 腳本向?qū)А表撋?，單擊“下一步”。b.在“選擇數(shù)據(jù)庫”頁上，選擇要為其生成腳本的數(shù)據(jù)庫。在本示例中，選擇“ServiceManager”，然后單擊“下一步”。c.在“選擇腳本選項(xiàng)”頁上，將所有 True/False 項(xiàng)都設(shè)置為“False”。在“常規(guī)”區(qū)域中，將“編寫登錄腳本”和“編寫對(duì)象級(jí)別權(quán)限腳本”設(shè)置為“True”，然后單擊“下一步”。d.在“選擇對(duì)象類型”頁上，單擊“

54、全選”，然后單擊“下一步”。e.在“選擇程序集”頁上，單擊“全選”，然后單擊“下一步”。f.在“選擇數(shù)據(jù)庫角色”頁上，單擊“全選”，然后單擊“下一步”。g.在“選擇架構(gòu)”頁上，單擊“全選”，然后單擊“下一步”。h.在“選擇存儲(chǔ)過程”頁上，單擊“全選”，然后單擊“下一步”。i.在“選擇表”頁上，單擊“全選”，然后單擊“下一步”。j.在“選擇用戶定義表類型”頁上，單擊“全選”，然后單擊“下一步”。k.在“選擇用戶定義函數(shù)”頁上，單擊“全選”，然后單擊“下一步”。l.在“選擇用戶”頁上，單擊“全選”，然后單擊“下一步”。m.在“選擇視圖”頁上，單擊“全選”，然后單擊“下一步”。n.在“選擇 XML

55、架構(gòu)集合”頁上，單擊“全選”，然后單擊“下一步”。o.在“選擇全文目錄”頁上，單擊“全選”，然后單擊“下一步”。p.在“輸出選項(xiàng)”頁上，選擇“將腳本保存到文件”，在“文件名”文本框中，輸入腳本的位置和文件名（例如，鍵入 C:BackupServiceManagerDatabaseScript.sql），然后單擊“下一步”。q.在“腳本向?qū)д表撋?，單擊“完成”。r.在“生成腳本進(jìn)度”頁上，確保顯示“成功”，然后單擊“關(guān)閉”。7.保存剛才在單獨(dú)的物理計(jì)算機(jī)上創(chuàng)建的腳本文件，通常將其與 Service Manager 加密密鑰保存在同一位置。8.對(duì)這三個(gè)數(shù)據(jù)倉庫數(shù)據(jù)庫中的每一個(gè)以及 SSRS 運(yùn)

56、行此相同的過程。9.如果需要還原數(shù)據(jù)庫，請(qǐng)使用這些腳本將權(quán)限還原到新服務(wù)器。How to Start the SQL Server 2008 R2 Script WizardUse the following procedure as part of your disaster recovery preparation steps to generate a script to capture SQL Server logon and object level permissions. You need to perform this procedure on the computers ho

57、sting your Service Manager and data warehouse databases and on the computer hosting SQL Server Reporting Services (SSRS):DWDataMartDWRepositoryDWStagingAndConfigServiceManagerReportServerTo start the SQL Server Script wizard1.Using an account with Administrator privileges, log on to the computer hos

58、ting the Service Manager or data warehouse database.2.On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.3.In the Connect to Server dialog box, follow these steps:a.In the Server Type list, select Database Engine

59、.b.In the Server Name list, select the server and the instance for your Server Manager database. For example, select computerINSTANCE1.c.In the Authentication list, select Windows Authentication, and then click Connect.4.In the Object Explorer pane, expand Databases.5.Right-click the database name,

60、point to Tasks, and then click Generate Scripts. For this example, right-click ServiceManager, point to Tasks, and then click Generate Scripts.6.In the Generate and Publish Scripts wizard, perform the following steps:a.On the Introduction page, click Next.b.On the Choose Objects page, select Select