SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Migrating SQL Job from 2000 to 2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 02/08/2010 :  07:58:55  Show Profile  Reply with Quote
Dear All,

I am having 100 of SQL jobs in sql server 2000 job instance.I need to migrate all these jobs to 2005 server instance.Please help me in this regard.

Also i need to make relationship between 2 jobs in one sql jobs(i mean controlling of 2 sql jobs in one sql jobs)
Pls help how to do it.
Thanks,
Ganagadhar

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 02/08/2010 :  08:55:18  Show Profile  Reply with Quote
script out from server and apply in 2005 server
http://msdn.microsoft.com/en-us/library/ms191450(SQL.90).aspx
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 02/08/2010 :  08:57:07  Show Profile  Reply with Quote
or use transfer jobs task

http://msdn.microsoft.com/en-us/library/ms137568.aspx
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 02/08/2010 :  10:31:08  Show Profile  Reply with Quote
Dear All,

Can't we do in this way.

Take a back up of MSDB database and restore it in new instance so all jobs get transferred to new instance.

I was trying this but i got this error
TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'DEV03\Standby'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000