﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Administering / SQL Server 2005  / DB shrink and backup error in sql2008 / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sat, 25 May 2013 19:55:40 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Please note: 3 year old thread.</description><pubDate>Tue, 02 Oct 2012 11:17:55 GMT</pubDate><dc:creator>GilaMonster</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>See, if it is due to log file full.</description><pubDate>Tue, 02 Oct 2012 09:55:31 GMT</pubDate><dc:creator>manish.singh01</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Hi I have coped and attached with another Name. But now while tacking the DB backup i got the same error for both DB PIDNew and  Web with same time gab 2 minns. i plane to check out the server level settings plz help me.Thanks Michel A</description><pubDate>Mon, 07 Dec 2009 18:15:50 GMT</pubDate><dc:creator>antomicheal</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>If backups are failing, so there's no recent backup, would it make sense to detach the database, make a copy of the .MDF and .LDF, then reattach ?  Maybe that would be better than nothing until the problems are resolved ?</description><pubDate>Mon, 07 Dec 2009 13:54:33 GMT</pubDate><dc:creator>homebrew01</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Where are you running it from? Management studio?</description><pubDate>Mon, 07 Dec 2009 13:48:07 GMT</pubDate><dc:creator>GilaMonster</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Hi,While trying to run the above mentioned query:DBCC CHECKDB (PIDNEw) WITH NO_INFOMSGS, ALL_ERRORMSGSIm recieving the following error:Msg -2, Level 11, State 0, Line 0Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.Thanx,Michael</description><pubDate>Mon, 07 Dec 2009 13:19:20 GMT</pubDate><dc:creator>antomicheal</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Did you execute CheckDB as Gail suggested?</description><pubDate>Mon, 07 Dec 2009 02:23:48 GMT</pubDate><dc:creator>joeroshan</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Hi Roshan,I have tried on both way, But its occured same error.and also i can't take backup that same DB.Please help meThanks &amp; RegardsMaria Michel A</description><pubDate>Mon, 07 Dec 2009 00:47:27 GMT</pubDate><dc:creator>antomicheal</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Firstly, why oh why are you shrinking your database?Please run this on the DB in question, if it returns any errors post them.[code]DBCC CHECKDB (&amp;lt;Database Name&amp;gt;) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code]</description><pubDate>Fri, 04 Dec 2009 06:26:08 GMT</pubDate><dc:creator>GilaMonster</dc:creator></item><item><title>RE: DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Micheal,Do you see any additional message in the error log?How do you take backup? Gui/T SQL? Local or network?</description><pubDate>Fri, 04 Dec 2009 06:10:06 GMT</pubDate><dc:creator>joeroshan</dc:creator></item><item><title>DB shrink and backup error in sql2008</title><link>http://www.sqlservercentral.com/Forums/Topic828762-146-1.aspx</link><description>Hi All,kindly help me.MS SQL server 2008 SP1,And While tried to shrink the same DB error occured as followsMsg 0, Level 11, State 0, Line 0A severe error occurred on the current command.  The results, if any, should be discarded.While tried to take the DB Backup error occured as followsMsg 3204, Level 16, State 1, Line 1The backup or restore was aborted.Msg -2, Level 11, State 0, Line 0Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.Please kindly help me to resolve this issue.Db size is 25 GB ThanksMicheal.</description><pubDate>Fri, 04 Dec 2009 05:06:24 GMT</pubDate><dc:creator>antomicheal</dc:creator></item></channel></rss>