Hi,

We have an application which requires anywhere between 10,000 to 500,000 new records to be uploaded into our database at anyone time. For each record we have to go through...

I haven't experiencince mirroring between 2005 and 2008 (just 2005 to 2005) however i did find the GUI pretty buggy and would recoomend doing it "manually" where possible.

You correct, i never realised...

Snapshots aren't standalone copies of the database, they appear much more complicated and still require the use of the original MDF file. For this reason they...

I haven't tryed the snaphost/restore method but i would imagin it is just a case of restoring the snapshot as you would a database backup

What is time consuming?

No it can't.

The mirrored database remains in a state of "restoring" until it is brought into service through either an automatic or a manual failover from the principle database. The...