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 |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2007-08-13 : 09:49:19
|
| Hi AllI need some advice and I think I have a possible solution, I just need some approval that it is the right thing to do!I have 73 Databases which I look after and they are all SQL 2000 and SQL 2005 DBs and backuing up these DBs is becoming an Administration nightmare. So what I was planning is to recreate all the backup jobs jobs on a SQL 2005 Server and monitor them from there!Is this a good idea or should I think of something else?Thanks In Advance!Gopher |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-13 : 09:55:06
|
| what were you doing before.Ashley Rhodes |
 |
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2007-08-13 : 09:57:16
|
| Basicaly just running the jobs locally on each server!An as each SQL has 75 DB backups and each server has a System DB backup - thers is about 130 Jobs to Monitor - It can take a while to check! |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-13 : 11:36:52
|
| since you have so many DB's have you thought of using thrid party tools, which can help you substantially.Let me know if its possible for you to purchase any, and i would be able to recommend some.These tools can make backups faster and make monitoring easier.Ashley Rhodes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 15:39:30
|
| Take look at MSX server in books online. |
|
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2007-08-14 : 03:37:15
|
| Ashley, I try and stay away from 3rd Party tools as they seem to be too expensive for what they do.MSX Sever seems closer to what I am looking for - I have lloked on books online but cant find any info on how to set it up. If you have any information that would be great!ThanksBoth of you for your replies!Gopher |
|
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2007-08-14 : 03:42:41
|
| Oh, Have found a link for Master Server Setup |
|
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2007-08-16 : 10:51:04
|
| how many databases are installed per server... i assume that it's grouped right??? do you think it's better to create a backup job per server so you won't have to monitor 73 backups jobs??? so basically, it's 1 job per server...SlayerS_`BoxeR` + [ReD]NaDa |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-16 : 22:23:55
|
| Different db may have different backup requirement, single job doesn't always work. |
|
|
|
|
|
|
DB Backup Consolidation