Welcome to TechNet Blogs Sign in | Join | Help

September 2005 - Posts

Wednesday, September 14, 2005 11:20 PM

Can I have more than 6 Archive logs in SQL 2005?

I was asked this at the Providence, RI event and didn't think it could be, but I did find this that works for SQL 70 and SQL 2000. I haven't really verified it but I'm sure it would work with SQL 2005 either as is or with some minor modification. http://www.sqljunkies.com/HowTo/0DE35937-5475-4DC7-8490-C54A02143B24.scu
Posted by johnbaker | 0 Comments
Wednesday, September 14, 2005 11:09 PM

How do I change the backup retention period in SQL 2005?

I was unable to answer this question at my Providence, RI event this week regarding changing the backup dataretention period. Here's the answer I got from where else but the SQL2005 Online Books: To set the backup retention duration In Object Explorer,
Posted by johnbaker | 0 Comments
 
Page view tracker