restore to same server - blocking issue

• Paul Matthews-179427

  Grasshopper

  Points: 11

  More actions

  December 4, 2006 at 10:43 am

  #171489

  Hello All

  I've set up a job to backup our financial db and restore it to the same machine (different files & db name) for reporting. This was to avoid a blocking issue caused by the front end financial system.

  The thing is, the blocking is still there, even when you are reporting on the mirror database and the process is on the other db!

  Is this something to do with the objects having the same names/indexes in sysobjects? Any ideas on how to resolve it?

  Thanks!

  Paul

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 4, 2006 at 12:48 pm

  #675585

  Blocking is nothing to do with your restore db as different name pointed all reports to the new db...

  You need to figure it out what blocking what? For that you need to run the blocker script..

  Here is the article which provides the script and info..

  http://support.microsoft.com/?id=271509

  Read this article for troubleshooting perf issues...

  How to troubleshoot SQL Server performance issues

  http://support.microsoft.com/kb/298475

   

  MohammedU
  Microsoft SQL Server MVP