Unfortunately I never got to the bottom of this problem, so I've changed my restore procedure to copy the files from the remote location to the server and restoring from...

Hi

the SQL server agent is using a domain account which has rights to the relevant network area I've confirmed access by mapping a drive from the server to this area...

I'm using a unc path.

but if I take the principal offline the mirror sits saying recovering... and I can't do anything with it can you give any advise how I get the database to...

Alex Webber (2/24/2011)

---

After you've got the mirror up and running it does say "(Principal, Synchronized)" next to the Principal and "(Mirror, Synchronized)" next to the Mirror? And you do have...

Thanks for all the help, glad I posted this now got some stuff to be getting on with, Think I'll try MAP 5.0 first as this seems like the simplest...

Thanks again Ashish, I think I understand what you mean.

If I write the results from SQLCMD -L to a text file then write a batch file to query the top...

Hi thanks for this, it has certainly cut...

You are a star that is exactly what I wanted and it's free thanks you very much 🙂