Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Backup file missing

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
SeTech
Asked:
SeTech
1 Solution
 
lcohanDatabase AnalystCommented:
That sounds like what may have happenend however you should set alerts on your critical jobs to email you if they fail.
0
 
mastooCommented:
You could look at the job history to see when it ran and whether it failed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now