Using XP_FIXEDDRIVES you can get the free disk space in all drives:D

Hi Sugesh,

Think Mirroring has to be removed.

If downtime is ok for you then and am with Deepak ,Go ahead with detach and attach.:)

Think you cant back to the state you want.A full backup now will give you all datas as of now and a differential contains changes since the last backup only.

Hope...

Use "sp_attach_db" for attaching and "sp_detach_db" for detaching the database files.

Check these links

http://msdn.microsoft.com/en-us/library/aa259611(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa933267(SQL.80).aspx

😀

Use "sp_attach_db" for attaching and "sp_detach_db" for detaching the database files.

Check these links

http://msdn.microsoft.com/en-us/library/aa259611(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa933267(SQL.80).aspx

Can you please be specific and more clear on your requirement:).

Create trigger for the same..:D

Kumar ..u got connect or still the same problem persists ???

connect giving InstanceName\SQLEXPRESS

To which edition of SQL Server you are connecting????

I checked the error logs but find only that particular database started. Searched for the word 'Delete' 'Drop' but no use...

I have error log ..Is that helpful.Can i find who deleted the database and when???

Schema have many purposes,One thing is you can create tables having same name under different schemas.

Thanks Gila..:D

Ya my user is a local admin.I tried using another login which is not a local admin and am not able to restart the server.

Once again thanks