Rename Database and Other Querys are Running on the same DB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Rename Database and Other Querys are Running...

Rename Database and Other Querys are Running on the same DB

Rate Topic

Display Mode

Topic Options

Author

Message

Tony1234

Posted Thursday, January 03, 2013 2:21 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 14, Visits: 98

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

Post #1402243

Bhuvnesh

Posted Thursday, January 03, 2013 2:30 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1402248

« Prev Topic | Next Topic »

Permissions