November 25, 2008 at 9:17 am
Does anyone have an idea on how to guarantee that I can keep the rotating SQL Server Logs for 1 year? I know that I can change the number of logs that are rotated to 99, but that does not seem like what my boss is looking for.
Thanks
Aaron
Aaron
MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard
November 25, 2008 at 9:29 am
You could just copy the log files to another location and delete them as they age past one year. I haven't done it, but I'll bet there's a way to automate it.
In my shop, we have scheduled tape backups of the directories on the database server and the log folder is included, so the log files are saved on tape for a year.
Greg
November 25, 2008 at 9:33 am
That was my first idea. Then I was thinking that the Windows Event logs can be changed to save for 1 year if you make the maximum log size large enough.
Thanks for the assistance.
Aaron
Aaron
MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply