| Author |
Topic |
|
Naz
Starting Member
1 Post |
 Posted - 2004-08-18 : 11:34:55
|
| Hi, i have DBA access on Microsoft SQL Server, but i need to give another colleague the same access as me....how do i also give him/her DBA access?Any help will be much appreciated. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-18 : 12:10:44
|
| Why? Are they DBA's? How did you get DBA access if you don't know how to do this?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 12:49:02
|
| Oh geez. Recipe for disaster.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-18 : 13:57:03
|
| Easiest way would be to give Him/Her your UserID and password.Just back me up here folks, this isn't the wrong advice for this level is it??Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 14:03:05
|
The right advice is...Contact the real DBA and have him/her grant the access. Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-18 : 14:12:16
|
| "real DBA"You touting for work Tara??!!I don't know what the advice should be for a small shop, but I recognise the problem.Its gonna be "buy cheap, buy twice" in the long run though, that's for sure.Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 14:14:46
|
| For a small shop,Add the other DBAs Windows account to SQL Server. Then give that account sysadmin fixed server role. And don't forget to do regular backups! When non-DBAs have DBA access, things are going to accidentally happen, so make sure you can restore the databases.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-18 : 14:30:01
|
| I would add to that to use TRANSACTION backups, rather than just FULL BACKUPS. That gives you the additional ability to restore to a point in time.However, if you do transaction backups, say, hourly then you need to realise that after a disaster you may need to do another TRANSACTION BACKUP before you restore in order to be able to restore to a point-in-time DURING the hour before the disaster.Has Yukon got any improvements in the Backup Wizzard which actually make it something useful and reliable for the Small Shop?EDIT: Stuff in red added for clarityKristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 14:33:10
|
quote:
Originally posted by Kristen
that after a disaster you may need to do another BACKUP before you restore in order to be able to restore to a point-in-time DURING the hour before the disaster.
I'm confused by that statement. You just need any backup to do the restores. Then the chain of tlogs.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-18 : 14:47:25
|
| I was meaning:Full backup at, say, 2amHourly transaction logs at 3am, 4am, ... 10amAt 10:47 something daft happens, and you start restoring - you can restore to any point-in-time upto 10am.However, if [before restore] you did one final Transaction backup you could restore to any point-in-time up to 10:47Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 14:49:32
|
| Ah! I was thinking you were saying a full backup. Sorry for the misunderstanding.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-18 : 15:03:35
|
| Indeed it did read like that!, I've edited it to make it clearer.Kristen |
|
|
|
|
Giving others DBA Access