DB shrink and backup error in sql2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » DB shrink and backup error in sql2008

11 posts, Page 1 of 2

1 2 »»

DB shrink and backup error in sql2008

Rate Topic

Display Mode

Topic Options

Author

Message

antomicheal

Posted Friday, December 04, 2009 5:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 02, 2012 5:09 AM
Points: 122, Visits: 85

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.

Post #828762

joeroshan

Posted Friday, December 04, 2009 6:10 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:12 AM
Points: 573, Visits: 1,165

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
Custom cleanup script for backups

Post #828807

GilaMonster

Posted Friday, December 04, 2009 6:26 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:08 PM
Points: 37,720, Visits: 29,973

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 2008, MVP
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

Post #828823

antomicheal

Posted Monday, December 07, 2009 12:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 02, 2012 5:09 AM
Points: 122, Visits: 85

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

Post #829678

joeroshan

Posted Monday, December 07, 2009 2:23 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:12 AM
Points: 573, Visits: 1,165

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
Custom cleanup script for backups

Post #829703

antomicheal

Posted Monday, December 07, 2009 1:19 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 02, 2012 5:09 AM
Points: 122, Visits: 85

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

Post #830231

GilaMonster

Posted Monday, December 07, 2009 1:48 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:08 PM
Points: 37,720, Visits: 29,973

Where are you running it from? Management studio?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #830253

homebrew01

Posted Monday, December 07, 2009 1:54 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,554, Visits: 7,209

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 ?

Post #830259

antomicheal

Posted Monday, December 07, 2009 6:15 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 02, 2012 5:09 AM
Points: 122, Visits: 85

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

Post #830354

manish.singh01

Posted Tuesday, October 02, 2012 9:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 12:45 PM
Points: 1, Visits: 37

See, if it is due to log file full.

Post #1367139

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions