Hi,
I want to check the database before restore (.Bak file).
Chk the current database tables Vs tht backup file..
Is it possible..

Depends what you mean by "check". Also the format of your file affects your options.
Most technically simple is restore the backup under a differently named database and run whatever checks you need.
If it is a native backup, or is one supported by the respective vendors, then several vendors supply software that allows you to link to a backup file and access it like a normal database without actually restoring it. Again, you can apply your tests

pootle flump ur codings are working excelent.

thanks Flump...
Check Means ..
I want to compare the current db table structure Vs Already backup file..
If any changes means i dont want to restore ..
else I want to restore the db

I hope u understand..

Thanks

Restore with a different name and run SQLCompare (red-gate) or VS2008.