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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-07-16 : 04:02:13
|
| Transaction log backupjob for one db failed with error message as 7/16/2010 3:20:04 AM: Error 880: BACKUP DATABASE permission denied in database: (one_db)7/16/2010 3:20:04 AM: SQL error 911: Could not locate entry in sysdatabases for database 'one_db. No entry found with that name. Make sure that the name is entered correctly. |
|
|
beniaminus
Starting Member
21 Posts |
Posted - 2010-07-16 : 04:54:30
|
| It would seem that the user you are using to backup the database hasn't got back permissions for that database.Ben :) |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-07-16 : 05:02:52
|
| how can i find the user,that has this permission? |
|
|
|
beniaminus
Starting Member
21 Posts |
Posted - 2010-07-16 : 05:45:39
|
| Well, I'm guessing that this was a scheduled backup executed by a maintenance plan. If that's correct then you need to find the SQL Server Agent Job that executes the maintenance plan. If you go to edit the job it should tell you who the owner is. The owner will be the user executing the backup.Hope this helps,Ben :) |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-07-16 : 05:47:50
|
| no,this was redgate backup |
|
|
|
beniaminus
Starting Member
21 Posts |
Posted - 2010-07-16 : 06:08:30
|
| Ah. I've never used redgate before so I'm not entirely sure. It might be worth checking the Jobs in the SQL Server Agent. Unless Redgate have their own scheduler then they probably use the SQL Server Agent to schedule the backups.Ben :) |
|
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2010-07-16 : 10:30:18
|
| Red Gate's SQL Backup does not have its own scheduler. It uses the SQL Server Agent to schedule the backups. What Ben suggested still applies i.e. check the owner of the job that's performing the backup, and ensure that it has adequate rights to back up that database.Ray MondSQLBackupRestore.com - your quick guide to SQL Server backup and recovery issuesSQL Image Viewer - retrieve, view, convert and export images and binary data from SQL Server, Oracle, DB2, PostgreSQL, SQLite, and Firebird databases.SQL Data Sets - share and distribute SQL Server, Oracle and PostgreSQL data sets securely and easily |
|
|
|
|
|
|
|
|
transaction log failed