Solved

Backup file missing

Posted on 2011-03-07
2
200 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 40

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

830 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