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

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

There's no reason why your database *needs* to be stuck in read-only. I think there is, in order for this 3rd party database restore tool to work correctly. It might be a different story if we could ...

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