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 |
|
Dumps
Starting Member
10 Posts |
 Posted - 2010-03-23 : 11:57:37
|
| Hi,I've created a script that runs via a job to create and verify a database backup. When I run the job the database is backed up but the job fails on the verify step. The error is logged as:CREATE DATABASE permission denied in database 'master' [SQLSTATE 42000][Error 262] VERIFY DATABASE is terminating abnormally.I notice BOL states this permission is required but I'm sysadmin on the server. I'm confused why I can't get this to work and must be missing something obvious here.Any thoughts? |
|
|
Dumps
Starting Member
10 Posts |
Posted - 2010-03-23 : 12:32:00
|
| Rather stupidly I was not running this in msdb so all working now. |
 |
|
|
|
|
|
Restore verifyonly requires create database perm