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

Transactional log is full.. space recovery lead to BLocking Expand / Collapse
Author
Message
Posted Thursday, January 31, 2013 1:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
stop the sql service cleanly, start it up the engine in single user mode, then try shrinking.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1413897
Posted Thursday, January 31, 2013 2:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 1,346, Visits: 2,658
Bhuvnesh (1/30/2013)


but i was not sure why everything got blocked by internal processes.

Should i have been waited for sometime ? (for commmand which i executed to change the db to single user mode) ?
can a alter database statement take around 15 minutes to execute ? (though i stopped it after 15 minutes)


Did you see the command run by internal process (DBCC INPUTBUFFER) ? Or in case DBCC INPUTBUFFER was not providing any result atleast the Command column's value in sp_who2 result ?



Sujeet Singh
Post #1413908
Posted Friday, February 1, 2013 4:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:16 AM
Points: 2,840, Visits: 3,983
i still have one confusion,

Why i was getting "blocking by internal processes" for all above mentioned commands , is it normal (though i havent experienced in past) behaviuor ?

i know the best apporach on that moments was to wait for command to get completed.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1414558
Posted Friday, February 1, 2013 4:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:16 AM
Points: 2,840, Visits: 3,983
Divine Flame (1/31/2013)
Did you see the command run by internal process (DBCC INPUTBUFFER) ? Or in case DBCC INPUTBUFFER was not providing any result atleast the Command column's value in sp_who2 result ?
no i missed that . actually blocking by internal processes puzzled me there (i kknow patience was the key there )


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1414560
Posted Friday, February 1, 2013 4:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
Depends what the commands where going.

You should really debug what they are going using the sql text dmv.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1414561
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse