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

Learn how to remove a log shipping secondary partner by using SQL Server Management Studio or Transact-SQL in SQL Server. Connect to the instance of [!INCLUDEssNoVersion] that is currently the log ...

Change Roles Between Primary and Secondary Log Shipping Servers (SQL Server) [!INCLUDE SQL Server] After you have failed over a [!INCLUDE ssNoVersion] log shipping configuration to a secondary server, ...

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

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