January 13, 2011 at 2:54 am
Hi,
I have a number of databases that are surplus to requirements. I need to retain the data in an archived backup. However, space is at a premium and so I need to only store the minimum amount of data possible.
The databases I plan to archive have been in full recovery mode, so the t-log backups are quite large. I am confident that the db data is now static and that transaction log information is no longer required.
Is it safe / wise for me to run only a db backup, then drop the database and delete the t-log backup files? Is a t-log backup file required for a successful restore?
Apologies if this is a noddy question - as you may have guessed I'm not even an occasional DBA.
Regards, Iain
January 13, 2011 at 3:08 am
irobertson (1/13/2011)
Is it safe / wise for me to run only a db backup, then drop the database and delete the t-log backup files? Is a t-log backup file required for a successful restore?
If you need to restore to a point-in-time other than that of the full backup, yes. If you're certain that all you need to to restore the DB to the time of the full backup, no (and in that case the DB should be in simple recovery with no log backups)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:12 am
As I thought, but always good to get confirmation!
Thanks, Iain
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply