Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-26 : 07:45:23
|
| Rob writes "We run clustered web servers that generate huge amounts of log data. I use a perl script with ActiveState perl for win32 to parse the log files and insert the records to the database. A typical logfile is in excess of 100 mg in size. I rotate logs 4x a day for 3 servers which ~ 400 mg for 3 servers which ~ 1.2 gig a day total.My backup strategy is a full backup on Sunday. I do a differential backup every time my perl script runs. I average 4 differential backups a day. This works just fine. I'm testing restore strategies. How do I find the number of differential backups stored on a backup file? Ideally I would like to determine this dynamically. Thanks!-Rob" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-26 : 09:47:15
|
| All of the backup history data is stored in msdb in the backup tables. Dates, size of backups, and backup types are available. You could set up a query to determine how many were done on a particular day for any media set. |
 |
|
|
|
|
|
Dynamic determine Differential backups