you're looking for an rss feed such as the one provided at

http://ansuz.sooke.bc.ca/rippy/exchange/

dump transaction has been deprecated in 2005 use backup log (apparently backup log with truncate_only has also been deprecated)-

but if the primary in the mirror has not synchronised with...

then new primary or the old primary ?

when you say - can't dump the log - why not ?

alter database x set restricted_user

should stop anyone who isn't dbo dbcreator or sysadmin getting in the database

in sql2005 you have to add a job to the maintenance plan for "delete maintenance plan files" - this can be performed before or after the backup itself (i recommend...

thats the problem in not using a witness.

Force service (with possible data loss) on the mirror server.

Forcing service is possible only if the principal server is down, the session is...

no - nothing for mirroring that i know of - but doubletake might have some compression.... not sure as have never used it - it's a file level sync tool...

ok - look at some other software then to help you.

try

imceda(now quest i think) litespeed to compress your t-log backups in log shipping

or maybe doubletake

maybe these will cope...

glad to be of service - done it myself before and couldn't figure out why users with usernames longer than 25 chars were failing to run certain procs!!!!

same problems with log shipping as with mirroring - they're effectively the same, so your re-index will do the same thing to your wan.

again - if you mirror over the...

do you have a trigger that writes the contents of this field to another location???

or perhaps a cascading update from a foreign key - they might be trying to write...

just remember that if you mirror you primary to your off site server then on any failure of yor primary then the off site will pick up the load rather...

how are you attempting to change it ? using enterprise manager or are you scripting the change?

create procedure myproc

as

SELECT DISTINCT O.ODID,R.RCID,R.RQTY,R.RDATE,NetQty FROM RECEIVE R ,ORDER12 O WHERE O.PARTID = (SELECT PARTID FROM PART WHERE [DESC]= '+y+') AND O.ODID = R.ODID AND R.NetQty >0

GO

(i'm...