don't see a need for a trace in this instance. the sp_who2 identified the spid at the head of the blocking chain, a decision can be made from there as...

this sounds like a block rather than a deadlock, the two are not the same thing.

In this circumstance I would have killed the shrink job.

It is good practice to turn...

no.

don't ask why not. 🙂

you will have freed up space within the database file so what you have done has helped and bought you time. As the previous poster said deleting data does not...

make it easy on yourself. Do the initial full backup and restore manually, then start the log shipping with an already initialised database.

make sure you do the restore with norecovery

Seth, I think we broke SSC yesterday. After your post no more could be added for a couple of hours at least!

It could be worth recreating their ODBC connection, I'll...

not sure thats closely enough related Seth. This is SQL 2000 throughout and communication is not via a linked server.

cheers for the reply seth.

there is no error 107. there are error 208's though.

this practice is in 'how to do a security audit 101' so if you ever have the auditors in you will be asked to do this.

Not a bad thing in...

select last_restored_file from msdb.dbo.log_shipping_monitor_secondary where secondary_database = 'yourdb'

If I remember correctly if you run dbcc outputbuffer on the spid running the restore it tells you how far it has got.

dbcc outputbuffer(spid)

I think we need to know what you were trying to do when you received this error

application won't be able to connect if databases are in recovery mode.

you still haven't posted the actual error you are getting.

chk2009 (11/20/2009)

---

george sibbald (11/20/2009)

---

you will be fine if you if you:

run sp_help_revlogin against primary server and save output to file

copy file to secondary and load into SSMS query window

edit to...

chk2009 (11/20/2009)

---

george sibbald (11/20/2009)

---

you will be fine if you if you:

run sp_help_revlogin against primary server and save output to file

copy file to secondary and load into SSMS query window

edit to...