Log Shipping Cannot Access the File

New author Brian Bitzer brings us a solution to a log shipping problem in the Real World. Read about jhow one DBA solves a contention issue using SSIS.

High Availability

Sync All Logins on a Server in a single click using SP_MSForEachDB

Reduce your recovery time and minimize the chance for error by resolving all logins in one script.

Custom Log Shipping

This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.

SQL Server 2005 log shipping setup using the wizard

Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.

SQL Server 2005 log shipping setup using the wizard

Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.

RE: What will be the method to parse/Manipulate data queries?

I definitly agree with David, using a view would solve your problem in a fast and very simple way. //Hanslindgren  

RE: Should I change my avatar

I'm trying to help a new meme along:http://www.corante.com/copyfight/http://www.google.com/search?ie=UTF-8&oe=UTF-8&q=copyfight&domains=boingboing.net&sitesearch=boingboing.netThe fight being that your avatar is fair use of an image, and doesn't infringe.  Unfortunately I'd like to say this is a given, but it's not.

RE: Anyone applied the SQL Server 2000 SP 4(Beta)

Currently we are running a current version of Microsoft SQL Server 2000 at the patch level of 3a. I am getting hold of the BETA version of 4.I am not sure to apply this patchset 4 and whether it will cause problems if we next time move forward to upgrade to YUKON, SQL Server 2005 […]

RE: how to determin the transaction isolation level for the current session?

The only way I've been able to figure out the current transaction isolation level has been kind of a kludge using DBCC USEROPTIONS.  Check to make sure this works with isolation level set via ASP.   This method works for me but has not been tested in all scenarios for useroptions. set nocount on Declare @isolationLevel   […]