I only answered this so I could jump a month into the future and thus be on holiday.

you do not HAVE to check this box for log shipping to work.

as steve said, check with the users how 'real time' the data actually needs to be for reporting.

If real time go for replication, if not go for mirroring with snapshots....

check the logshipping tables in msdb, should give you more of a clue as to why it failed

good news for info fix is to register msxml 6 (what that?)

To register MSXML 6.0.

1. From the Start menu, click Run.

2. Enter the following command:. regsvr32 %windir%\system32\msxml6.dll.

3....

oops, its 2005 so it wouldn't return 2273 would it....:blush:

if its still 3054 hotfix definitely not applied.

From the errorlog it was unable to delete file because:

The process cannot access...

as long as you completely stop replication, you can safely backup db and restore it to a new location (on the same server) if that is what you want to...

I am told there is a third party prouct called textpad which can 'tail' the erorlog and Microsoft has a log file reader that's currently free. It's on their...

can I refer you to this article:

http://msdn.microsoft.com/en-us/library/ms151799.aspx

you don't need to detach\attach the database to shrink it.

you can backup and restore the database without affecting replication as long as replication is quiesced (stop all the replication agents)

with snapshots you are never going to get real time reporting, only NEAR real time. Recreating the snapshot every 5 mins seems excessively frequent.

Maintaining a snapshot is an overhead as...

then you would just have to do it manually by bringing secondary database online

either

restore database dbname with recovery

or

restore any outstanding tran logs and use the with recovery clause for...

top tip

transaction log restores will also cause this proccache clear down, so if you are log shipping this will happen at regular intervals.

If this irritates you as it doe me ,...

apply whichever rollup brings it to 3068 to the client?