Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL server 2005 backup failing

Posted on 2013-07-01
4
Medium Priority
?
301 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 1500 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

718 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