I had this issue with my server too. This happens when your drive which holds the data is not started but SQL server starts and cannot locate these files. Make...

its not only confusing but it makes me at loss of words to explain this behaviour. I mean which process do I need to rollback to continue with the other...i...

yes it shows same SPID a bunch of times and then the message is SPID 50 blocking SPID 50 blocked by SPID 50..this is so strange..I dont know if there...

Corretion : Counters that tell about reads and not writes.

If possible check the code that is executed with this link..if not include counters that pertain to writes to that specific database. Make sure to add filters so as not...

Thats awesome many..thanks a lot

When I put forth the idea and the risk involved in doing this conversion to management, they said they were better off without doing it. The reason being the hundreds...

well the rowcount has worked like a charm. I shall try yhe wait for also. I am also referencing by the indexed column in the where clause now.

thanks a...

There are seven related tables that are dependent. I am supposed to delete the data starting with the table on the lowest level of the parent child hierarchy. There is...

@Jeffrey: I would want to delete a large amount of data as is required and that the table size decreases dramatically after the test delete. Now my obvious question is...

Sorry about not posting in detail. The export job was failing on account of seeing some alien char. It's a CHAR RERTURN...I got it now..appreciate all your replies guys..thanks!!!

Well if there are many a processes that are active on the DB then your process works fine. I wouldn't be searching for a number of transactions and kill them...thanks!!!

Go to Current Activity in the Management Folder.

Kill the process that is using this DB that you want to restore. Single User, will not help the cause. The error says...

Good question. But what ever space you provide to begin with at the end of the day you have to give tempdb the space it needs. I would begin with...

The TRUNCATE_ONLY clause of the DUMP statement removes the inactive part of the log without making a backup copy of it. I am not sure if LSN's change unless...