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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2004-06-01 : 16:49:24
|
| Besides Enterprise Mangager for SQL Server 2000 what other mgmt tools are there. I'm looking for something that simplify mgmt and to point of recovery. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-01 : 17:00:09
|
| Well, there's Query Analyzer and SQL Profiler that are installed when you install the SQL client tools. Are you looking for 3rd party tools? If so, I highly recommend SQL Compare by Red-Gate.Tara |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2004-06-01 : 18:07:19
|
| Looking for 3rd party tools. Especially for mgmt e.g. recovery and backup. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-01 : 18:28:50
|
| 3rd party tools for recovery and backup! So BACKUP/RESTORE T-SQL commands is not adequate?Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-01 : 18:46:25
|
| >> Looking for 3rd party tools. Especially for mgmt e.g. recovery and backup.This is probably the most important aspect of the system so you should make it as simple as possible i.e. don't involve applications that may introduce bugs and shield the staff from what is really happening.Stick to backup/restore commands as Tara says.And don't assume that just because a backup completes successfully that you have a restorable file. That applies to the backup command and even more so to any appplication that does it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-06-01 : 20:22:15
|
| A backup / backup scheme that is not tested, is not a backup.If you don't that that backup file and restore it someplace and check it out, how do you know if you can restore it when you REALLY need it??I'm with everyone here in saying that you should use EM or QA to handle your backups. If you have some sort of issue, you can call MS and they will resolve your problem no matter what. Can you say that about a $50 piece of 3rd party software?? Usually not.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-06-01 : 20:33:47
|
| I just got an email saying that quest has 2 free tools.... [url]www.quest.com[/url]DavidM"Always pre-heat the oven" |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-01 : 21:15:56
|
| They do, and their tools are great. Having said that, for backups and restores just stick to the basics. BACKUP/RESTORE. It's hard to beat them, especially for the price.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Other Management Tools