In the end, i recommend you the following:

1. RAID-1 for OC and Transaction files (for Tempdb and your application's DB)

2. RAID-10 for Data file (for...

I think that in the first you should answer the following questions:

1. does your software actively use Tempdb ?

2. which DB Recovery mode you are going to...

i had the same error. After installing SP3, everything goes normal

Copy-only backups are new to SQL Server 2005. They allow a backup of any type to be

taken without affecting any other backups. Normally, a database backup is recorded in the

database...

Yes i am agree with jeff.mason. Youn should begin to analyse Traces, this is will be very good start.

Thanks alot for you? answers

By using SQL Profiler. Try to recorde traces and then make anaylsis to them. The most important is to choose needed Events, for example this events which work ...

Did you try to make Analysis SQL-traces?

I had the same situation in three months ago. My DB log file began to increase and increase, I went around and around in the end i found the...

i am completely with your opinion. But to make your application support woking with DB mirroring , you should change alittle in application , and the problem is here>...

I am recommending using SCOM 2007. I am already use it/

i am agree 100% with umar iqbal, he is right

I also read one day about recommendation that PF is 1.5 P.memory.

but i send to you to understand something, more PF this mean more HDD usage, so if your...

1- Be sure that you created Endpoint at witness server, this is the script fo that

CREATE ENDPOINT [endpointmirroring]

STATE=STARTED

AS TCP (LISTENER_PORT = 1450, LISTENER_IP = ALL)

FOR DATA_MIRRORING (ROLE = WITNESS,...

i Think, it is enough for you 4000 PF as max(you can divid them among disks if you want), and in this situation more than 50% of your DB will...