September, 2005

  • 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...
  • 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...