Re: Error executing Backup
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/07/04
- Next message: Hari: "Re: copy a database from server to development"
- Previous message: ken: "copy a database from server to development"
- In reply to: CC&JM: "Error executing Backup"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Jun 2004 15:11:18 +0200
For RESTORE you cannot use db_backup operator if the database doesn't exist, as ... the database doesn't
exist! In this case, dbcreator server role should do.
Your problem is very likely that HP wrote their software so it requires this permissions. The place to start
is the documentation for the software. If there is no, ask the vendor of the software (HP).
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "CC&JM" <anonymous@discussions.microsoft.com> wrote in message news:1919d01c44c8f$47eb8c30$a501280a@phx.gbl... Hello, I've configure "HP Omniback" to perform backups on databases servers under the account "omni_acc", when i configured this account i assign this account the "System Administrators" Server Role because i canīt did backups if the account wasnīt assign to this role. Now i want to give to the omni_acc account other previleges since we have the "db_backupoperator" database role but... i cant do the backups if the user is only assign to this role. Can anybody explain to me this situation? Is not supposed that a user assign to the "db_backupoperator" database role perform backups and restores to databases? How can i give permissions to a user to make backups and restores of databases? Best regards
- Next message: Hari: "Re: copy a database from server to development"
- Previous message: ken: "copy a database from server to development"
- In reply to: CC&JM: "Error executing Backup"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
