{"id":669,"date":"2008-02-06T01:53:01","date_gmt":"2008-02-05T17:53:01","guid":{"rendered":"http:\/\/blog.myhz.com\/blog\/2010\/05\/06\/sql-server-2000-%e8%bd%ac-sql-server-2005\/"},"modified":"2010-05-07T15:12:00","modified_gmt":"2010-05-07T07:12:00","slug":"sql-server-2000-%e8%bd%ac-sql-server-2005","status":"publish","type":"post","link":"https:\/\/ivan.xin\/?p=669","title":{"rendered":"sql server 2000 \u8f6c sql server 2005"},"content":{"rendered":"<p>Ivan \u53d1\u8868\u4e8e 2008-2-7 1:53:00<\/p>\n<p>RESTORE DATABASE PAIDC<br \/>\nFROM DISK = 'D:\\hosting\\\u7ad9\u8c03\u8bd5\\_db_backups\\backup.bak'<br \/>\nWITH MOVE 'PAIDC' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\PAIDC.mdf',<br \/>\nMOVE 'PAIDC_log' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\PAIDC_log.ldf',<br \/>\nreplace<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ivan \u53d1\u8868\u4e8e 2008-2-7 1:53:00 RESTORE DATABASE PAIDC FROM D...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-669","post","type-post","status-publish","format-standard","hentry","category-9"],"_links":{"self":[{"href":"https:\/\/ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=669"}],"version-history":[{"count":0,"href":"https:\/\/ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/669\/revisions"}],"wp:attachment":[{"href":"https:\/\/ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}