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 |
|
pjanil1
Starting Member
10 Posts |
 Posted - 2003-07-01 : 07:16:31
|
| Dear Friends 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-01 : 12:36:28
|
| Can your account see the tape devices in Enterprise Manager? Why bother with Enterprise Manager in the first place since Query Analyzer is the better tool? In Enterprise Manager, can you specify the path to the tape without navigating to it?Tara |
 |
|
|
pjanil1
Starting Member
10 Posts |
Posted - 2003-07-01 : 23:48:22
|
| thanks for the reply. in Em I can see the tapedevice name coming by default for this particular user. but when he tries to take backup following message comes " You must select one or more destinations on which to backup"when he tries to add a tape device system says he does not have permission to add a device(in EM) why so? pl help |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-02 : 12:05:33
|
| db_backupoperator is not enough to create a device. He needs to be added to the disk administrators server role as well. To do that, go to the server in EM, go to Security, then to Logins. Double click on the user, then go to server roles. Check the box next to disk administrators. Then click OK. Then have him try again.Let me know if it works or doesn't work.Tara |
|
|
|
|
|
|
Backup - Tape device access problem