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 |
|
CanadaDBA
583 Posts |
 Posted - 2006-02-21 : 13:49:09
|
| Currently, Builtin\Administrators is being used for Veritas for backup purposes. For the security, I want to remove this ID from the SQL Server. Do I have to use another user ID with Administrative rights for this application? What is the best suggestion?Thanks,Canada DBA |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-21 : 13:54:44
|
| keep in mind that there are other side effects if you remove the BUILTIN/Administrators group. Search the the microsoft KB for articles about this. I seem to recall issues with Full text indexing and some issues with clustering if you do this.What veritas product are you talking about? netbackup? backup exec?Usually, you would want to create a service account for this product. Call it something like 'veritas' and then have the service run under that veritas account. You would then grant veritas the database access needed for it to work.That stuff should be detailed in their admin guide or online. good luck.-ec |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2006-02-22 : 12:30:52
|
| The product is: Veritas Backup Exec for Windows Servers version 9.1 I am going to check the net to find anything about the user rights for this service.Thanks EC!Canada DBA |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-22 : 12:41:29
|
| Never trusted the SQL Agent on Backup Exec since I found that it was the reason the performance on one of our servers was taking a massive hit everytime it started up.. Now wherever I go, I try to make sure DBA's back up to disk and then the backup software only backs up those files, won't let it near SQL if I can help it.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-22 : 13:52:03
|
quote:
The product is: Veritas Backup Exec for Windows Servers version 9.1
Why are you using Veritas to backup your databases?I never rely on a different group to perform database backups as that is the number one responsibility of the DBAs. Veritas should be used to sweep the files from disk to tape.Tara Kizeraka tduggan |
|
|
|
CanadaDBA
583 Posts |
Posted - 2006-02-22 : 15:06:34
|
| This is the way that Net Admin has setup. I have my own backups (.BAK) on the disk and they get their own. But they backup directly from SQL Server. I think all the disk is being backed up as well but not sure.Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-22 : 15:13:57
|
| As the DBA, you need to tell them not to backup the databases inside SQL Server. Remove their access so that they can't do it anymore. They should only be sweeping your .BAK files to tape using the Veritas software. Having duplicate full backups is wasting space not to mention the performance issue when they run.Tara Kizeraka tduggan |
|
|
|
|
|
|
User ID for Veritas