Post reply

Rename Database and Other Querys are Running on the same DB

  • January 3, 2013 at 2:21 am

    #393865

    Hi All,

    I have List of Jobs scheduled on my server, I have scenario like this

    Job1:

    1. Copy bkp file

    2. Restore DB as Name like (TEST_NEW) as new DB

    3. Rename already existing TEST Database name as TEST_1 Database and Rename the TEST_NEW to TEST

    While doing the 3rd step, In the other job the TEST DB is used by some procedure that job got failed.

    By change the job running times we can overcome this issue but there is no chance to change the time.

    so I need a solution to overcome this issue.

    Thank's in advace

  • January 3, 2013 at 2:30 am

    #1573215

    venkatesh.b 88975 (1/3/2013)

    While doing the 3rd step, In the other job the TEST DB is used by some procedure that job got failed.By change the job running times we can overcome this issue but there is no chance to change the time.

    Is the time of both the job conflicting then you can use "waitfor delay" for delay the dependent job but what i think here is , at any point of time there will be one available 'TEST'database so it make me confuse

    can you post the job error ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply