SQL server 2005 backup failing
Posted on 2013-07-01
I have a SQL Serer 2005 DB that is about 120GB in size.
I have the recovery mode set to simple because we don't need minute by minute recovery.
In the interest of full disclosure I do not do backups on a regular basis which I know is frowned upon. We have a disaster recovery plan that takes a server image nightly and snapshots of the server throughout the day so in the event of a server crash I can restore from those images.
When I do try to do a backup through the management studio the process seems to run fine. It gets to 100% complete then hangs. No completion notice pops up. The backup file size is 0. What is really troubling is the drive that the data resides on shows nothing. I have a 300GB hard drive that typically has 160GB of free space. When the backup locks that drive shows nothing. Then the entire server will eventually lock. Also if I check the server performance in task manager the memory is maxed out at 12GB.
HAs anyone ever seen this before? What can I do?
THanks for the help.