Very nice step wise article.

Thanks for sharing Praveen!

Thanks for the article!

Just a thought...steps 1-7 can be done using setting up log shipping and the rest can be done using step 8 onwards when moving on to the...

we still have 1000 yrs to go...:)

Found the answer after digging a bit in BOL.

There is a table named sysschedules which can be used and the relation between sysjobs, sysjobschedules and sysschedules is

sysjobs.job_id = sysjobschedules.job_id

and

sysschedules.schedule_id...

Found the answer after digging a bit in BOL.

There is a table named sysschedules which can be used and the relation between sysjobs, sysjobschedules and sysschedules is

sysjobs.job_id = sysjobschedules.job_id

and

sysschedules.schedule_id...

Hi,

I was installing SQL 2005 on a machine which already had SQL 2000 installed on it. The setup failed for some reason and I uninstalled 2005 including the Backward Compatibility...