The August edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column.
This month's topics are:
Check it out at http://technet.microsoft.com/en-us/magazine/dd776512.aspx.
Happy Fourth of July to all who celebrate! I’m looking forward to a great view Thursday evening looking west along the Skagit Valley with some
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker –
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
3 thoughts on “TechNet Magazine: August 2009 SQL Q&A column”
Paul,
If you use Bulk Logged in a Log Shipping scenario as opposed to Full recovery will everything be applied to the standby server or are there certain actions that will not be shipped? In other words, when we have to bring the standby server online will it be identical to the source or will some data/indexes/etc be missing as a result of running under Bulk Logged?
Regards;
Greg
Nope – everything works perfectly in BULK_LOGGED as far as log shipping is concerned.
Paul,
I discovered that with Veritas Backup Exec backup software, performing a full backup (as described by the software) does not backup the log file too. Just the database — even if your database is set to Full recovery model. Therefore, the log file continues to grow.
In order to manage your log file with Backup Exec, you actually have to schedule another job to perform a backup of the log file. Then your log gets truncated correctly.
For anyone that uses Backup Exec, or any backup software, review your settings and make sure the log file is included in a "full" backup.