Error 890-SQL Error 15157 Problem

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Error 890-SQL Error 15157 Problem

Postby katghoti » Mon Oct 22, 2012 7:09 pm

I am trying to set up log shipping between two servers. I select the source and destination, and create a new database to restore to option. I set the compression, network share, test the share, set the restore to read only, leave the schedule as is accepting the defaults. When I get to the Finish steps on the wizard, it will backup the database, copy the backup to the share, but when it gets to restoring the database on the server I get:

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:
\\\\sogd0016\\Sqllogfiles\\SEED_TubeData_20121022120758.sqb
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
-----------------------------

Operation pending.


Create restore job - Pending
----------------------------

Operation pending.


Refresh server information - Pending
------------------------------------

Operation 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.

Thanks.

John
katghoti
 
Posts: 2
Joined: Mon Oct 22, 2012 7:02 pm

Postby petey » Tue Oct 23, 2012 2:37 am

Please see this link for a couple of suggestions (running as LocalSystem, or using the SkipChecks registry fix) on how to resolve this issue.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Still no luck

Postby katghoti » Tue Oct 23, 2012 3:26 pm

I entered in the Registry setting and it was able to get past the check, but now I get the following ERROR:

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_20121023082354.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 1 pages for database 'TubeData', file 'LinerData_log' on file 1.
BACKUP DATABASE successfully processed 329 pages in 0.154 seconds (16.690 MB/sec).
SQL Backup process ended.



Restoring database to destination server - Failed
-------------------------------------------------

This operation failed with errors.

Restoring TubeData (database) on SOGD0016 instance from:
\\\\sogd0016\\sqllogfiles\\SEED_TubeData_20121023082354.sqb
VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are
blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\[InstanceName]
Also check that the database is not currently in use.
SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1 REQUESTID
----- ------------------------------ -------------------------------------------------------- -------- ----- ------ ----------- ------- ------ -------------- ------------------ ------ ---------
59 RUNNABLE NT AUTHORITY\\NETWORK SERVICE SOGD0016 . master SELECT INTO 47 17 10/23 08:23:58 SQBCoreService.exe 59 0
SQL error 5069: ALTER DATABASE statement failed.
SQL error 5011: User does not have permission to alter database 'TubeData', the database does not exist, or the database is not in a state that allows access checks.
Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'.
SQL Backup exit code: 1010
SQL error code: 5011
katghoti
 
Posts: 2
Joined: Mon Oct 22, 2012 7:02 pm

Postby petey » Tue Oct 23, 2012 4:28 pm

Does the SQL Backup service startup account on the destination server have the SQL Server sysadmin server role assigned to it?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests