Unix Technical Forum

SQL database hang

This is a discussion on SQL database hang within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I'm attempting to perform a snapshot backup of SQL database, due to some space constraints the snapshot creation ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 03:49 PM
velu5
 
Posts: n/a
Default SQL database hang

Hi,

I'm attempting to perform a snapshot backup of SQL database, due to
some space constraints the snapshot creation fails.
From the SQL trace log I could find the IO was frozen and after
snapshot failure it was thawed - but the database remains hung.

As from in code I'm trying to free the SQL DMO component - using the
call CoUninitialize() API
which takes abt 15-20 minutes to return.

Thanks in advance,
atvelu
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:03 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com