{"id":1749,"date":"2017-02-10T11:03:16","date_gmt":"2017-02-10T10:03:16","guid":{"rendered":"http:\/\/les-fougs.com\/wordpress\/?p=1749"},"modified":"2017-02-10T11:05:55","modified_gmt":"2017-02-10T10:05:55","slug":"sqlserver-stat_desc-online-offline","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2017\/02\/10\/sqlserver-stat_desc-online-offline\/","title":{"rendered":"SQLSERVER stat_desc online offline"},"content":{"rendered":"<p>SQLSERVER_database_state_desc.bat<\/p>\n<pre>echo DbName : %1\r\necho schema : %2\r\n\r\nsqlcmd -v DbName=\"%1\" schema=\"%2\" -i \\\\pfile.ft.grp\\Batch_win\\SQLSERVER_database_state_desc.sql -b\r\n<\/pre>\n<p>SQLSERVER_database_state_desc.sql<\/p>\n<pre>SELECT state_desc FROM sys.databases where name = '$(schema)';\r\n GO<\/pre>\n<p>SQLSERVER_database_online.bat<\/p>\n<pre>echo DbName : %1\r\necho schema : %2\r\n\r\nsqlcmd -v DbName=\"%1\" schema=\"%2\" -i \\\\pfile.ft.grp\\Batch_win\\SQLSERVER_database_online.sql -b<\/pre>\n<p>SQLSERVER_database_online.sql<\/p>\n<pre>USE $(DbName);\r\nGO\r\n-- Shrink the truncated log file to 1 MB.\r\nALTER DATABASE $(schema) SET ONLINE ;\r\nGO<\/pre>\n<p>SQLSERVER_database_offline.bat<\/p>\n<pre>echo DbName : %1\r\necho schema : %2\r\n\r\nsqlcmd -v DbName=\"%1\" schema=\"%2\" -i \\\\pfile.ft.grp\\Batch_win\\SQLSERVER_database_offline.sql -b<\/pre>\n<p>SQLSERVER_database_offline.sql<\/p>\n<pre>USE $(DbName);\r\nGO\r\n-- Shrink the truncated log file to 1 MB.\r\nALTER DATABASE $(schema) SET OFFLINE ;\r\nGO<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQLSERVER_database_state_desc.bat echo DbName : %1 echo schema : %2 sqlcmd -v DbName=&nbsp;&raquo;%1&Prime; schema=&nbsp;&raquo;%2&Prime; -i \\\\pfile.ft.grp\\Batch_win\\SQLSERVER_database_state_desc.sql -b SQLSERVER_database_state_desc.sql SELECT state_desc FROM sys.databases where name = &lsquo;$(schema)&rsquo;; GO SQLSERVER_database_online.bat echo DbName : %1 echo schema : %2 sqlcmd -v DbName=&nbsp;&raquo;%1&Prime; schema=&nbsp;&raquo;%2&Prime; -i \\\\pfile.ft.grp\\Batch_win\\SQLSERVER_database_online.sql -b SQLSERVER_database_online.sql USE $(DbName); GO &#8212; Shrink the truncated log file to 1 MB. &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2017\/02\/10\/sqlserver-stat_desc-online-offline\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;SQLSERVER stat_desc online offline&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[58],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1749"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1749"}],"version-history":[{"count":1,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1749\/revisions"}],"predecessor-version":[{"id":1750,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1749\/revisions\/1750"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1749"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}