Solved

SQL server 2005 backup failing

Posted on 2013-07-01
4
297 Views
Last Modified: 2013-11-06
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.
0
Comment
Question by:clifford_m71
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 39289817
With regard to server memory maxing out, have you set a max limit for SQL to use? This would probably be the reason why all the memory on the server is being taken.

Try doing the backup from a query window and see if that produces the same result. The syntax is...

BACKUP DATABASE [DB NAME] TO DISK='C:\Backup.bak' WITH STATS=1

Open in new window

0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 39293388
Do you require further assistance?
0
 

Author Comment

by:clifford_m71
ID: 39555947
EvilPostIt, Thank you for the suggestion. I apologize for taking soooo long to get back to this. I ran the backup from a query. The good news is the backup was created. The drive space did NOT fill up. The bad news is it still froze the server. Any additional suggestions?
0
 

Author Closing Comment

by:clifford_m71
ID: 39627409
Running the backup from a query window for some reason at least created a valid backup. The server still froze but I will look into possible hardware/software problems to resolve that. Thanks for the help.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question