So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

This is one for those SQL dba's. Currently, we're running a DB maintenance plan every hour that writes transactional logs to a backup directory on another server in case we lose the SQL box in the ...

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

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

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

SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

Microsoft has two primary platform as a service (PaaS) offerings for SQL Server running Azure: Azure SQL Database, which is primarily used for new applications that were developed and grown in the ...