| Author |
Topic |
|
hsonline
Starting Member
3 Posts |
 Posted - 2005-01-13 : 16:52:45
|
| I'm a network administrator of a small network, and I don't know anything about SQL code, and I'm running SQL2000.I went through the Maintenance Plan Wizard and managed to schedule a backup for my main database that I can't afford to lose. I scheduled it for 11:30 PM, when I knew all end users would be logged off.Previously, a consultant I had hired to assist me in updrading from Windows NT 4.0 to Windows Server 2003 scheduled some database backups for me to occur at 3:00 PM each day. I don't need these backups to occur, but I don't want to contact this consultant for information because he might want to come on my location and charge me consulting fees. I don't mind paying for help, but for something this simple, I was hoping that I could do it myself.How do I go about modifying these backup schedules?Thanks,A SQL newbie... |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-13 : 17:07:35
|
| Read Books OnlineIt's free, but requires an investment in time.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
bfos7215
Starting Member
9 Posts |
Posted - 2005-01-13 : 17:19:25
|
| Books online, being the sql help file. Not anything you'd find on Amazon.com's hot list.Brian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-13 : 18:04:43
|
quote:
Originally posted by hsonline
How do I go about modifying these backup schedules?
It depends where he scheduled them from. Hopefully from within the SQL Agent. Open up Enterprise Manager, go to Management, SQL Agent, jobs. Find the job that he created. Now it might be linked to a maintenance plan. If it is, then just delete that maintenance plan. If it isn't, then you should be fine to delete the job.Tara |
|
|
|
hsonline
Starting Member
3 Posts |
Posted - 2005-01-14 : 10:02:08
|
 Wow, you guys are great! Thanks for the help, and the quick response. I knew it was an easy fix, I just didn't know where to find it.Derrick, I'm looking forward to spending some time on "Books Online". Thats' a great tip.Tduggan, your instructions were perfect. I found the two backup jobs under Management, SQL Agent, Jobs. In opening them up, I see where his is scheduled for 15:00, which is the one that I want to delete, and I'll leave mine alone.Quick couple of questions: I also noticed that there's an entry for "Optimizations Job for..." which refers to his backup job. There's not an "Optimizations Job..." entry for my backup job that I want to keep.Question #1) Can I delete his "Optimizations Job..." along with his back up (actually, I'm sure I need to, if I delete his backup entry), andQuestion #2) Do I need to create an "Optimizations Job..." for my backup entry? It already looks like it's working fine. If I need to create an "Opt" job, how do I do it?Thanks again, you guys are great!hsonline |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-14 : 12:09:37
|
| You can create your own Optimizations job. You'll also want to create an integrity checks job. Both of these can be found in the maintenance plans. Just make sure not to select the option in the integrity checks that fixes problems. Any problems found by an integrity check should be done by a person and not automatically by a computer without anyone's knowledge.Tara |
|
|
|
hsonline
Starting Member
3 Posts |
Posted - 2005-01-14 : 12:49:23
|
| Thanks Tara. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-14 : 13:32:01
|
| On the "Database Integrity Check" page do NOT use the "Attempt to repair minor problems"SQL attempts to set the database to Single User mode when this is choosen, and if the lock cannot be obtained then SQL aborts the job - either no backup, or the step for deleting "stale" files is not run, resulting in no purging of old files and eventually Disk Full!If you are using the Wizzard AVOID setting databases to ReadOnly, OffLine and similar - they all throw the wizzard-created-tasks and either prevent backups being made :-( or cause side-effects of varying severity.Kristen |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-01-16 : 14:49:08
|
| >>>Not anything you'd find on Amazon.com's hot list.<<<You don't find "Learn SQL in Ten Minutes" to be an essential resource??? ;-)HTH=================================================================Scriptures, n. The sacred books of our holy religion, as distinguished from the false and profane writings on which all other faiths are based.-Ambrose Bierce, writer (1842-1914) [The Devil's Dictionary] |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-16 : 19:18:26
|
Why wait 10 minutes?"Instant SQL Programming" by Joe CelkoHowever, the Amazon site says "This title usually ships within 1 to 2 months"  Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-16 : 19:46:03
|
| For learning SQL Server??? Are you out of your mind? lolIf you want to learn SQL Server pick up a couple good books from Ken Henderson and Kalen Delaney. If you want to learn Transact-SQL, then pick up "Teach Yourself Transact-SQL in 24 Hours" by Sam's Publishing. Celco is a theory guy. Some of his stuff is really good, but I wouldn't throw a new guy right into that.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-16 : 19:55:21
|
| I spent two years in Japan. I worked hard to learn the language.When I left there was a book on sale at the airport in the Departures bookshop : "Instant Japanese"It left me wondering why they hadn't sold it in the Arrivals area :-(Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-16 : 19:57:23
|
| Where did you live in Japan? My brother was stationed in Yakota. I spent about 5 weeks in Tokyo and touring Japan a couple years ago.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
Modify Database Backups