Backups

  • Thread starter Thread starter Deb Struble
  • Start date Start date
D

Deb Struble

I recently migrated one of my backends from Access to SQL. I am wondering
how other companies handle monthend and yearend copies of the data? In the
past, when it was monthend time I would create a copy of the backend and
copy it into a "month" folder. I now have a monthly folder for every month
for the past 3 years! The Accounting Department has requested I do this and
I have not been able to come up with a real good reason as to why I
shouldn't besides the fact that it is a waste of my time and space. I then
make a monthly copy of the frontend and link it to the current monthly
backend data. Rather than running their reports at a certain point in time
they prefer to run them a few days after the monthend...this is the only
reason I can come up with as to why they want these monthend companies. I
was hoping once I moved everything over to SQL that I could convince them
that it would be too administratively time consuming to keep all these
copies. Any suggestions? How do other companies handle it? I know that
changes have been made to the monthend copies from time to time and I am
wondering if this is even kosher with the General Accounting Practices? If
we continue to store all these copies on the SQL Server will it eventually
bog down the system?
Thanks for any advice!
 
Hi Deb -

This is Steven from Microsoft Access Technical Support replying to your
newsgroup post.

You may want to consider reposting your question to the following newsgroup:

microsoft.public.sqlserver.datawarehouse

The newsgroup to which you have currently posted your question
(microsoft.public.access.adp.sqlserver) is specific to Microsoft Access
users and developers, and they may not know the best way to manage backup
copies of your SQL Server database.

I will say this, however, that the methods by which you maintain backup
copies are as relative as the methods by which you choose to buy a new car.
In other words, whatever suits your taste and preferences, just as long as
you have them. And just like a car, you can't go vary far any more with
them.

Personally, I like to keep 10 backup copies going at all times, labeled:

Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Week
Month
Year

You could think of these as folders, where every Sunday's data gets backed
up to the Sunday folder, and every Monday's data gets backed up to the
Monday folder, and so on. The data I saved in the Month folder for April is
fine. But by the end of May, my database now has both April and May data,
so why not just overwrite the data in the Month folder that was collected
in April with the data that I now have by the end of May. The database has
both April and May data, right? But again, it is all about preference, and
big hard drives are cheap these days.

Please let me know if this solves your problem or if you would like further
assistance. I look forward to hearing from you.

Sincerely,
Steven Parsons [MSFT]
Microsoft Access Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! (http://www.microsoft.com/security)
 
Back
Top