which job fails, the backup log on the primary or the copy job on the secondary?

what account does SQLAgent on the secondary run under?

Rajat Jaiswal-337252 (8/11/2010)

---

I have also implemented Log shipping according to your document on 110 GB database. Now i am worried when primary server fail we will restore Secondary server with...

simplest way is by the timestamp on the backup files. Remove any log backups from the log backup directories on primary and secondary which are previous to the full backup...

there is no SQL command to prove a backup is complete, but why should it not be?

you can use restore verifyonly to prove it is a valid backup set.

the backup...

ok, thanks for replying. We also see these on a new super-spec server at times of load.

if you still have all the backups you could do the full restore again and use 'norecovery' option, then you could restore the tran logs, only specifying recovery on the...

Fraggle, did you resolve this?

Its not necessary to drop the old database or create an empty database to restore into. the restore process itself creates the database.

'with replace' will overwrite the existing database of...

thats good, then i would get rid of that command and kick your vendor 🙂

it certainly does and it certainly will. Its a last resort...

just to get my point back I would have to agree some of the index types MS list are really properties of an index, but hey-ho, I guess you can...

were you able to give them higher level of permissions (ie dbo) and see what happens?

no.

the favorite method is for the application to point to a DNS alias rather than a hardcoded server name. Then on failover the DNS Alias is repointed to the new...

The error is not 'Select permission denied on object DB..Table'? (two dots) Is the owner of the table specified correctly, i.e is it dbo?

to confirm it is a SQL permissions...

please post the exact error message received