it is 32 bit both os and sql

Thanks Manu,

OS version is Windows Server 2003 Enterprise Edition

and

SQL Server is

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Regarding deleting log file, please refer to below links.

http://technet.microsoft.com/en-us/library/ms191433(SQL.90).aspx

http://technet.microsoft.com/en-us/library/ms189253(SQL.90).aspx

http://technet.microsoft.com/en-us/library/ms175574(SQL.90).aspx

Please check the process.

Is the process running slower than normal?

If so, please check more on this process.

Could you share that process with us.

Just see what is the process doing. Run a dbcc inputbuffer(spid) and get details of that.

Once you have that, just check the execution plan of this query and see...

GilaMonster (2/25/2010)

---

Casper101 (2/25/2010)

---

During my index rebuild, some DB's log files grow really big. I have been advised to switch the recovery model to BULK_LOGGED before the rebuild, and then...

I guess those indices are a problem in your case.

Usually, too many indices hinders insert operations.

Once, when I faced this problem, I dropped the indices during the insert operation...

Thanks Manu

MANU-J. (2/17/2010)

---

SELECT [task_detail_id]

,[line1]

,[line2]

,[line3]

,[line4]--Displays Age: Older than...

Greg Charles (2/17/2010)

---

If you mean when the file will be deleted by the Cleanup Task in the maintenance plan, I think you can only find that in the plan itself,...

TravisDBA (2/10/2010)

---

BTW, you can write some T-SQL code with little effort that will check disk space on all fixed drives on your db server via a daily job and notify...

Blake,

Thanks for sharing. I will try this on my server.

In fact, I had removed the @query parameter. Will try it out again. 😀

One more point.

The IP addresses of servername and servername-BE are different.

I am able to ping both these server names.

But I am only able to register\connect to servername-BE

I am getting same servername when I run below commands

select @@servername

select serverproperty ('MachineName')

But I am only able to register/connect with this name servername-BE,1433 and not

servername,1433

When I run this select serverproperty ('ComputerNamePhysicalNetBIOS')

it returns NULL.

Is this because the server I am referring to is SQL Server 2000.