News

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 ...
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 ...
SQL Server's high availability options, log shipping (yes, log shipping is HA and DR!), availability groups and failover cluster instances work.
I have a 2008R2 server that I'm planning to move a bunch of databases to a pair of SQL 2012 servers that will use mirroring instead of log shipping, which is in use on the existing server now ...
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 ...
Delayed durability offers something that many SQL Server professionals have wanted for years-the ability to disable transaction logging. Why turn off the transaction log? You can accelerate ...
Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...
Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target.