If you look at the restore job on the target server, how is it configured? Are there parameters that list both databases?

If so, you can potentially just setup your own...

If this is a SAN, try to be sure the LUNs are physically separate from the other disks. If it's DASD, I'd ask for a new controller as well, move...

Honestly I think you'll end up wasting tons of time moving this data. I only think that custom SSIS type scripts will work here, and since you are changing schema...

Kit G (8/3/2010)

---

Those who practice Islam need to answer that question to the satifaction of those who don't practice Islam (and the same goes for any other religion). Until...

Alvin Ramard (8/3/2010)

---

Roy Ernest (8/3/2010)

---

You should see the looks I get from the Security at all airport when I am flying... 🙂 They take my passport, and come back after...

Sorry, I found it yesterday and should have updated this thread. We're not sure what happened, but think it was a broken process that re-ran last night and fixed things.

Good reference, and I hadn't realized a clean shutdown is needed. That's good to know.

Jack Corbett (8/3/2010)

---

WayneS (8/3/2010)

---

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid point? Are the people...

Another example of an article that doesn't show America in its best light. There might be places where I think race should be taken into consideration, but this isn't one...

Are you using a local instance here? The server OS matters here. I don't believe this works on workstation OSes or pre-W2K3. It does work on my local Win 7...

Not sure. I've had a number of 1-2, 2-3, 3-3 days. I was at .400 a little over a month ago. Since then I'm sure I'm in the low .300s.

At...

Enterprise Manager would be too old. It uses an older client technology. SSMS should pop up a dialog.

The client receives a message, and then should display a dialog. It's possible...

How far north do you have to be?

Note that you being the only resource for a system, or one of a few, doesn't mean you can't do anything else. Even if someone wants you to be dedicated,...

There's a checkbox if you are on W2K3 and later

http://msdn.microsoft.com/en-us/library/ms161959.aspx