You sure its causing deadlock??

Thanks all for the response

Not replication and log shipping..

Month end task to sync databases on server2 with server1.

I am able to do via linked server by creating job that...

You should ask some windows admin..

I know its an old thread but i hope someone can throw some light..

I am getting the same error but my subscriber is an Oracle database.Does anyone come across such...

The waitresource in sysprocesses is shown as 5:1:5040288.

sqldba_icon (6/4/2011)

---

Few things to check:

i) run sp_who2 every 10 secs when the last step occurs and capture the data to see if any blocking

ii)are your indexes and statistics upto date?

iii)if...

The issue was due to server memory setting in which the min and max server memory were configured as 2000MB and SQL server was using this much memory was not...

Thanks a lot Gail.

Much appreciate the way you came with me in solving my issue. Once a again thanks a lot 🙂

Gail Thanks a lot in guiding me..

From mail communication i think they are doing full restore.

Now the DB is not in suspect .We made the DB available using dbcc...

Thanks Gail,

Our onsite team is doing the restore between i have a doubt,Is it a problem if any job try to access the table or that particular database while restoring?

According...

Thanks Gail.

I hope the answer for my question is that the log backup contains informationjs from that modified extents also where as in full recovery model everything will be...

We did dbcc checkdb with allo data loss and that repaired the db with loss of 2Lakh records.

Now the DB is in single user mode so cant check...

GilaMonster (4/10/2011)

---

Since it was suspect your only two options are:

1) CheckDB with REPAIR_ALLOW_DATA_LOSS. There's damage to the clustered index (just one page) and that's the only repair level allowed in...

Thanks John..

I tried but was not able to fetch what i required.There are roles which have select permission and the users might have added to those roles other than giving...