Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

DB shrink and backup error in sql2008 Expand / Collapse
Author
Message
Posted Friday, December 4, 2009 5:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 6:53 AM
Points: 122, Visits: 93
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
Posted Friday, December 4, 2009 6:10 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:08 AM
Points: 617, Visits: 1,273
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
Posted Friday, December 4, 2009 6:26 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:58 AM
Points: 42,832, Visits: 35,964
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
Posted Monday, December 7, 2009 12:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 6:53 AM
Points: 122, Visits: 93
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
Posted Monday, December 7, 2009 2:23 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:08 AM
Points: 617, Visits: 1,273
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
Posted Monday, December 7, 2009 1:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 6:53 AM
Points: 122, Visits: 93
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
Posted Monday, December 7, 2009 1:48 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:58 AM
Points: 42,832, Visits: 35,964
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
Posted Monday, December 7, 2009 1:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:24 PM
Points: 2,829, Visits: 8,477
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
Posted Monday, December 7, 2009 6:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 6:53 AM
Points: 122, Visits: 93
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
Posted Tuesday, October 2, 2012 9:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 8, 2013 12:45 PM
Points: 1, Visits: 37
See, if it is due to log file full.
Post #1367139
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse