gbargsley (7/18/2008)

---

Hello...

I am in the process of cleaning up some database records. This is a yearly purge type of process for my software application.

As it sits, my SQL DB...

You dont mention how big the disks are but i would opt for a RAID1 config on both drives and install everything to the 1 logical drive.

If the drives...

from memory i'm certain the cluster name is published into AD, search AD for the cluster name and check the container it is in

On the production servers i have migrated there have always been a substantial amount of windows\sql user logins that have a default database set. Just the way i prefer to...

you would need to move the databases first otherwise when the script runs to apply the logins it will most likely fail as it wont be able to set the...

how big is the log file?

the file will not shrink if there are transactions occupying the file. You would need to truncate the log first to clear transactions then shrink....

barb.wendling (7/18/2008)

---

What would be the recommended set up to optimize performance on a new server with 8 144 GB hot swappable hard drives? It was suggested that 2 be mirrorred...

have you checked the sql logs for any errors?

what backup product are you using?

LISETH_T (7/15/2008)

---

I upload the application on three different servers (same code, same DB) and it works perfectly. However, when I publish it on their server it doesn't work. ...

go into add\remove programs and find SQL server 2005 then click remove.

the wizard will start and ask which instance you want to remove. select the radio button for the...

even if you dropped the PK and loaded the data as soon as you try and re create the PK it would fail anyway

why not alter the column and add the NOT NULL clause.

set the database to bulk logged recovery mode before executing the delete statements

for a filegroup to be of any use it would need to be spread across a separate array to the primary filegroup. Cant see any advantage to creating filegroups and...