russell (1/21/2008)

---

move the transaction logs to the new array.

when was last time all indexes were rebuilt? rebuilding indexes might solve all of your problems right there. was is Cache Hit...

bbychkov (1/21/2008)

---

Hi Jason,

Based on the info you have I'd suggest to make a RAID 1 of the two new drives and put all the transaction logs including tempdb's log there.

However,...

Steve Jones - Editor (1/21/2008)

---

Sites such as this one are good for general knowledge. Depending on time, you could go back through old articles and see what you learn....

Roy Ernest (1/17/2008)

---

It will be an advantage for you since you have a pretty good grasp about Networking , Hardware. If you are being send for training then it should...

Sorry for the late response. Have been trying to do some research on this.

As of now, it seems to be holding at 17gigs. I have not seen any further growth,...

Matt Miller (1/11/2008)

---

As of right now - the way to have 2 actives and one passive is to have 2 instances being serviced by 3 machines. Meaning - the...

Appreciate all the feedback and recommendations. I still have a lot of research to do for this project.

Just some more info and questions:

I was going to use Windows Server 2003...

Thanks for the links. I really appreciate it.

I think we are going to do a full blown cluster for all SQL parts; database, reporting services (I know there is more,...

"...Since you are using PAE, it is not recommended you still turn on /3GB switch.

As we know, using /3GB will cause the OS to have only 1GB memory for system...

Thanks SQLBill. That makes perfect sense.

I just need to keep reading up on Indexes.

BTW, how do most people fix their indexes? I am assuming a script? Do you do each...

Thanks for the help. Makes sense really, but I just need to keep reading and learning.

Clustered index, 'fill factor' 

I wouldn't think so.

Just double check in EM, under the properties for the server -> processor, make sure the new CPU's are there.

Probably have the option to do more tweaking...

I don't seem to be able to specify a network path when choosing a location.

Something I am missing?

This is in the maintenance plan wizard walkthrough.

Can you setup a maintenance plan and tell it to backup to a network share?

or can that only be done through a script?

Thanks, I appreciate it.

I would like to automate this with a script. So two questions:

1.) When I use the script to backup my databases and TLogs, should I use a...