What are the challenges you face when working across database platforms? Take the survey
Options

Restoring Logs from Multiple Databases - some fail

crss12crss12 Posts: 3
edited January 2, 2007 11:44PM in SQL Backup Previous Versions
Hello,

I am having a problem restoring transaction logs created from SQL Backup V3. The logs are generated from 130 plus databases and most restore without issue though several databases report the following:

C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC -E -SQ
L "RESTORE LOG FROM DISK = 'F:\LogShip\New\MJS_TENIX_db_(full)_200
6122918*.SQB' WITH STANDBY = 'F:\logship\processed\MJS_TENIX.ldt',PASSWORD='XXXX
', MOVETO = 'F:\LogShip\Processed'"

Red Gate SQL Backup 4.6.0.815, (c) Red Gate Software Ltd 2004 - 2006
Serial number: 010-003-049055-8288

Processing log group 67569949 ...
F:\LogShip\New\MJS_TENIX_db_(full)_200612291802.sqb
Restoring 'MJS_TENIX' (transaction logs) from:
F:\LogShip\New\MJS_TENIX_db_(full)_200612291802.sqb

VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)
SQL error 3013: RESTORE LOG is terminating abnormally.
SQL error 913: Could not find database ID 65535. Database may not be activated yet or may be in transition.

Memory profile
Type Maximum Minimum Average Blk count Total





Commit 769785856 4096 1337115 779 1041612800
Reserve 458489856 8192 6328057 125 791007232
Free 165801984 4096 1907867 165 314798080
Private 769785856 4096 4078965 441 1798823936
Mapped 1019904 4096 119714 44 5267456
Image 7569408 4096 68087 419 28528640

SQL Backup exit code: 1010
Last SQL error code: 913

Note if the logs are restored via the GUI they appear to be ok though will not restore using SQL or command line. The SQL option appears to hang without an error whilst the command line gives the error above.

Any ideas - this is becoming very frustrating.

Thanks.

Comments

Sign In or Register to comment.