Post reply

DB shrink and backup error in sql2008

  • December 4, 2009 at 5:06 am

    #135794

    Hi All,

    kindly help me.

    MS SQL server 2008 SP1,

    And While tried to shrink the same DB error occured as follows

    Msg 0, Level 11, State 0, Line 0

    A severe error occurred on the current command. The results, if any, should be discarded.

    While tried to take the DB Backup error occured as follows

    Msg 3204, Level 16, State 1, Line 1

    The backup or restore was aborted.

    Msg -2, Level 11, State 0, Line 0

    Timeout 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

    Thanks

    Micheal.

  • December 4, 2009 at 6:10 am

    #1087622

    Micheal,

    Do you see any additional message in the error log?

    How do you take backup? Gui/T SQL? Local or network?

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 4, 2009 at 6:26 am

    #1087636

    Firstly, why oh why are you shrinking your database?

    Please run this on the DB in question, if it returns any errors post them.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 7, 2009 at 12:47 am

    #1088391

    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 me

    Thanks & Regards

    Maria Michel A

  • December 7, 2009 at 2:23 am

    #1088407

    Did you execute CheckDB as Gail suggested?

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 7, 2009 at 1:19 pm

    #1088859

    Hi,

    While trying to run the above mentioned query:

    DBCC CHECKDB (PIDNEw) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Im recieving the following error:

    Msg -2, Level 11, State 0, Line 0

    Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Thanx,

    Michael

  • December 7, 2009 at 1:48 pm

    #1088880

    Where are you running it from? Management studio?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 7, 2009 at 1:54 pm

    #1088886

    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 ?

  • December 7, 2009 at 6:15 pm

    #1088964

    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

  • October 2, 2012 at 9:55 am

    #1544468

    See, if it is due to log file full.

  • October 2, 2012 at 11:17 am

    #1544512

    Please note: 3 year old thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply