August 27, 2003 at 3:55 pm
What is the best way to modify the SQL Server backup history tables? I would like to remove a line from the backup history for a particular database.
SQL Server records backup history in the following tables: backupfile, backupmediafamily, backupmediaset, backupset. However, not sure if modifying them directly is the best way.
Thanks in advance,
Billy
August 27, 2003 at 4:29 pm
I think modifying the tables directly is the only way for what you want to do; there's no stored proc, etc. that I know of. Where is it you want to keep the entry from showing up?
August 28, 2003 at 12:05 am
Hi Billy,
quote:
What is the best way to modify the SQL Server backup history tables? I would like to remove a line from the backup history for a particular database.SQL Server records backup history in the following tables: backupfile, backupmediafamily, backupmediaset, backupset. However, not sure if modifying them directly is the best way.
direct modification of the system tables is one of the best and quickest way to fool SQL Server. Unless you don't have a really important reason for this, I wouldn't do this!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply