First let me say I know nothing about SQL backups, but I need to understand the logic behind what one of my database admin wants done.
I have been asked to take over the backup of our SQL database. The requirements are:
A rolling 7 day daily backup
A backup of the transaction log in such a way that the database can be restored to ANY point in time. By that he means ANY time, a day ago, a week ago, a month ago, etc.
In addition to any SQL backup I do he wants a file level backup as well.
So here are my questions:
What is the best way to automatically backup a SQL database?
Currently the transaction log is 40 GB in size for a database that is only a few gig. I have advised the DB admin that he could backup then shrink the transaction log to make it more manageable. He says, no, he needs to keep all of the transactions in that log just in case he wants to roll the database back to ANY previous day. Can anyone explain what you would want to do that? Also, what is the best way to backup the transaction logs, shrink the log file and give the admin what he wants?
The admin also wants to have a file level backup done of the database. If I am doing a SQL backup why do I need to do a file level backup as well?
Thanks in advance,