Transfer SQL job to another machine

sql-server-2008-r2 sql-job
Mahdi jokar picture Mahdi jokar · Apr 5, 2012 · Viewed 11.8k times · Source

How can I transfer my SQL Agent job (maintenance plan) from my server to another server?

I use SQL Server 2008 R2. My job runs a T-SQL script.

Answer

BluesRockAddict picture BluesRockAddict · Apr 5, 2012

The following article explains how to to do it: Migrating a Maintenance Plan from One SQL Server to Another.

Note that they're using SQL Server 2000, but it should work for SQL Server 2008 R2 as well.

Related questions

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I've received "Server is unavailable" errors before, but am now seeing …

Read More
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More