SQL Backup Hanging

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

SQL Backup Hanging

Postby sunbaked » Thu Oct 29, 2009 9:02 pm

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!
sunbaked
 
Posts: 8
Joined: Thu Oct 19, 2006 2:51 pm

Postby mathew » Thu Nov 05, 2009 11:48 am

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..
mathew
 
Posts: 1
Joined: Thu Nov 05, 2009 11:38 am

Hanging Backup

Postby mclifford » Thu Oct 21, 2010 3:21 pm

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.
mclifford
 
Posts: 4
Joined: Thu Sep 02, 2010 8:24 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests