Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Bạn cũng xác định như thế nào Copy cơ sở dữ liệu Wizard nên phản ứng khi một cơ sở dữ liệu với tên yêu cầu đã tồn tại về đích. Các tùy chọn là một trong hai dừng việc chuyển giao hoặc thả cơ sở dữ liệu hiện có và tạo ra một cơ sở dữ liệu mới có cùng tên. | Part VI Enterprise Data Management 1042 FIGURE 44-2 Select the destination server FIGURE 44-3 Select your preferred choice of transfer www.getcoolebook.com Transferring Databases 44 FIGURE 44-4 Select the databases you want to copy or move On page 5 Configure Destination Database shown in Figure 44-5 the wizard asks you to configure the destination database. You modify the destination database name and the default locations for the database files on the destination server. You also specify how the Copy Database Wizard should react when a database with the requested name already exists on the destination. The options are either stopping the transfer or dropping the existing database and creating a new database with the same name. The wizard will move all the objects and data. On page 6 Select Server Objects shown in Figure 44-6 you can optionally direct the wizard to move the following All logins or only those that have access to the database All or selected non-system stored procedures in the master database that are used by the database All or selected SQL Agent jobs automated and optionally scheduled tasks All or selected endpoints All or selected SSIS packages All or selected user-defined error messages used by the RAISERROR T-SQL command Click the ellipses button next to each selected option and choose individual objects you want to transfer. If you do not choose individual objects all the objects of each selection option are transferred by default. 1043 www.getcoolebook.com Part VI Enterprise Data Management 1044 FIGURE 44-5 Configure the destination database FIGURE 44-6 The Copy Database Wizard can move server-related information as it moves the database .
