if you have underlying hardware RAID leave the windows disk types as Basic, you do not want or need dynamic disks.

is the hardware the same on both machines?

you could use symantec GHOST

why not use one of the built in templates. checl BOL for the template details

i would check the folder and then the file permissions on the folders the log and data files reside in and the database files themselves, that will undoubtedly be the...

New Commer (7/3/2008)

---

Hi There!

i have a query like this,

Select Distinct Table1.name, Table1.Code, Table2.Place, Table2.Marks From Table1 inner join Table2 on Table1.code = Table2.code

which results,

Name1/N1/Nagpur/114

Name1/N1/Nagpur/154

Name1/N1/Nagpur/123

i want it to display as

Name1/N1/Nagpur/114

...

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. ...