This thread is a little old, so please bear with me.

SPNs and Kerberos work, but for a 2003 cluster, they are not created automatically. When using SQL in a...

I guess the reason noone has responded is because there is no answer.

You design a solution to meet requirements. You have asked a pie in the sky question about...

To address more than 2GB of VAS on a 32bit server you will require the /3gb and /pae switches in your c:\boot.ini

Then enable AWE in your sql server instance.

keep in...

The "best" setup from a security standpoint is balanced between least privilege, the implementation, support overhead and understanding how it works.

I would say use a service account with the relevant...

Jeff Alexander has a link to a Microsoft IT article describing how they recently consolidated their SQL installations.

http://blogs.technet.com/jeffa36/archive/2009/03/19/how-microsoft-does-it-new-sql-consolidation-content-available.aspx

MS provide services via the Compute Unit and Storage Unit. With SQL...

Your application should be what is providing an output in a particular format, not SQL Server. SQL provides a data layer.

Previously to output MS Office documents you had to...

SQL Server will attempt to use all the memory available - if you let it. You should set the MIN_MEM and MAX_MEM options appropriately for your system. I...

A Full Backup backs up everything you point to

A Differential Backup backs up everything you point to that has changed since the last Full Backup

An Incremental Backup backs up everything...

stonecold560 (5/18/2009)

---

One other question I had. Do I need to backup differential log? I am doing transactional logs right now. I am doing every hour for transactional log.

Thanks for your...

Virtualisation is a great tool - however you still need to test your particular environment. Also, not all solutions meet the requirements of every problem - eg, depending on...

I have never seen a database backup agent that didn't cause problems.

As a rule of thumb, never use database backup agents from backup software. It is much better and...

intekhab.alam (5/15/2009)

---

Thanks for response.

Here are the details abt my env...

I am migrating db sql2k -->sql2k5 where sql2k5 is running on 2 node cluster. and to balance the node separating the...

shivani.suri2 (5/15/2009)

---

Hi Andrew,

Thanks for the help.

By 'particular location' , do you mean clients expect WKS or SQL Server Browser service to be on port 1434 and they will not...

SQL Browser provides a Well Known Service (WKS) and clients expect it to be in a particular location.

If you wish to remove the Browser service (please do, it's awful, cumbersome,...

Some people use separate tables, some use separate databases.

This is where table partitioning can be of great benefit. In SQL 2008, you can now use the SWITCH...