{"id":663,"date":"2011-10-14T11:32:30","date_gmt":"2011-10-14T03:32:30","guid":{"rendered":"http:\/\/nick.workao.org\/?p=663"},"modified":"2011-10-14T12:19:34","modified_gmt":"2011-10-14T04:19:34","slug":"sql-server%e8%87%aa%e5%8a%a8%e5%a4%87%e4%bb%bd%e4%bb%bb%e5%8a%a1%e7%9a%84sql","status":"publish","type":"post","link":"http:\/\/nick.txtcc.com\/index.php\/db\/663","title":{"rendered":"sql server\u81ea\u52a8\u5907\u4efd\u4efb\u52a1\u7684sql"},"content":{"rendered":"<p>\u9002\u5408\u6bcf\u5929\u81ea\u52a8\u5907\u4efd\uff0c\u81ea\u52a8\u547d\u540d\uff1a\u6570\u636e\u5e93\u540d_\u65e5\u671f.bak<\/p>\n<p>&nbsp;<\/p>\n<pre lang=\"python\" line=\"1\">DECLARE @dbpath nvarchar(50)\n--settings begin\nUSE AgentPlatform\nset @dbpath='f:\\bak\\'\n--settings end\n\nSET ANSI_NULLS ON\nSET QUOTED_IDENTIFIER ON\nDECLARE @dbname nvarchar(50)\nSET @dbname=(Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid))\nDECLARE @dbdate nvarchar(50)\nselect @dbdate=replace( cast(getdate() as char(10)),' ','')\nDECLARE @FullPath nvarchar(1000)\nset @FullPath = @dbpath + @dbname + '_' + @dbdate + '.bak'\nSELECT @FullPath\nbackup database @dbname to disk=@FullPath\nwith INIT<\/pre>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>\u9002\u5408\u6bcf\u5929\u81ea\u52a8\u5907\u4efd\uff0c\u81ea\u52a8\u547d\u540d\uff1a\u6570\u636e\u5e93\u540d_\u65e5\u671f.bak &nbsp; DECLARE @dbpath nvarchar(50) &#8211;settings begin USE AgentPlatform set&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[],"class_list":["post-663","post","type-post","status-publish","format-standard","hentry","category-db"],"_links":{"self":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=663"}],"version-history":[{"count":7,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/663\/revisions"}],"predecessor-version":[{"id":670,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/663\/revisions\/670"}],"wp:attachment":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=663"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}