RE: Backups
From: Steven Parsons [MSFT] (stevenpa_at_online.microsoft.com)
Date: 06/03/04
- Next message: Ron Hinds: "Convert bit feld to Yes/No"
- Previous message: Steven Parsons [MSFT]: "RE: Access and Solomon Databases"
- In reply to: Deb Struble: "Backups"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 03 Jun 2004 17:58:43 GMT
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)
- Next message: Ron Hinds: "Convert bit feld to Yes/No"
- Previous message: Steven Parsons [MSFT]: "RE: Access and Solomon Databases"
- In reply to: Deb Struble: "Backups"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
