Combining Log Shipping and Database Mirroring The principal database in a mirroring session can also act as the primary database in a log shipping configuration, or vice versa, as the log shipping ...

Log Shipping and Logins Establishing a failover server for your SQL Server? First things, first: strategize on your logins. By Eric Johnson 06/28/2010 So you decided to set up log shipping in ...

I will run you through the configuration on an SQL Server 2008 instance, but the options remain quite similar for SQL Server 2005 and the Denali CTP (which in all likelihood would be SQL Server ...

In SQL Server 2008 R2 you can set up a Utility Control Point and monitor both solutions to see which one performs best with your data. That will give me something tangible to test using this new ...

Whereas Oracle met the demands of mission-critical, 24/7 operation with features such as online re-indexing, snapshot-based restores, and fail-over log shipping, SQL Server couldn’t provide true ...

For our new production environment, we're going to be using SQL 2005 and do log shipping from our main machine to a secondary machine. Part of this environment will include a migration process ...

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it ...

Prerequisites The primary database must use the full or bulk-logged recovery model; switching the database to simple recovery will cause log shipping to stop functioning. Before you configure log ...