That is right, But i am asking any sql server specific tool (third party) which can recover data which is deleted accidently,like tools available to retrive data deleted from recyclebin....Any idea...

Rudy,Thanks for the link

Rafi-

select master> Extended stored procedure> sp_sdidebug >right clk properties and check permission ,whehther your username has exec permission on this.?

Thank u kishore and Allen!

Allen, I have examined the logs as directed and it found out that

Server Application Log

Logwriter : Operating System error 112 [There is not enough space...

which version of Sql u are using ? Which debugger are u using , T-sql ????????????

The following will also serve your purpose

use <database_name>

go

sp_helpfile

go

--------------------

You will get following fields

fileid   groupid   size        maxsize     growth      status      perf        name       filename                                                                                            

Move your scrollbar and check it out

select * from sysfiles will work for u in QA

Also in EM u can slect DB>Right Clk> Properties>Clk Dtafiles or Transaction Log .Below u Can see Location of the DB.

Mr. Prasad,

It is better to keep patiance and hear  others  if you are rising a question for help whether answer is generic or not.Second if question is of generic nature don't...

System may get hang when the size of the DB's get large.It is better to schedule it at different time according to server load.In your case now DB size is small...

I am using a tool to compress my DB's and to store it to other node in the network.It zip the database according to the ratio specified.It will not affect...