Barkingdog (12/5/2008)

---

We are getting our first SAN (yeah!) and I think a good disk approach for an OLTP sql 2008 server is this:

drive C: OS, pagefile

drive D: tempdb

drive E: log...

begs the question, what other apps are running on these sql servers?

nick harris (12/5/2008)

---

Thank you for your replys.

So to list out the current spns I should use

SETSPN -L against what server? My domain controler or my database server? If...

32 bit or 64 bit?

dva2007 (12/6/2008)

---

Hi friends,

i have got sql server developer edition which is having different types.

SQL Server Itanium

SQL Server x64

SQL Server x86

I have got Windows Vista Home on my machine. Which...

there do seem to be problems with services running under domain accounts not registering their SPN's, local system works fine.

SETSPN -L

should list all registered SPN's (not just for sql server)

use...

a warm server should show very different memory usage

if you've only just started it, monitor for a week or so

how big is the database?

you could use SQLExpress 2005 if its under 4GB

from BOL

Logical and Physical File Names

SQL Server 2005 files have two names:

logical_file_name

The logical_file_name is the name used to refer to the physical file in all Transact-SQL statements. The...

the logical filename is generally used internally by SQL server, changing it to something different after copying the database is something i would defintiely do.

i would re apply SP2 in this case

Niyala (12/4/2008)

---

Thanks.

Because it would be much easier for me than adding individual members manually and, therefore, I wanted to import the Builtin\adminstrators.

Alternatively, I wanted to create a login for a...

its more to do with admin rights on the box, put yourself in the administrators group on the server and watch the little green arrows appear 😉

your welcome

why would you want to allow any windows server admin access to sql server as an admin?