so you are saying if I use dynamic ports then restarting the service will change the port?

😛

thats doesn't sound like much considering I assume you can restore both databases to get all your data back.

thanks Phil.

how can you do that when the mirror database cannot be read because it is non - recovery

toad for sql server has a log reader. (I haven't tried that part of it yet).

my boss is getting me to trial it presently.

You can download it at...

thanks Pam... I will read up on that - I really appreciate your help!

thanks Guys,

doesn't the principal use the trans log to send data to the mirror. If that is the case if I do a t-log backup and truncate the log...

thank you steve:D

yes that right david . I know about snapshots but I mentioned I was using 2005 standard not enterprise.

What are the system view that will help me look into...

so how do people go about assuring that the mirror is good in preparation for a disaster if you are unable to check the structure of the mirror...

BackupMedium::ReportIoError: write failure on backup device ',dbpath'. Operating system error 112(error not found).

It did this on most of my database. I have about 100 dbs all up. One database 6gb...

Considering I will need to install SP2 to install it - I think it would. Which are the component that are shared? - perhaps the current instance does not have...

Is there any case where you should not use WSUS to install a SQL update?

thanks Steve.. In case I was misunderstood I wasn't asking the question to catch you out - I wasn't sure if that security update was a different class of...

how come this security update is not in this list?

http://support.microsoft.com/kb/954606