dont shrink, just increase the log backup frequency is the message here!!

anthony.green (7/11/2011)

---

are you also taking active directory offline?

if so dont power on the sql servers until ad is back online.

our server guys have fallen into this trap many a time,...

you can increase the frequency of the LS backup job without issues.

You could run the backup job every 15 mins as Gail suggested and the copy and restore jobs once...

have you installed the pre requisites onto Windows 2003.

You will need Windows installer 4.5, .NET 3.5 framework and the filestream hotfix for Windows 2003

opc.three (7/9/2011)

---

If you did follow Method 2 you could always try the long way around and migrate the logins to 2005 per the article, then from there to 2008 per...

😀 😉

Good point Jim on the disk sizes.

why not just wait until you migrate to the larger server?

disk configs for 16...

surely you mean 1TB tempdb, 1TB log and 1TB data.

RAID 0 (Striping)...

The cluster.log file holds detailed information on cluster actions. This file is found in

C:\Windows\Cluster

To check the status of cluster groups and which node they are online on, use the...

i am able to change the owner at the principal with no issues,...

shutting down the Windows OS will gracefully shut down all running processes including SQL Server.

Helical Johan (7/8/2011)

---

Hi,

I have sql server 2008 in windows server 2008, together 32 bits. The problem is

in the memory. It´s full. I enabled the option: Use AWE to allocate...

Lowell (7/8/2011)

---

i'm very eak on this, never implemented it, but i thought there was a "Force Encyption" property on the server that could do that; otherwise it's an optional client...

Best way would be using IPSec to encrypt the traffic between the nodes

This link details permissions required for a domain user account. It's important to remember that as well as local security policy assignments the account needs ACls across various parts of...