parts 2 and 3 follow shortly 😉

exactly what do you mean by this? What is...

mmcginty

are builtin admins definitely in the sysadmin role, please execute the following against your instance and advise the results

EXEC sp_helpsrvrolemember 'sysadmin'

nathanr 81822 (7/11/2011)

---

but every night the log shipping writes one bad trn to the SAN and i get an event log error message in my inbox saying that the error...

TBH it shouldnt be too much of an issue as the service is normally set to retry 3 times by which time the DC should be available. Its best to...

Hi Mohammed

no problem, if you hit any problems feel free to post back here and ask (or create a new thread in the forum).

This is actually a 3 part...

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...