{"id":163,"date":"2013-08-21T08:00:00","date_gmt":"2013-08-21T00:00:00","guid":{"rendered":"http:\/\/31.0.2.219:81\/?p=163"},"modified":"2014-03-11T15:06:27","modified_gmt":"2014-03-11T07:06:27","slug":"sql2005-%e6%95%b0%e6%8d%ae%e5%ba%93%e5%a4%87%e4%bb%bd%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"http:\/\/www.huike007.cn\/?p=163","title":{"rendered":"SQL2005 \u6570\u636e\u5e93\u5907\u4efd\u547d\u4ee4"},"content":{"rendered":"

–\u5b8c\u6574\u5907\u4efd
\nBackup Database NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Full_20070908.bak'
\n–\u5dee\u5f02\u5907\u4efd
\nBackup Database NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Diff_20070908.bak'
\nWith Differential
\n–\u65e5\u5fd7\u5907\u4efd\uff0c\u9ed8\u8ba4\u622a\u65ad\u65e5\u5fd7
\nBackup Log NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Log_20070908.bak'
\n–\u65e5\u5fd7\u5907\u4efd\uff0c\u4e0d\u622a\u65ad\u65e5\u5fd7
\nBackup Log NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Log_20070908.bak'
\nWith No_Truncate
\n–\u622a\u65ad\u65e5\u5fd7\u4e0d\u4fdd\u7559
\nBackup Log NorthwindCS
\nWith No_Log
\n–\u6216\u8005
\nBackup Log NorthwindCS
\nWith Truncate_Only
\n–\u622a\u65ad\u4e4b\u540e\u65e5\u5fd7\u6587\u4ef6\u4e0d\u4f1a\u53d8\u5c0f
\n–\u6709\u5fc5\u8981\u53ef\u4ee5\u8fdb\u884c\u6536\u7f29
\n–\u6587\u4ef6\u5907\u4efd
\nExec Sp_Helpdb NorthwindCS –\u67e5\u770b\u6570\u636e\u6587\u4ef6
\nBackup Database NorthwindCS
\nFile='NorthwindCS' –\u6570\u636e\u6587\u4ef6\u7684\u903b\u8f91\u540d
\nTo disk='G:\\Backup\\NorthwindCS_File_20070908.bak'
\n–\u6587\u4ef6\u7ec4\u5907\u4efd
\nExec Sp_Helpdb NorthwindCS –\u67e5\u770b\u6570\u636e\u6587\u4ef6
\nBackup Database NorthwindCS
\nFileGroup='Primary' –\u6570\u636e\u6587\u4ef6\u7684\u903b\u8f91\u540d
\nTo disk='G:\\Backup\\NorthwindCS_FileGroup_20070908.bak'
\nWith init
\n–\u5206\u5272\u5907\u4efd\u5230\u591a\u4e2a\u76ee\u6807
\n–\u6062\u590d\u7684\u65f6\u5019\u4e0d\u5141\u8bb8\u4e22\u5931\u4efb\u4f55\u4e00\u4e2a\u76ee\u6807
\nBackup Database NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Full_1.bak'
\n ,disk='G:\\Backup\\NorthwindCS_Full_2.bak'
\n–\u955c\u50cf\u5907\u4efd
\n–\u6bcf\u4e2a\u76ee\u6807\u90fd\u662f\u76f8\u540c\u7684
\nBackup Database NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Mirror_1.bak'
\nMirror
\nTo disk='G:\\Backup\\NorthwindCS_Mirror_2.bak'
\nWith Format –\u7b2c\u4e00\u6b21\u505a\u955c\u50cf\u5907\u4efd\u7684\u65f6\u5019\u683c\u5f0f\u5316\u76ee\u6807
\n–\u955c\u50cf\u5907\u4efd\u5230\u672c\u5730\u548c\u8fdc\u7a0b
\nBackup Database NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Mirror_1.bak'
\nMirror
\nTo disk='\\\\192.168.1.200\\Backup\\NorthwindCS_Mirror_2.bak'
\nWith Format
\n–\u6bcf\u5929\u751f\u6210\u4e00\u4e2a\u5907\u4efd\u6587\u4ef6
\nDeclare @Path Nvarchar(2000)
\nSet @Path ='G:\\Backup\\NorthwindCS_Full_'
\n+Convert(Nvarchar,Getdate(),112)+'.bak'
\nBackup Database NorthwindCS
\nTo disk=@Path
\n–\u4eceNoRecovery\u6216\u8005
\n–Standby\u6a21\u5f0f\u6062\u590d\u6570\u636e\u5e93\u4e3a\u53ef\u7528
\nRestore Database NorthwindCS_Bak
\nWith Recovery
\n–\u67e5\u770b\u76ee\u6807\u5907\u4efd\u4e2d\u7684\u5907\u4efd\u96c6
\nRestore HeaderOnly
\nFrom Disk ='G:\\Backup\\NorthwindCS_Full_20070908.bak'
\n–\u67e5\u770b\u76ee\u6807\u5907\u4efd\u7684\u7b2c\u4e00\u4e2a\u5907\u4efd\u96c6\u7684\u4fe1\u606f
\nRestore FileListOnly
\nFrom Disk ='G:\\Backup\\NorthwindCS_Full_20070908_2.bak'
\nWith File=1
\n–\u67e5\u770b\u76ee\u6807\u5907\u4efd\u7684\u5377\u6807
\nRestore LabelOnly
\nFrom Disk ='G:\\Backup\\NorthwindCS_Full_20070908_2.bak'
\n–\u5907\u4efd\u8bbe\u7f6e\u5bc6\u7801\u4fdd\u62a4\u5907\u4efd
\nBackup Database NorthwindCS
\nTo disk='G:\\Backup\\NorthwindCS_Full_20070908.bak'
\nWith Password = '123',init
\nRestore Database NorthwindCS
\nFrom disk='G:\\Backup\\NorthwindCS_Full_20070908.bak'
\nWith Password = '123'<\/p>\n","protected":false},"excerpt":{"rendered":"

–\u5b8c\u6574\u5907\u4efd Backup Database NorthwindCS To disk='G: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[178],"tags":[265],"_links":{"self":[{"href":"http:\/\/www.huike007.cn\/index.php?rest_route=\/wp\/v2\/posts\/163"}],"collection":[{"href":"http:\/\/www.huike007.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.huike007.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.huike007.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.huike007.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=163"}],"version-history":[{"count":1,"href":"http:\/\/www.huike007.cn\/index.php?rest_route=\/wp\/v2\/posts\/163\/revisions"}],"predecessor-version":[{"id":266,"href":"http:\/\/www.huike007.cn\/index.php?rest_route=\/wp\/v2\/posts\/163\/revisions\/266"}],"wp:attachment":[{"href":"http:\/\/www.huike007.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.huike007.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.huike007.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}