tag:blogger.com,1999:blog-26876796591272761222024-09-14T15:51:31.369-07:00Anonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2687679659127276122.post-23366381631393575112012-05-16T10:44:00.000-07:002012-05-16T10:44:35.298-07:00<h3 dir="ltr" id="internal-source-marker_0.2105637692304091"> <span style="background-color: transparent; color: #1c4587; font-family: Arial; font-size: 16px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: underline; vertical-align: baseline;">Database is in Recovery</span></h3> <span style="background-color: transparent; color: #0c343d; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;"></span><br /> <span style="background-color: transparent; color: #0c343d; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;">Problem: &nbsp;</span><br /> <span style="background-color: transparent; color: #0c343d; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;"></span><span style="background-color: transparent; color: #0c343d; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">My database is in recovery. Other DBA tried to restart the SQL server Services. There was </span><span style="background-color: transparent; color: #0c343d; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline;">no way</span><span style="background-color: transparent; color: #0c343d; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"> to bring it online. Database mirror was set for the database. </span><br /> <br /> <br /> <span style="background-color: transparent; color: #cc0000; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;"></span><br /> <span style="background-color: transparent; color: #cc0000; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;">Solution:</span><br /> <span style="background-color: transparent; color: #cc0000; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;"></span><br /> <ul style="margin-bottom: 0pt; margin-top: 0pt;"> <li style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">Turn off the partner (If you can’t do it on the principle, Do it on the mirrored)</span></li> </ul> <div dir="ltr" style="margin-bottom: 0pt; margin-top: 0pt; text-indent: 36pt;"> <span style="background-color: transparent; color: blue; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"> &nbsp;&nbsp;&nbsp;alter database</span><span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"> mta_acctfiles &nbsp;</span><span style="background-color: transparent; color: blue; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">set partner off</span></div> <span style="background-color: transparent; color: blue; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;"></span><br /> <ul style="margin-bottom: 0pt; margin-top: 0pt;"> <li style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">Restore the DB with Recovery (Sometime I noticed you don’t even have to do this)</span></li> </ul> <span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;</span><span style="background-color: transparent; color: blue; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">&nbsp;restore database </span><span style="background-color: transparent; color: black; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">mta_acctfiles &nbsp;</span><span style="background-color: transparent; color: blue; font-family: Arial; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">with recovery;&nbsp;&nbsp;&nbsp; </span><br /> <h3 dir="ltr"> <span style="background-color: transparent; color: #85200c; font-family: Arial; font-size: 16px; font-style: normal; font-variant: normal; font-weight: bold; text-decoration: none; vertical-align: baseline;">Warning: </span><span style="background-color: transparent; color: black; font-family: Arial; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline;">Please note that database mirror will break during this process. you have to reset the mirror. &nbsp;&nbsp;&nbsp; </span></h3>Anonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.com0New York, NY, USA40.7143528 -74.005973140.5217853 -74.3218301 40.9069203 -73.690116100000012