Red Gate forums :: View topic - SQL Backup Hanging
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

SQL Backup Hanging

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sunbaked



Joined: 19 Oct 2006
Posts: 8

PostPosted: Thu Oct 29, 2009 9:02 pm    Post subject: SQL Backup Hanging Reply with quote

Hi,

I am running 6.2.0.134 and every few nights i have a database that hangs during the backup process - by that i mean the file exists as zero size and the progress meter just keeps going. The only way i have been able to kill the backup is to actually restart the sql server.

Thinking the files could be corrupt or something i have been deleting the databases as they have this happen to them. I am now down 6 databases and it seems to just move onto another one in a night or two later.

Any help would be greatly appreciated. This is not an issue we were having with v5 on this server but as we have been upgrading all of our servers to v6, this one has been upgraded and now has our upgrade process halted while we figure out the issue!
Back to top
View user's profile Send private message
mathew



Joined: 05 Nov 2009
Posts: 1

PostPosted: Thu Nov 05, 2009 11:48 am    Post subject: Reply with quote

Hello All
I Am Mathew I have not Answer for that query I also Facing the problem of Data backup..When back up Sql data at that time Often again hanging problem so any one have idea and solution tem me..
Thanks..
Back to top
View user's profile Send private message Send e-mail
mclifford



Joined: 02 Sep 2010
Posts: 4

PostPosted: Thu Oct 21, 2010 3:21 pm    Post subject: Hanging Backup Reply with quote

I had this same problem. My backups and log backups would hang all the time. Once I started to run my backups one right after another and verify after each one, I don't have the problem at all any more. Hope this helps.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group