Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message on backup

Status
Not open for further replies.

Delphard

Programmer
Jul 22, 2004
144
RS
User is member of backupoperators group.
When try backup with verify option checked, this error message occurs:
'The backup verify could not take place.... CREATE DATABASE permission denied in database 'master'.'
 
It might require access to some tables from master db during verification, so please try to grant read access to Master db and try.
Good luck

Dr.Sql
Good Luck.
 
For the verify option to work I believe the user also needs to be in the CREATE DATABAE group.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top