Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P6: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | New Features in SQL Server 2008 Chapter 1 7 Figure 1.3 The Copy Only Backup Option The T-SQL procedure to do a Copy Only Backup would look like BACKUP DATABASE robby TO DISK N C Backup robby.bak WITH COPY_ONLY NOFORMAT NOINIT NAME N robby-Full Database Backup SKIP NOREWIND NOUNLOAD STATS 10 GO Test Day Tip Be sure you are very familiar with doing backups and restores both from a T-SQL standpoint and a GUI standpoint. Since this is the bread and w butter of a DBA s job you can be sure there will be plenty of questions about backups restores and recovery. 8 Chapter 1 New Features in SQL Server 2008 Enhanced Configuration and Management of Audits Auditing is available using the new Change Data Capture CDC feature. CDC can be used to capture insertions updates and deletes in an SQL table in a database and place the changes in another table. The following SQL code demonstrates how to configure CDC for auditing of a table in a database --Activate CDC EXEC sys.sp_cdc_enable_db_change_data_capture --Enable CDC on table EXEC sys.sp_cdc_enable_table_change_data_capture @source_schema dbo @source_name myTable @role_name cdc To read the data from the CDC table there are a series of system stored procedures and functions available or you can query the tables directly. System stored procedures sys.sp_cdc_add_job sys.sp_cdc_generate_wrapper_function sys.sp_cdc_change_job sys.sp_cdc_get_captured_columns sys.sp_cdc_cleanup_change_table sys.sp_cdc_get_ddl_history sys.sp_cdc_disable_db sys.sp_cdc_help_change_data_capture sys.sp_cdc_disable_table sys.sp_cdc_help_jobs sys.sp_cdc_drop_job sys.sp_cdc_scan sys.sp_cdc_enable_db sys.sp_cdc_start_job sys.sp_cdc_enable_table sys.sp_cdc_stop_job New Features in SQL Server 2008 Chapter 1 9 System functions cdc.fn_cdc_get_all_changes_ capture_instance sys.fn_cdc_has_column_changed cdc.fn_cdc_get_net_changes_ capture_instance sys.fn_cdc_increment_lsn sys.fn_cdc_decrement_lsn sys.fn_cdc_is_bit_set sys.fn_cdc_get_column_ordinal .
