Data Engineering – Learn from the experts

  • Pros and Cons of Database Snapshot

    The following are the advantages and disadvantages of database snapshot.

  • How to configure Database Mirroring

    I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Deepak —> Principal DeepakSansu —> Mirror DeepakTest —> Monitor

  • Log shipping – Sql2005

    Log shipping allows you to automatically send transaction log backups from one database (known as the primary database) to a secondary database on another server (known as the secondary server). At the secondary server, these transaction log backups are restored to the secondary database, keeping it closely synchronized with the primary database. An optional third…

  • What is Log Shipping

    Log Shipping is one of the methods for creating a Standby server, by god forbidden if something happens to our production server we need a standby server and Microsoft has come up with this idea and introduced Log Shipping in SQL 2000 itself. But in SQL 2005 it has been enhanced further by making it…

  • Role Change in SQL 2005 Log Shipping

    In SQL 2000 where the role change was relatively easy through the use of stored procedures, unfortunately in SQL 2005 those SPs are no longer used and we have to perform the following steps to sync the secondary server with primary and then failover.

Got any recommendations?