oh! that might work. I will look...

no worries! I will look into replicating the data and in the mean time I think my best bet is to get an automated restore setup.

I knew there was something about mirroring that would prevent me from using it...

thanks for the advice. I think I am leaning towards the backup/restore plan while I try...

Wow! I would agree with Steve and look at the VMWare setup. You can have IO issues with virtualized setups, and that would be the first place I...

Is the job history telling you that an earlier log file must be applied or that a more recent log file must be applied?

knowing that will tell you what step...

What does your job history tell you?

I would guess that you are missing a log backup between the .trn files you have and your last full backup -...

I've seen that a couple of times after a restore to a new Dev box, but only when there are config differences between the dev and prod boxes.. I...

Sounds like you have your bases covered...

one word of caution I have is that with my Active\Active cluster failover is beautiful to node2 and a nightmare to node1 - and...

Do you have SSIS setup as a cluster resource? if not is it installed on both nodes?

also, where did you store the dts packages? are they in a...

I left sql running on each node and no, it didn't pick up the second node when I did the install. Reboot was required for each node.

In retrospect, if...

I ran the install twice on my cluster (active\active 2 node). Once on each node.

I just finished installing sp3 on the last of my production instances and have had no issues. I've been running it on dev boxes for three weeks or so.

Jason Miller (1/13/2009)

---

I would think you could get a handle on the sizes simply by querying the backup history tables.

For me, much of this is simply ease of administration. ...

I think CALs may be more difficult to manage when you have A LOT of SQL Servers and different users in your environment. Also, you need...

Cat (1/2/2008)

---

I just wished that there was only one license type. When you work for a large company and everyone is buying licenses, its hard to match up what...