Pau Lo
asked on
log file backup query MSSQL
Is there an easy way to query last backup date for log-files for a specific SQL Server instance (i.e. for all databases), but only the log file as opposed the database files? This is a MSSQL 2005 instance.
Also – as log files are for point in time recovery – should you be backing them up regularly, i.e. hourly, or do you just back them up each day – and which point you could restore to any given point during that day?
Also – as log files are for point in time recovery – should you be backing them up regularly, i.e. hourly, or do you just back them up each day – and which point you could restore to any given point during that day?
ASKER
How can you query last backup dates for the logfiles
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
for that you have to opt for differential back up with full recovery mode.
Differential backup will store the backup from last full back up and at the point of time recovery you can get the data from last differential back up.
If the differential back up is hourly then you can get that much point of data by this method