April 25, 2014 at 9:28 am
Hello,
This is my first time asking a question in this forum. I hope y'all (yes, I'm from the south) can help. My company is in the process of taking over the support of a web application that has a sql server db as the repository. There is a nightly job (or something) that creates a zipped .mdb file of the sql server data. We don't anything about how this file is created. Does anyone on here have any ideas on how this would be accomplished? Is it something that has to be done by Sql Agent? Is it maybe a sql script that is kicked off by the task scheduler? Is it a .net script that is kicked off by the scheduler or are all of these possibilities? I am just trying to see what I may be up against if we can't find out anything about the current process
from the folks that are currently responsible for the site.
Thanks,
Barry
April 25, 2014 at 11:42 am
Do you mean .MDF file ?
There are many ways it could be processed & scheduled. Have you looked at the SQL scheduled jobs ?
What is done with the file ? I hope it's not supposed to be a "backup". Regardless of what it's for, verify that proper Full SQL backups are being taken regularly, as well as transaction log backups for production databases.
April 27, 2014 at 6:57 pm
Homebrew, thanks for the reply. No, I do mean .mdb file. It's an Access database file. I believe users download the zipped.mdb file and do some analysis with it. By scheduled jobs, do you mean Sql Agent? If so, I don't have that as I only the free version of Sql Server.
April 28, 2014 at 1:00 am
.MDB file is Microsoft Access database file. It could be created by SSIS package or used by SSIS package. Try to find the SSIS job which might related to this .MDB file.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply