July 1, 2003 at 10:04 pm
Dear Friends
I have a strange problem while taking backup to DAT drive(12/24 GB). Platform 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
July 2, 2003 at 10:13 am
I don't think it's a problem with Enterprise Manager. I think the user doesn't have permission to access the tape device.
Also, PLEASE upgrade to Service Pack 3 immediately. You are vulnerable to the SLAMMER WORM until you do this.
-SQLBill
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply