July 16, 2009 at 9:37 am
Need to teach those techs how to run with scripts (DMVs, sys., etc) rather than SSMS!
July 16, 2009 at 9:54 am
Steve Jones - Editor (7/16/2009)
Need to teach those techs how to run with scripts (DMVs, sys., etc) rather than SSMS!
Granted they can run a backup and/or restore via SQL... but as a practice GUI's are easier, and they make less mistakes that way than they do trying to get a RESTORE DATABASE or BACKUP DATABASE command correct.
I remember when one of them was timing out using View activity from SSMS, and I tried to explain sp_who2 to him. And the look of pure shock that I'd expect him to use a simple system stored procedure was priceless.
"But... but... that's SQL and that's your job!"
I do find at times that being the only DBA in a company with 700 employees and about 2 TB of total SQL databases (of about which we have close to 6000 databases on) spread out among 8 clusters and 10 stand alone instances in 1 local and 2 remote data centers which support about 50,000 customer users to be a bit of a challenge. 🙂
July 16, 2009 at 9:59 am
Interesting. I think that the GUI makes it fairly easy for someone to click too quickly, or the wrong place, and make a mistake. I've seen people, myself included, who might be more likely to make the mistake of selecting the backup from 2 days ago in the GUI rather than yesterday's.
Working from scripts, where you manually have to change parameters, means you tend to go slower, and pay a bit more attention. Plus you can see what you selected. Once you click "OK" in the GUI, there's not audit of what you ran.
I can appreciate the issues you face, but I think giving simple scripts and having someone then trained to make simple changes is a better approach.
July 16, 2009 at 12:32 pm
Don't have much to worry about there... our backups are shipped off of the server nightly, so when doing a restore, they have to be copied back to a staging location, which requires the user to copy the right backup(s) into place and then select them and restore them.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply