Author Archives: uday arumilli

SQL Server Production Issues

Posted on May 20, 2010 by uday arumilli

SQL Server Production Issues Prod Problems and Solutions:      Below are the common problems from production environment.  SQL Server Log full alert  SQL Server Blocking Alert Low Disk Space/Disk Full       Now here are the solutions for these issues…………….    SQL … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments

Static and Dynamic port in sql server

Posted on February 5, 2010 by uday arumilli

Static and Dynamic port in sql server STATIC PORT ALLOCATION If you configure an instance of SQL Server to use a static port, and you restart the instance of SQL Server, the instance of SQL Server listens only on the … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , | 2 Comments

Migrate Log shipping from SQL 2005 to 2008

Posted on January 15, 2010 by uday arumilli

Migrate Log shipping from SQL 2005 to 2008 This post helps us to Migrate Log shipping from SQL 2005 to 2008. LET’S upgrade the Log shipping from SQL SERVER 2005 TO SQL SERVER 2008 We have 3 different cases as follows: … Continue reading →

Posted in High Availability, SQL Server DBA | Tagged , , , , | Leave a comment