Error 890-SQL Error 15157 Problem
Setting up log shipping - Failed
Backing up source database - Successful
This operation completed successfully.
Backing up TubeData (full database) on SOGDMFG20 instance to:
C:\Program Files\Microsoft SQL Server\MSSQL10.SOGDMFG20\MSSQL\Backup\SEED_TubeData_20121022120758.sqb
Database size : 13.938 MB
Compressed data size: 447.000 KB
Compression rate : 96.87%
Processed 328 pages for database 'TubeData', file 'LinerData' on file 1.
Processed 2 pages for database 'TubeData', file 'LinerData_log' on file 1.
BACKUP DATABASE successfully processed 330 pages in 0.168 seconds (15.314 MB/sec).
SQL Backup process ended.
Restoring database to destination server - Failed
This operation failed with errors.
Restoring TubeData (database) on SOGD0016 instance from:
Error 890: RESTORE DATABASE permission denied for database: (TubeData)
SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'W-INTRA\wrightjw' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or
you do not have permission.
SQL Backup exit code: 890
SQL error code: 15157
Creating backup job - Pending
Create restore job - Pending
Refresh server information - Pending
This user is in the administration group and is also in the SQL server admin group as well. (Server Role sysadmin). What am I missing here?
I am running Windows 2008 32 bit and SQL Server 2008 R2.