• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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