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 2012 Forums
 SQL Server Administration (2012)
 Backup database include Agent Jobs in sql 2012
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dophuong_cs
Starting Member

Vietnam
10 Posts

Posted - 08/21/2014 :  22:31:00  Show Profile  Reply with Quote
Hi all,
I face 1 problem with backup in sql database server.
When i backup full database and after that restore into other database sql server 2012 Standard Edition 64 bit, but after finished restore successful i check again with Sql Server Agent Jobs don't have.

Please support me, how to backup database include Sql server Agent jobs.

Phuong

ahmeds08
Aged Yak Warrior

India
666 Posts

Posted - 08/22/2014 :  02:30:32  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
jobs are not part of a database backup.
you can script them out from the source server and execute the scripts on your destination.
This is one of the method, someone here might give you other ideas

Javeed Ahmed
Go to Top of Page

dophuong_cs
Starting Member

Vietnam
10 Posts

Posted - 08/22/2014 :  04:34:43  Show Profile  Reply with Quote
quote:
Originally posted by ahmeds08

jobs are not part of a database backup.
you can script them out from the source server and execute the scripts on your destination.
This is one of the method, someone here might give you other ideas

Javeed Ahmed


Hi ahmeds08,
Thank you for your support and answer.
My source database contain email configure.
How to bring all component already configure from sql database source to sql database destination

Phuong
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
666 Posts

Posted - 08/22/2014 :  06:03:26  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
see if this helps

http://www.sqlservercentral.com/Forums/Topic982618-391-1.aspx

Javeed Ahmed
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.08 seconds. Powered By: Snitz Forums 2000