Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dophuong_cs
Starting Member
15 Posts |
 Posted - 2014-08-21 : 22:31:00
|
| 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
737 Posts |
Posted - 2014-08-22 : 02:30:32
|
| 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 ideasJaveed Ahmed |
 |
|
|
dophuong_cs
Starting Member
15 Posts |
Posted - 2014-08-22 : 04:34:43
|
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 ideasJaveed 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 destinationPhuong |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
|
|
|
|
|
Backup database include Agent Jobs in sql 2012