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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2007-03-30 : 16:00:36
|
| In SQL2K EM you can right click a DB, and backup. Finally there is a option to schedule, which will create a job. Is this option has been removed from SQL2K5?------------------------I think, therefore I am - Rene Descartes |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-31 : 11:35:52
|
| I think so...But you can script your backup and create a job manually...or create backup job trhough Maintenance Plan...MohammedU |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-04-01 : 00:23:46
|
| Thank you MohammedU!I will be doing that!------------------------I think, therefore I am - Rene Descartes |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
JimVWilliams
Starting Member
7 Posts |
Posted - 2007-04-02 : 18:24:37
|
| Hi Ravilobo,Nope, not removed, just darned difficult to find.Right click on database, Tasks, Backup...Set up job as usual, then click on 'Script' at the top, and select Script to Job.Then click on the Schedules page and set up your schedule as per SQL2000.Obvious, eh? Took me an age to work that one out.So much for Microsoft's usability 'experts'...Enjoy ;)Jim. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-02 : 19:14:32
|
using this method you can schedule pretty much anything in SSMS, even ridiculous things like creating a database.
www.elsasoft.org |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-04-02 : 19:43:47
|
quote:
Originally posted by JimVWilliams... and select Script to Job.
Thanks Jim! I would not have found out about it in my life time!------------------------I think, therefore I am - Rene Descartes |
|
|
|
JimVWilliams
Starting Member
7 Posts |
Posted - 2007-04-14 : 08:35:03
|
My pleasure ! :)quote:
Originally posted by ravilobo
quote:
Originally posted by JimVWilliams... and select Script to Job.
Thanks Jim! I would not have found out about it in my life time!------------------------I think, therefore I am - Rene Descartes
|
|
|
|
|
|
|
|
|
SQL2K5 backup