Ah yes, one...

Yes. And with that many Filegroups, you should check the file assignments & locations carefully when you do the restore.

Nope, sorry. No easier way than Enterprise Manager that I know of.

OK, how about using the Aliases in SQL Server Configuration Manager, under "SQL Native Client Configuration"? I am not sure if this works or not, but it's worth a...

Hmmm, well I may have misunderstood what you are trying to do. still trying to figure it out...

Try using Views for this instead.

For what it's worth, I tried it on SQL Server 2008 and saw no difference.

John Kandrovy (12/30/2008)

---

It was highly recommended from the vendor to reinstall from scratch because they have 10 different filegroups splitting all the tables and their 1000 indexes. So if we...

Heh. Yeah, that "Crushing Their Trachea...

The code example in my presentation demonstrates how to do this from a trigger.

Right, which leads to my strategy for dealing with block-headed vendors like this:

Question 1: What is your supported strategy for Disaster Recovery, that we should be implementing?

...

Also, see my Code Camp presentation "The Top 10 Reasons You aren't Already Using Service Broker" and associated code here: http://www.movingsql.com/dnn/Portals/4/Materials.zip

Create an SB queue (and service, message_type and contract to go along with it). Write a new procedure to send the changes (old & new values as XML) to...

Before I suggested any other way to do this I really would want to know why backup & restore is not sufficient.

We really cannot tell you what else...

The focus in recent years has been on Partitioned tables instead of Partitioned Views, so I suspect that there jst are not that many people using them and even fewer...