Thanks Lowell. What did the provider and data_source say after the renaming?

Thank you

What originally updated sys.server entry with the provider and data_source info? Was it an ODBC entry? We just want to make it's put in after sp_addserver process.

Thanks in...

The current production machine named app01 will be taken off the network and shutdown. The new machine currently named app02 with an instance of app02 on it will be...

Agreed, hopefully it will never happen

Thanks,

I just want to make sure that we have a plan other than the mirror for the principle. We would view using the mirror as the absolute last resort...

Thanks Satish

I was referring to trans log backups and full backup of the principle after the mirror was established. I apologize fro not making that clear.

And by the way Perry there is no witness

Hi again Perry

I was just curious if any type of data was being passed to the mirror via a trn log backup or full db backup and how the mirror...

idex was dropped and recreated. checkdb returned zero errors

Thanks Perry

So that I am clear.

Our non mirror environment is a full backup at 1:00am with tran log backup every 15 mins from 6:00am thru to 11:00 pm.

When the mirror...

Thanks you very much for the help and it's exactly where I was pointing and you confirmed. I'll do early tomorrow morning and advise.

You and Perry have...

I ran DBCC CHECKDB('TWORKS') WITH data_purity, all_errormsgs, NO_INFOMSGS on 2008

The result:

Msg 8951, Level 16, State 1, Line 1

Table error: table 'AssignmentRoot' (ID 1286229770). Data row does not have a matching...

running now

We reviewed and added additional privileges.