The compressed(zipped) folder is invalid or corrupted – Not always true !

Have you ever encountered this error message when tried to extract zipped backup files using built in ‘Extract All‘ facility of Windows –

The error message will first give you an impression that the zip file might be corrupt.

This might be true in some cases like a file not downloaded fully from FTP, copied over a network and got corrupted etc.

In most of the cases I have experienced, the zip file was fully functional and it never had any corruptions. The extract all facility still throws errors even though the zip file is valid.

I am not at all a big fan of using the zip/unzip OS facility provided by default, hence I depend on tools like WinRar,PKZIP etc which offers better compression rate, speed etc.

I would recommend extracting the zipped file using any of the above mentioned tools and see if the zip file is really corrupted.

The same zip file which showed errors while tried to extract using the default extract all feature was proved fine and was inflated using PKZIP utility


It’s not always true that the zipped file might be corrupt, hence you should always leverage third party tools to test the file validity.

Thanks for reading.

Data collector jobs [ collection_set_2_collection / collection_set_3_collection] long running duration !

Recently there was an interesting question from one of the forum users ,the question was something like ‘How long the data collector jobs are scheduled to run when I configure Data Collection in SQL Server 2008?My job is running since 3000 minutes’

To understand this behaviour we need to look into what Data Collector is all about.Data collector was first introduced in SQL Server 2008 and it used to collect various data and it can be stored in a database called Management Database Warehouse(MDW).Data collection is made and stored in the database to analyze for different time periods.Data collector currently provides 3 reports,which are Server Activity,Query Stats,Disk Usage.

To understand more about Data Collector you can always refer

The data collector jobs will run continuously as long as the SQL Server Agent is running[This is the default setting] and it is scheduled to start when the Agent starts.This jobs will collect the data continuously and the upload job runs as per schedule(By default every 15 minutes).


[Data collector is available only in SQL Server 2008 and above]

Best Practice Analyzer – Can sneak in and give some important tips!

Lets start the month with some best practice’s.

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer will allow you to scan your sql server instance and will report potential issues.There is a error area and warning area which will give detailed explanation of the issue.

Looking at this report will help you to fix potential problems.

Best practice analyzer works with Microsoft Baseline Config Analyzer and baseline config analyzer is used to scan the instance.

Recently when I scanned instance,I got the below report which quickly helped me to fix some potential issues.

Just give a look at the error part.You should never see this in PRODUCTION environment!