Red Gate forums :: View topic - Error 890-SQL Error 15157 Problem
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Error 890-SQL Error 15157 Problem

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
katghoti



Joined: 22 Oct 2012
Posts: 2

PostPosted: Mon Oct 22, 2012 7:09 pm    Post subject: Error 890-SQL Error 15157 Problem Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Tue Oct 23, 2012 2:37 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
katghoti



Joined: 22 Oct 2012
Posts: 2

PostPosted: Tue Oct 23, 2012 3:26 pm    Post subject: Still no luck Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2276

PostPosted: Tue Oct 23, 2012 4:28 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group