Solved

Backup file missing

Posted on 2011-03-07
2
197 Views
Last Modified: 2012-05-11
I have a SQL Server that with 4 drives. On drive E I store the mdf file and on drive F (SAN) I store the backup .bak file. The storage size for both drives is about 630 gig.
In the last running of the database it grew to over 600 gig. Then I wanted to see what the backup file grew to and it is gone, acutally it went to 2kb.

Any ideas?

Could it be that last Thursday I have a job in SQL Server Agent that runs the weekly backup. When that ran since it overwrites the previous backup that it removed the current bak and there may not have been enough drive space to rebuild and hence I have what I have?
0
Comment
Question by:SeTech
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 35060520
That sounds like what may have happenend however you should set alerts on your critical jobs to email you if they fail.
0
 
LVL 21

Expert Comment

by:mastoo
ID: 35061076
You could look at the job history to see when it ran and whether it failed.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now