SQL Feeds - All your SQL feeds in one place.

Friday, February 13, 2009

Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 2/13/2009 4:54:00 PM

Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here: http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx. And, as a sidenote, depending on how much you already know about the transaction log - you might want to review that article first! The comment that came up was related to a common misunderstandin ...

[ read more ]

Best of the Blogs

by KKline via Kevin Kline on 2/13/2009 4:36:00 PM

Just in case you have too much time in your day, why don't you make sure that you're following all of the best blogs out there in the ether.  This list is all of the SQL Server MVPs that I'm aware of.  If you know of other worthy blogs, perhaps by non-MVPs, I'd love to hear about them! Aaron Bertrand http://sqlblog.com/blogs/aaron_bertrand/default.aspx Adam Machanic http://sqlblog.com/blogs/adam_machanic Adrian Downes http://adriandownes.blogspot.com Alan Koo http:/ ...

[ read more ]

Understanding the Transaction log

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 2/13/2009 10:54:00 AM

Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here:http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx. The comment that came up was related to a common misunderstanding on what is and what is not required to make a backup transactionally consistent when restored. And, in my opinion, some of the conf ...

[ read more ]

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us