chrisph (5/5/2010)

---

Yes the log file is set to autogrow by 10% (which was 100MB), I have set this to 50MB now.

The database is in FULL recovery mode.

There are no log...

If the sql server is running under a domain service account, then you could very gingerly go into AD and change the password, the RDP into the SQL Server using...

Bhuvnesh (5/5/2010)

---

In our environment , we have 3 log files for TempDB. my database director asked me to removed 2 tempdb file. he sail that we are fine with one...

The multi-server query is a great addition to SSMS, I remember just a couple of years ago when you would have had to RDP into 70 servers to get this...

It will iterate through server's if you are using a multi-server query that is available in SSMS2008, otherwise it will show just the server that you are querying against.

verygrumpydba (5/4/2010)

---

I've got a SQL 2008 2-node active/passive cluster (on Windows Server 2008 R2) that when I am remoted into the server I can connect to the default SQL instance...

Was/Is "Max Memory" configured?

You have to be specific when asking questions, no bod know why two servers use different memory amounts when you have told us nothing of what version,...

RonKin (5/4/2010)

---

I currently have a 2 node SQL Server 2005 Test Cluster. I am trying to add a database to the test cluster. I have copied the dotCMS-dev.mdf...

It depends on what it's used for...

Are you running SQL Server using a domain account or a local account?

More than likely you have it running as a local account.

NT Authority\System just does not take backups, you...

Intuitevly that's all wrong, if your using dymanic ports you need it, not for static.

Here's is MSFT's documentation for the browser service for 2008, it makes no mention of it...

Could...

This is a very good tool for looking at the cluster log

http://www.microsoft.com/downloads/details.aspx?familyid=B898F587-88C3-4602-84DE-B9BC63F02825&displaylang=en

Not without more...

Mani-584606 (4/30/2010)

---

I've done this, and we've set static ports in the firewall. If you don't do this, then you open a big range on the firewall, which upsets security people....