{"id":1345,"date":"2012-07-22T21:55:50","date_gmt":"2012-07-22T19:55:50","guid":{"rendered":"http:\/\/my.stargazer.at\/?p=1345"},"modified":"2012-07-22T21:55:50","modified_gmt":"2012-07-22T19:55:50","slug":"mssql-emergency-mode","status":"publish","type":"post","link":"https:\/\/my.stargazer.at\/de\/2012\/07\/22\/mssql-emergency-mode\/","title":{"rendered":"MSSQL Emergency Mode"},"content":{"rendered":"<p>Es gibt ein paar Dinge, die in der Knowledgebase von Microsoft fehlen &#8211; unter Anderem, wie das mit dem Emergency Mode des MSSQL Server 2000 ist. So kann man eine Datenbank die als Suspect markiert ist in den Emergency Modus versetzen:<\/p>\n<blockquote>\n<pre>use[master]\r\ngo\r\n\r\nexecute sp_configure 'allow updates',1\r\nreconfigure with override\r\ngo\r\n\r\nupdate sysdatabases set status =32768 where name ='<database name>'\r\ngo\r\n<\/pre>\n<\/blockquote>\n<p><!--more-->Die Datenbank muss dann neu gestartet werden, dass die \u00c4nderung greift. R\u00fcckg\u00e4ngig gemacht wird das so:<\/p>\n<blockquote>\n<pre>\r\n\r\nuse[master] \r\ngo\r\n\r\nupdate sysdatabases set status = 0 where name ='<database name>'\r\ngo\r\n\r\nexecute sp_configure 'allow updates',0\r\nreconfigure with override\r\n<\/pre>\n<\/blockquote>\n<p>Ein Neustart ist auch hier n\u00f6tig.<\/p>","protected":false},"excerpt":{"rendered":"<p>Es gibt ein paar Dinge, die in der Knowledgebase von Microsoft fehlen &#8211; unter Anderem, wie das mit dem Emergency Mode des MSSQL Server 2000 ist. So kann man eine Datenbank die als Suspect markiert ist in den Emergency Modus versetzen: use[master] go execute sp_configure &#8218;allow updates&#8216;,1 reconfigure with override go update sysdatabases set status =32768 where name [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[575,267,579,41],"class_list":["post-1345","post","type-post","status-publish","format-standard","hentry","category-it-related-stuff","tag-database","tag-microsoft","tag-mssql","tag-windows"],"_links":{"self":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/posts\/1345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/comments?post=1345"}],"version-history":[{"count":0,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/posts\/1345\/revisions"}],"wp:attachment":[{"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/media?parent=1345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/categories?post=1345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/my.stargazer.at\/de\/wp-json\/wp\/v2\/tags?post=1345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}