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 |
jaybee
Yak Posting Veteran
72 Posts |
Posted - 2008-10-15 : 15:47:25
|
Hi all, been meaning to ask these questions for a long time but never had the time for a bunch of threads, so I thought I'd centralise. Sorry if any belong in another section: 1) Change Management - what size of change means completing a request form? 2) Backups - Would you recommend 3rd party software instead of native, and how do you minimise the time on VLDB's and the strain on the LAN? 3) Moving to another box - how do you migrate users? 4) Monitoring software - what do you use, and what jobs/perf counters do you monitor for? 5) Maintenance plans - what do you have in place, and what extra for VLDB? Thanks in advance all, Jaybee. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
jaybee
Yak Posting Veteran
72 Posts |
Posted - 2008-10-16 : 13:49:00
|
Cheers Tara, appreciate the tips.In terms of CM...as far as I'm concerned, something as trivial as flushing the log of course doesn't matter, but the line I draw just after, say, dropping a login by request of HR. As long as I get a mail from them I'll do it, but I want the docu retrospectively. Anything more serious - say dropping a user DB - I'll want the docu in advance.Couple of questions...2) You mentioned you saved money with LS, I presume it compresses the data and decompresses at the target? What kind of ratios do you get?4) MOM ?? |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|