@terry

If there are no errors, then stating that fact stops people who are offering Free assistance wasting time on asking "has anything changed?" or "what are in...

IMO a "woolly" response is needed when a question is asked with no "meat" in it.

Anyone with some knowledge of databases and...

Have you tried the MS article???

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

IMO it should be more that 10%, on a NTFS volumn the OS reserves 10% for the journal. Once data starts to eat into the 10% then you can get...

Try following the workarounds on the link below...

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

And this..

http://www.mssqltips.com/tip.asp?tip=1668

As a previous post stated... Google is you answers

Simply typing

http://msdn.microsoft.com/en-us/library/ms170246%28SQL.90%29.aspx

If you do a Trace on the report using profiler, check the connection settings.

When SQL caches queries is also uses the "SET" statements. One in particular that caused that same...

If you connect on the actual server using SSMS what is the response?

Have you checked that DNS on all DNS server are correct for all the IPs in the cluster?

Have you checked the logs on the both the Primary and the Mirror?

Are you using DOMAIN or local account?

Also it maybe worth going through the link below

http://msdn.microsoft.com/en-us/library/ms189127%28SQL.90%29.aspx

Try and install the Management Object from MS (XMO)

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

Grant,

In my example, no (as sql is just changes the pointers to the meta-data). But to answer with the original post in mind then yes you would need to setup...

You could try using the Switch command.

ALTER TABLE [dbo].tbl1 SWITCH to [dbo].tbl2

Quickest way without SSIS is to

SSMS | Click the "Jobs" node | Select requited job | Right Click | Script job As...

If these are related to a SSIS package you...

Your plan look ok to me..

I have have in the past where installing a SP or CU breaks P2P replication, but not in all cases.

One thing I would add is...

Perform your final translog backup (if possible)

Then manually copy the file over to the 2nd server.

Then connect to secondary server in and run RESTORE LOG using the WITH RECOVERY...