Been struggling with this for a couple of days. The post to add a generic user for access from SSRS solved the problem!. Wasn't an...

I was noticing the same thing, and what I discovered was that Primary was backing up and shipping to secondary just fine, and restores were being attempted. However, since...

Couple of points I noticed that I think would improve your solution.

1. The database table is not very normalized and included information not related to space, but related to...

Thanks David.

Unfortunately we're not quite sure what will happen once we drop mirroring with the "other" Principal, so we are going to try the backup/restore route.

This is definately a bug...

Francis,

I'm not sure your asking about sql2005 or sql2000, but in either case, These sites are very helpful when it comes to DTS. (2005 is supposed to be MUCH better).

Here's some thing that should work for you.. I've not tested this extensively for all types of constraints, but it works with basic Primary Keys, Foreign Keys and Standard Indexes.  ...