I don't know that I have seen a specific recommendation. Unless I had a definitive reason for changing the default port - I would not change it.

Yes, each instance in the cluster can use the default port.

sql_lock (6/2/2009)

---

I have notice with SQL 2005 that if you are backing up a large amount of transaction (no trans backups for 2 days) then the agent job running the...

That was going to...

You also could have a long running open transaction that is keeping the log file from being re-used. Another thing to look at is whether or not log shipping,...

homebrew01 (6/1/2009)

---

Yes, I can see the database in SSMS GUI, But I get an error if I try to display properties, and there is no + sign to expand it.

"Database...

How many databases do you have on this instance?

How many of these databases are in full recovery model?

How often are you backing up the transaction log for each database that...

sql_lock (6/1/2009)

---

Every evening (11pm) I run a full backup, and then I do a log backup every 15 mins (from 0300 to 2245). Doing the full backup and the subsequent...

What edition of SQL Server are you running? Standard or Enterprise?

What is the max memory setting for this instance?

Tracey, it looks like this server has 16GB of memory on it. Can you confirm?

If so, what else is installed and running on this server? Because, if you...

I would very much doubt that this is a problem with the drivers being used to connect to the database. As far as those drivers are concerned, they have...

You don't want to use all processor for several reasons. One reason is that you have multiple queries all using parallel plans, the system is going to take longer...

Karin Zirk (6/1/2009)

---

Is the server the database is setup on dedicated to SQL Server? - YES

Did you set the lock pages in memory option? - NO

Did you set the...

The above setting tells SQL Server that any plans that will exceed that value (estimated), then a parallel plan will be used.

Max Degree pf Parellelism...

You have a dot in the extension (bak instead of .bak) - remove that and it will work.