{"id":4980,"date":"2017-08-01T11:16:11","date_gmt":"2017-08-01T14:16:11","guid":{"rendered":"http:\/\/www.alfagestion.com.ar\/ag\/?p=4980"},"modified":"2017-08-01T11:16:11","modified_gmt":"2017-08-01T14:16:11","slug":"una-base-de-datos-se-ha-quedado-en-estad-in-recovery","status":"publish","type":"post","link":"https:\/\/www.alfagestion.com.ar\/ag\/una-base-de-datos-se-ha-quedado-en-estad-in-recovery\/","title":{"rendered":"Una base de datos se ha quedado en estad In Recovery."},"content":{"rendered":"<p>Cuando una base de datos se pone en estado In Recovery debemos saber que el Servidor SQL ya est\u00e1 realizando un proceso de recuperaci\u00f3n de esa base de datos . Intentar arreglar el problema por nuestra cuenta puede dejar esa base de datos inservible. Por lo tanto a continuaci\u00f3n se propone una consulta que mostrar\u00e1 el tiempo que falta para que el Servidor SQL termine de recuperar la base de datos afectada.<\/p>\n<p><strong>En servidores SQL 2005 o superior:<\/strong><\/p>\n<p><span style=\"color: #0000ff;\">DECLARE @DBName VARCHAR(64) <\/span><br \/>\n<span style=\"color: #0000ff;\">SET @DBName = &#8216;<strong><span style=\"color: #ff0000;\">databasename<\/span><\/strong>&#8216;<\/span><\/p>\n<p><span style=\"color: #0000ff;\">DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))<\/span><\/p>\n<p><span style=\"color: #0000ff;\">INSERT INTO @ErrorLog <\/span><br \/>\n<span style=\"color: #0000ff;\">EXEC sys.xp_readerrorlog 0, 1, &#8216;Recovery of database&#8217;, @DBName<\/span><\/p>\n<p><span style=\"color: #0000ff;\">SELECT TOP 10 [LogDate],<\/span><br \/>\n<span style=\"color: #0000ff;\"> SUBSTRING([TEXT], CHARINDEX(&#8216;) is &#8216;, [TEXT]) + 4, CHARINDEX(&#8216; complete (&#8216;, [TEXT]) &#8211; CHARINDEX(&#8216;) is &#8216;, [TEXT]) &#8211; 4) AS PercentComplete ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> CAST(SUBSTRING([TEXT], CHARINDEX(&#8216;approximately&#8217;, [TEXT]) + 13,CHARINDEX(&#8216; seconds remain&#8217;, [TEXT]) &#8211; CHARINDEX(&#8216;approximately&#8217;, [TEXT]) &#8211; 13) AS FLOAT)\/60.0 AS MinutesRemaining ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> CAST(SUBSTRING([TEXT], CHARINDEX(&#8216;approximately&#8217;, [TEXT]) + 13,CHARINDEX(&#8216; seconds remain&#8217;, [TEXT]) &#8211; CHARINDEX(&#8216;approximately&#8217;, [TEXT]) &#8211; 13) AS FLOAT)\/60.0\/60.0 AS HoursRemaining ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> [TEXT] <\/span><br \/>\n<span style=\"color: #0000ff;\"> FROM @ErrorLog <\/span><br \/>\n<span style=\"color: #0000ff;\"> ORDER BY [LogDate] DESC<\/span><br \/>\n<strong>En servidores SQL 2012 o superior:<\/strong><\/p>\n<p><span style=\"color: #0000ff;\">DECLARE @DBName VARCHAR(64) = &#8216;<span style=\"color: #ff0000;\"><strong>databasename<\/strong><\/span>&#8216; <\/span><br \/>\n<span style=\"color: #0000ff;\">DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX))<\/span><\/p>\n<p><span style=\"color: #0000ff;\">INSERT INTO @ErrorLog <\/span><br \/>\n<span style=\"color: #0000ff;\">EXEC master..sp_readerrorlog 0, 1, &#8216;Recovery of database&#8217;, @DBName<\/span><\/p>\n<p><span style=\"color: #0000ff;\">SELECT TOP 5 [LogDate] ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> SUBSTRING([TEXT], CHARINDEX(&#8216;) is &#8216;, [TEXT]) + 4,CHARINDEX(&#8216; complete (&#8216;, [TEXT]) &#8211; CHARINDEX(&#8216;) is &#8216;, [TEXT]) &#8211; 4) AS PercentComplete ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> CAST(SUBSTRING([TEXT], CHARINDEX(&#8216;approximately&#8217;, [TEXT]) + 13,CHARINDEX(&#8216; seconds remain&#8217;, [TEXT]) &#8211; CHARINDEX(&#8216;approximately&#8217;, [TEXT]) &#8211; 13) AS FLOAT)\/60.0 AS MinutesRemaining ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> CAST(SUBSTRING([TEXT], CHARINDEX(&#8216;approximately&#8217;, [TEXT]) + 13,CHARINDEX(&#8216; seconds remain&#8217;, [TEXT]) &#8211; CHARINDEX(&#8216;approximately&#8217;, [TEXT]) &#8211; 13) AS FLOAT)\/60.0\/60.0 AS HoursRemaining ,<\/span><br \/>\n<span style=\"color: #0000ff;\"> [TEXT] <\/span><br \/>\n<span style=\"color: #0000ff;\"> FROM @ErrorLog <\/span><br \/>\n<span style=\"color: #0000ff;\"> ORDER BY [LogDate] DESC<\/span><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/una-base-de-datos-se-ha-quedado-en-estad-in-recovery\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/una-base-de-datos-se-ha-quedado-en-estad-in-recovery\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Cuando una base de datos se pone en estado In Recovery debemos saber que el Servidor SQL ya est\u00e1 realizando un proceso de recuperaci\u00f3n de esa base de datos . Intentar arreglar el problema por nuestra cuenta puede dejar esa &hellip; <a class=\"kt-excerpt-readmore\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/una-base-de-datos-se-ha-quedado-en-estad-in-recovery\/\" aria-label=\"Una base de datos se ha quedado en estad In Recovery.\">Leer m&aacute;s<\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/una-base-de-datos-se-ha-quedado-en-estad-in-recovery\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/una-base-de-datos-se-ha-quedado-en-estad-in-recovery\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[149],"tags":[],"class_list":["post-4980","post","type-post","status-publish","format-standard","hentry","category-base-de-datos"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9eJDz-1ik","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":4660,"url":"https:\/\/www.alfagestion.com.ar\/ag\/instaladores-de-sql-express-2008\/","url_meta":{"origin":4980,"position":0},"title":"Instaladores de SQL Express 2008","date":"10 enero 2017","format":false,"excerpt":"Recientemente para un proyecto me ha tocado que descargar SQL Express pero me encontr\u00e9 con varios instaladores sin una explicaci\u00f3n de que contiene o que instala cada uno de ellos, por lo que al investigar encontr\u00e9 para que es cada uno de los instaladores y aqu\u00ed se los muestro. Microsoft\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4973,"url":"https:\/\/www.alfagestion.com.ar\/ag\/recuperar-base-de-datos-sql-server-sin-ldf\/","url_meta":{"origin":4980,"position":1},"title":"Recuperar base de datos SQL Server sin ldf","date":"1 agosto 2017","format":false,"excerpt":"Necesitamos restaurar un\u00a0archivo .mdf\u00a0en una instancia diferente desde la que viene, debido a que esa instancia tiene alg\u00fan problema y no la podemos iniciar. Al cerrarse mal la instancia por un error en el disco o en el servidor , al adjuntar el archivo .mdf nos dice que el .ldf\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2540,"url":"https:\/\/www.alfagestion.com.ar\/ag\/sql-server-2000-base-en-estado-suspect\/","url_meta":{"origin":4980,"position":2},"title":"SQL Server 2000 \u2013 Base en estado Suspect","date":"25 septiembre 2014","format":false,"excerpt":"Base de Datos Sospechosa (Suspect), recuperaci\u00f3n con sp_resetstatus y DBCC DBRECOVER, y el Modo de Emergencia Volver a: [SQL Server FAQ :: Preguntas y Respuestas Frecuentes de SQL Server :: Manual SQL Server] \u00a0Un problema t\u00edpico en Administraci\u00f3n de Bases de Datos SQL Server, es encontrar una Base de Datos\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4975,"url":"https:\/\/www.alfagestion.com.ar\/ag\/4975-2\/","url_meta":{"origin":4980,"position":3},"title":"Registro de Errores en Alfa Gestion","date":"1 agosto 2017","format":false,"excerpt":"El Alfa Gesti\u00f3n registra todos los errores producidos en la base de datos al intentar grabar, para poder\u00a0analizar y recuperar\u00a0la sentencia que produjo el error. Para esto, puede abrir desde el manager la tabla aux_err, normalmente ordenar por id desc para ver los ultimos errores primeros, detectar cual es, y\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1269,"url":"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/","url_meta":{"origin":4980,"position":4},"title":"Error Tieme Out o Tiempo de espera finalizado","date":"25 agosto 2011","format":false,"excerpt":"Abrir la tabla AUX_ERR. Identificar el c\u00f3digo del error. Para ordenar por fecha (Order by fecha = 'xx\/xx\/xxxx') En una nueva consulta ejecutar el siguiente Script. DECLARE @SQL nvarchar(4000) set @sql = 'bcp \"select sql from abuela.dbo.aux_err where id = 821\" queryout \"c:\\xx.txt\" -c -T -C ANSI' exec master..xp_cmdshell @sql\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1710,"url":"https:\/\/www.alfagestion.com.ar\/ag\/no-puedo-acceder-a-un-servidor-sql-remoto\/","url_meta":{"origin":4980,"position":5},"title":"No puedo acceder a un servidor SQL remoto.","date":"5 diciembre 2013","format":false,"excerpt":"Si no puede acceder a un servidor SQL remoto debe tener en cuenta las siguientes opciones. Agregar al Firewall de Windows las excepciones a SQL y SQLBrowser. O deshabilitar el Firewall. Los puertos habituales son TCP 1433 SQL y UDP 1434 para el SQL Browser. En configuraci\u00f3n de superficie de\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/4980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/comments?post=4980"}],"version-history":[{"count":1,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/4980\/revisions"}],"predecessor-version":[{"id":4981,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/4980\/revisions\/4981"}],"wp:attachment":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/media?parent=4980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/categories?post=4980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/tags?post=4980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}