What multi-threads simultaneous process did you run? Can you be more specific in details?

I would ask hardware people to check the I/O subsystem again.

Did you try to connect MSDE instance?

Edited by - allen_cui on 12/08/2003 1:42:01 PM

It is trace file with date and time, such as audittrace_20031208144551.trc.

I would verify whether C2 auditing is enabled.

Try database reverse engineering in Microsoft Visio.

You have to restore full database backup first and then transaction log backups which created since full database backup in the same sequence.

Try to backup/truncate the database log and shrink it again.

Can you post result of sp_configure here?

alter database pubs remove file pubs_data2. For details, see BOL.

Make sure the file you are going to remove is empty.

DBCC SQLPERF(LOGSPACE) will tell you how full the log file is.

Run "backup log yourdbname with truncate_only" to see whether the usage decreases.

First, Set the log file to auto growth.

Try to see whether there are open transactions using 'dbcc opentran', if they are, you need to find out why they are...

You need SQL Server Enterprise Edition.

See BOL 'Maximum Capacity Specifications'

It should be 16384.

Using AWE Memory

To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000...