2013年2月1日
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 阅读全文
posted @ 2013-02-01 22:55 逝者如斯(乎) 阅读(353) 评论(0) 推荐(0)
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 阅读全文
posted @ 2013-02-01 18:02 逝者如斯(乎) 阅读(161) 评论(0) 推荐(0)
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 阅读全文
posted @ 2013-02-01 16:24 逝者如斯(乎) 阅读(308) 评论(0) 推荐(0)