yes the applications user is getting timeout errors when access/executing...

Tempdb seems is normal only and it is Production Environment so i could not restart server as of now..

So what step do i need to take in production environment to get free space in drive.

Please suggest me asap..

When i ran the above query It shows ' ACTIVE TRANSACTION' , So can i go for...

It is in Full Recovery Model and DBCC Opentran returns nothing..

Yes, but it is in production enviornment. So is there any alternative...

I need the query to find out the user who kept in offline, and the server version is SQL Server 2000.

Great...

Thanks anthony....

Yes I executed sp_helpdb <database name> but it is showing for one database, i need all the databases in server and datafiles size.

sorry, it is in production environment. It will not allo any down time also.

Is it possible to move existing data file to secondary file group?

can any one say please...

Thanks for you reply.. but after executing this alter statement...

can we do to move .mdf,.ldf to other location? or not ?

tell me in which cases the login can't go inside sql server....

x(86) 32 bit only

I want to know that If take first T-Log backup then I took Full Backup, is the data in the T-Log is also in Full Backup or not ?

please...