{"id":2297,"date":"2012-10-05T07:46:10","date_gmt":"2012-10-05T07:46:10","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2297"},"modified":"2013-11-13T07:11:42","modified_gmt":"2013-11-13T07:11:42","slug":"%e7%a7%bb%e5%8a%a8%e6%95%b0%e6%8d%ae%e5%ba%93%e6%96%87%e4%bb%b6%e4%bd%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/10\/05\/%e7%a7%bb%e5%8a%a8%e6%95%b0%e6%8d%ae%e5%ba%93%e6%96%87%e4%bb%b6%e4%bd%8d%e7%bd%ae\/","title":{"rendered":"\u8fc1\u79fb\u6570\u636e\u5e93\u6587\u4ef6\u4f4d\u7f6e"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--1\uff0c\u4fee\u6539\u6587\u4ef6\u903b\u8f91\u4f4d\u7f6e\r\n\t\r\n\t--1)\u67e5\u8be2\u6587\u4ef6\u903b\u8f91\u540d\uff0c\r\n\tSELECT name logical_name, physical_name AS CurrentLocation, state_desc\r\n\tFROM sys.master_files\r\n\tWHERE database_id = DB_ID(&#39;test&#39;)\r\n\t\r\n\t--2\uff09\u4fee\u6539\r\n\tALTER DATABASE test MODIFY FILE ( NAME = Test, FILENAME = &#39;M:\\Program Files\\SQL Server2008R2\\Test.mdf&#39; )\r\n\tALTER DATABASE test MODIFY FILE ( NAME = Test_log, FILENAME = &#39;M:\\Program Files\\SQL Server2008R2\\Test_log.ldf&#39; )\r\n<\/pre>\n<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\" style=\"width: 875.125px;\">\r\n\r\n--2\uff0c\u8131\u673a\u6216\u505c\u6570\u636e\u5e93\r\nALTER DATABASE test SET OFFLINE\r\n<\/pre>\n<div>\n\t&nbsp;<\/div>\n<p>&#8211;3\uff0c\u7269\u7406\u79fb\u52a8\u6570\u636e\u5e93\u6587\u4ef6\u5230\u65b0\u4f4d\u7f6e\u3002 &#8211;4\uff0c\u8054\u673a\u6216\u542f\u52a8\u6570\u636e\u5e93 ALTER DATABASE test SET ONLINE &#8211;5\uff0c\u67e5\u770b\u6548\u679c SELECT name logical_name, physical_name AS CurrentLocation, state_desc FROM sys.master_files WHERE database_id = DB_ID(&#39;test&#39;) &#8211;\u53c2\u8003\uff1ahttp:\/\/msdn.microsoft.com\/zh-cn\/library\/ms345483(v=sql.90).aspx <\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;1\uff0c\u4fee\u6539\u6587\u4ef6\u903b\u8f91\u4f4d\u7f6e &#8211;1)\u67e5\u8be2\u6587\u4ef6\u903b\u8f91\u540d\uff0c SELECT name logical_name, phy [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2297","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2297"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2297\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}