随笔 - 494
文章 - 0
评论 - 4
阅读 -
21万
02 2013 档案
SQL Server 2008 读书笔记(9)：备份和恢复数据库
摘要：Lesson 1: Backing up DatabasesFull BackupsBACKUP DATABASE { database_name | @database_name_var }TO [ ,...n ][ ] [ next-mirror-to ][ WITH { DIFFERENTIAL | [ ,...n ] } ]::= { { logical_device_name | @logical_device_name_var }| { DISK | TAPE } ={ 'physical_device_name' | @physical_device_name_v
阅读全文
SQL Server 2008 读书笔记(8)：设计基于策略的管理
摘要：Lesson 1: Designing PoliciesQuick Check1. What are the fi ve objects that are used within Policy Based Management?2. What are the allowed execution modes for a policy?3. Which object has a property that allows you to mandate checking for all databases on an instance?4. How many facets can be checked
阅读全文
SQL Server 2008 读书笔记(7)：导入和导出数据
摘要：Lesson 1: Importing and Exporting Databcp {[[database_name.][owner].]{table_name | view_name} | "query"}{in | out | queryout | format} data_file[-mmax_errors] [-fformat_file] [-x] [-eerr_file][-Ffirst_row] [-Llast_row] [-bbatch_size][-n] [-c] [-w] [-N] [-V (60 | 65 | 70 | 80)] [-6][-q] [-C
阅读全文
