Space Management Report - Get Drive Size and Drive Free Space :SQL Server

One of the regular DBA practice is to maintain the free space on Drives where the data files are located. Here i have created a script (Space Management) which gives us the database files, its location,size, growth rate, the drive where its located, drive size, drive free space etc... Most of the thing is very easy to retrieve through SQL Queries as those are maintained in tables under msdb databases, but the free space and...

Continue Reading →

Script all the jobs in SQL Server

This is very interesting fact that people always look for shortcuts especially while accomplishing the big tasks. Here i have came up with a scenario: I have got a task to setup a new server B (lets assume) exactly as a replica of Existing Server A. It involve a lot of steps in which there is a step to copy all the EXISTING JOBS FROM SERVER A to SERVER B (Please note i have written All the Jobs).  Here is a easiest way...

Continue Reading →

Database is in Transition. try the statement later: SQL Server

Problem: I was trying to take the database offline to perform some maintenance on one of our QA server. We have got a strange error "Database is in Transition. try the statement later Error 952" Even i was not able to run the sp_who and sp_who2 also as it was also giving the same error. Resolution:  What i have tried? I closed the SSMS (SQL Server Management Studio) and restarted it again. Then to confirm and check for any blocking query, i ran sp_who and sp_who2 and it ran successfully.  Then to...

Continue Reading →