description: Learn how to configure log shipping by using SQL Server Management Studio or Transact-SQL in SQL Server.

Log shipping involves two copies of a single database that typically reside on different computers. At any given time, only one copy of the database is currently available to clients. This copy is ...

The recent versions of Microsoft SQL Server include several high-availability solutions like failover clustering, database mirroring, log shipping and replication. In this article I will describe one ...

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

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

The recent versions of Microsoft SQL Server include several high-availability solutions like failover clustering, database mirroring, log shipping and replication.

A production server configured for log shipping transmits SQL Server transaction-log backup information to a secondary server regularly and automatically. But under log shipping, the failover ...