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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-04 : 08:54:07
|
| anil writes "I have a strange problem while taking backup to DAT drive(12/24 GB). Platorem is NT Server with SP5 and SQL Server 2000 standard edition ( no SP applied) As Administrator I am able to take tape backup of databases. I have added another user in group db_backupoperator. His security access is through Group membership(Domain\loginname). He is given Database Access through Database Access tab. His default database also set to a user database. GRANT bACKUP DATABASE access also given to him. He can take disk backup of master,msdb and user databses. But he cannot take Tape backup. He cannot access tape device through Enterprise Manager, that is the problem. In the list of devices only disk devices are listed for him. This problem is only in Enterprise manager. He has taken backup of master, msdb and user databases through Query analyser using BACKUP DATABASE command. What could be the problem with Enterprise Manager? Kindly help at the earliest. Thanks to all in advance" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-04 : 12:40:08
|
| I'd say it's probably because the user does not have exec permissions on master.dbo.xp_get_tape_devices which is what EM uses to enumerate tape devices. Giving exec on that may solve your problem.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
Backup problem with Enterprise manager