Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

maintenance jobs

We have transferred databases from a server to another. Logins, sql agent jobs have been transferred. Is it possible to transfer maintenance jobs? What is the best method to transfer maintenance jobs?
0
sqlserverdba
Asked:
sqlserverdba
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes.. You can do it..
And detailed explanation here;

http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html

Note: GUI approach would work if you have Integration Services installed..
Else you have to go the other way..
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now