What is a Log Shipping?

High Availability is a hot topic today and need for a business critical applications, as a DBA we always try to cope up with such situation where High Availability and Continuity comes into picture their are technologies that you can use for; Log Shipping is one of them.Have you ever had a chance to set up Log Shipping? What are the benefits of using Log Shipping over Clustering or Replication? How ever it *depends* upon your environment and requirement at given time. Refer below link for Log Shipping...Log Shipping Artic...

Read More

What is Log Shipping?

What is Log Shipping? Log Shipping is one of the solutions for High Availability for business critical application. Log Shipping is first introduced in SQL Server 7.0. Log Shipping; as name defines does the shipping of Transaction Log to another server; it does exact replica of the database; it does backup of Transaction Log and restores it on a Secondary /Stand by Server which keeps database on secondary server in sync with the database on Primary Server. In case of failure work loss happens only for the time being copy of T-Log backup...

Read More

Logging and Data Storage Algorithms in MS SQL Server

Ever wonder how SQL Server Logs data in T-Log and Data Files? What algorithm it uses!!! What is ARIES (Algorithm for Recovery and Isolation Exploiting Semantics), refer Microsoft Knowledge Base Article http://support.microsoft.com/kb/230785 which gives the complete details how it works!! With the detail explanation on each steps and term...

Read More

Do Win a Lottery - Money from Microsoft

Hi,Now a days I have seen too many emails in my inbox fwd by friends and unknown persons claiming that THEY WON $$$$$ BECAUSE THEY FWD THIS TO THIS MANY PEOPLE, SOME ARE ASKING FOR ADVANCE MONEY TO GET YOU MORE MONEY and this type of emails are fake / fraud emails don't ever forward them and do not believe in this kind of emails. This is now confirmed by Microsoft Officials so ignore this type of emails and don't ever believe on it. Refer below link for morehttp://blogs.msdn.com/securitytipstalk/archive/2007/03/09/did-you-win-the-microsoft-lottery.aspx...

Read More

Download free Database Tools

At times we need to analyze the Size of the Database, or have to search the Object or Content in the Database, we always query system tables or create a script for self and some times we uses sp_depends,Query Analyzer and EM or SSMS but it has some limitations. To reduce this effort we often try some third party softwares and we know that they comes at cost. Mohamed Bouarroudj of  SQLDBTOOL has 3 software to help us out and yes they are FREE!!! There are 3 tools he has developed SQLDBDiff, SQLDBSearch and SQLDBSize. 1....

Read More