Lesson Administering and Troubleshooting SQL Server 2000: Part 2C

In the knowledge byte section, tell the students about how to use the copy database wizard to copy or move databases and related objects to a different database server or another SQL Server instance. When using the copy database wizard you must have database administrator permissions on both the source and destination servers. Also, ensure that the second instance of SQL Server is installed, with the name SERVERSECOND.
Nội dung trích xuất từ tài liệu:
Lesson Administering and Troubleshooting SQL Server 2000: Part 2C LESSON 2CCOLLABORATE2C. 1 Administering and Troubleshooting SQL Server 2000 INSTRUCTOR NOTESIn the knowledge byte section, tell the students about how to use the Copy DatabaseWizard to copy or move databases and related objects to a different database serveror another SQL Server instance. When using the Copy Database Wizard you musthave database administrator permissions on both the source and destination servers.Also, ensure that the second instance of SQL Server is installed, with the nameSERVERSECOND.Ensure that the following datafiles are installed on the student nodes: „Sales.mdb Administering and Troubleshooting SQL Server 2000 2C.2 KNOWLEDGE BYTE Collaborate Knowledge Byte In this section, you will learn about: • Copy Database Wizard • System Database Recovery • Severity Levels of Errors ©NIIT Collaborate Lesson 1C / Slide 1 of 23In this section, you will be introduced to: „Copy Database wizard. „system databases for recovery operations. „various error levels.2C. 3 Administering and Troubleshooting SQL Server 2000Using the Copy Database Wizard Collaborate Using the Copy Database Wizard • You use the Copy Database wizard to copy or move databases and related objects, such as tables and views from one server to another. For example, if a company wants to move to a new location, the database administrator can use the Copy Database Wizard to copy the current database to a new location. • You can also use the Copy Database Wizard if you want to: • move a database to another database server before you upgrade or perform maintenance tasks. • create a backup of your database on another computer. • modify the database properties without affecting the live database. ©NIIT Collaborate Lesson 1C / Slide 2 of 23You use the Copy Database Wizard to copy or move databases and related objects,such as tables and views from one server to another. For example, if a companywants to move to a new location, the database administrator can use the CopyDatabase Wizard to copy the current database to a new location. You can also use theCopy Database Wizard to: „move a database to another database server before you upgrade or perform maintenance tasks. „create a backup of your database on another computer. „modify the database properties without affecting the live database.The database administrator at Bluemun Inc. decides to move the database, HEADDB,from the default instance of the SQL Server, SERVER, to another instance, SERVER-_SECOND. To move the database to another instance of SQL Server, the databaseadministrator performs the following steps: 1. Select StartÆAll ProgramsÆMicrosoft SQL ServerÆEnterprise Manager to open the Enterprise Manager. 2. Select the Wizards option from the Tools menu, to invoke the Select Wizard dialog box, as shown. Administering and Troubleshooting SQL Server 2000 2C.4 3. Expand the Management option and select the Copy Database Wizard option in the Select Wizard dialog box to start the Copy Database Wizard, as shown.2C. 5 Administering and Troubleshooting SQL Server 20004. Click the OK button on the Select Wizard dialog box to continue. The Welcome to the Copy Database Wizard window appears, as shown. Administering and Troubleshooting SQL Server 2000 2C.6 5. Click the Next button to open the Select a Source Server page. Next, select the default instance of the Source server and verify that the Use Windows Authentication option is selected to specify windows authentication for authorizing a user, as shown. 6. Click the Next button to open the Select a Destination Server page. Specify the name of the destination server where the database is to be moved. For example, in the Destination server list box, specify the name of the destination server as SERVERSECOND, where SERVERSECOND is the name of the second instance that has already been created. 7. Select the Use Windows Authentication option to allow the user to connect to the database server using a Windows user account, as shown.2C. 7 Administering and Troubleshooting SQL Server 2000Administering and Troubleshooting SQL Server ...