I do not believe the is an optimum. It really matters is how quickly your database is growing. As an example, if you database is growing at 10MB...

Do you always have to do all 4 updates, or are you only doing 1 and the other 3 get ignored?

There isn't that I am aware of because in good modeling, you are not suppose to have a many-to-many relationship. You should put an associate table between them.

Hope that...

Is it possible to view the code you are using?

If the specific date that you are restoring the DB2 is constant (say the last day of the month), you can setup a Job that will automatically retore the DB1.bak...

Well someone else may have a solid yes/no answer for you. I don't honest know.

However, If I were in your shoes, I would be testing both out...

The page you are requesting should be between those two pages. I do not know why it isn't. However, with that not working, my next best suggestion would...

1) Yes, the #temp table should be unique to every stored procedure that opens it. Of course you want to make sure you drop the table at the end...

That is how you open the export wizard. I was wondering what you saw when you opened the wizard? If you have never opened it before, you will...

What do you see when you click on export tasks?

I just assumed that the database held the location of all the food stores, medical supplies, porn, etc.

The 2nd menu item that comes up is called "Choose a Destination". The very first drop down menu is for destination. Select Microsoft Excel.

At what step during the setup of the database mirroring do you recieve the issue?

Do you get anything when you run the following command or do you get another error?

restore headeronly from disk='c:\demo.bak'

Try putting the statement in the WHERE part.

where CustID not like '%-%'