News

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 ...
BANGALORE, INDIA: Your users expect your systems will stay up as much as possible. This would be in the face of unexpected events such as system failures as well as planned downtimes such as ...
Log Shipping in SQL Server has been around for a while and still provides an easy method for redundancy and load balancing. It uses standard backup and restore technology to ship backups to a ...
SQL Server's high availability options, log shipping (yes, log shipping is HA and DR!), availability groups and failover cluster instances work. Availability groups have some challenges ...
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 ...
I know this should work fine, I just want extra eye balls to make sure I'm not missing anything. I have a 2008R2 server that I'm planning to move a bunch of databases to a pair of SQL 2012 servers ...
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 ...
Idera, a provider of management and administration software tools for the Microsoft SQL Server database, has introduced SQLsafe 5.0, the latest version of its high performance backup and recovery ...
When log shipping is configured, a full backup of the database is copied to another server. From that point forward, transaction logs are periodically sent to the other server where they are ...
Additional SQL Server Agent capabilities -- SQL Server Agents can be used to keep replicas in synch with log shipping. Listener for Always On availability groups -- The listener enables clients to ...