How can we help you today? How can we help you today?
RudiM
Activity overview Badges (0) Posts (2) Comments (7)

Comments

Sort by recent activity
Ok got it figured out. Here is the out put C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC -SQL "RESTORE SQBHEADERO NLY FROM DISK = 'F:\Cellularlogs\LOG__Cellular_20081004_023000.sqb' " Red Gate SQL Backup 5.2.0.2825, (c) Red Gate Software Ltd 2004 - 2007 Serial number: 010-001-073940-7652 Reading SQB file header of "F:\Cellularlogs\LOG__Cellular_20081004_023000.sqb" Backup group ID : 0 File number : 0 of 0 Backup type : 2 (Transaction log) Native backup size : 33.250 MB Backup start : 04 October 2008 02:30:48 Backup end : 04 October 2008 02:30:49 Server name : CAPS Database name : Cellular First LSN : Last LSN : Checkpoint LSN : Database backup LSN : C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC -SQL "RESTORE SQBHEADERO NLY FROM DISK = 'F:\CellularLogs\LOG__Cellular_20081004_024000.sqb' " Red Gate SQL Backup 5.2.0.2825, (c) Red Gate Software Ltd 2004 - 2007 Serial number: 010-001-073940-7652 Reading SQB file header of "F:\CellularLogs\LOG__Cellular_20081004_024000.sqb" Backup group ID : 0 File number : 0 of 0 Backup type : 2 (Transaction log) Native backup size : 31.000 MB Backup start : 04 October 2008 02:40:43 Backup end : 04 October 2008 02:40:44 Server name : CAPS Database name : Cellular First LSN : Last LSN : Checkpoint LSN : Database backup LSN : / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Media Set Problems
Ok got it figured out. Here is the out put C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC -SQL "RESTORE SQBHEADERO NLY FROM DISK = 'F:\Cellularlogs\LOG__Cellular_20081004_023000.sqb' " Red...
0 votes
Thanks Peter Good time to upgrade then. Thanks foe all the help regards Rudi / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Media Set Problems
Thanks Peter Good time to upgrade then. Thanks foe all the help regards Rudi
0 votes
I tried running the commond from CMD but get the following C:\>SQLBackupC -SQL "RESTORE SQBHEADERONLY FROM DISK = 'F:\Cellularlogs\LOG__Cel lular_20081004_023000.sqb' " 'SQLBackupC' is not recognized as an internal or external command, operable program or batch file. Sorry I am not that clued up when it comes to SQL.... / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Media Set Problems
I tried running the commond from CMD but get the following C:\>SQLBackupC -SQL "RESTORE SQBHEADERONLY FROM DISK = 'F:\Cellularlogs\LOG__Cel lular_20081004_023000.sqb' " 'SQLBackupC' is not recogniz...
0 votes
Hi No from the primary server there is no error's raised, the backup was succesfull. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Media Set Problems
Hi No from the primary server there is no error's raised, the backup was succesfull.
0 votes
O wait... wrong date.. my bad. Yes there is. Warning 300: BackUp Failed. Retry attempt: 1 VDI error 1010: Failed to get configuration from server SQL Error 3013 and SQL error 3201 Thx Rudi / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Media Set Problems
O wait... wrong date.. my bad. Yes there is. Warning 300: BackUp Failed. Retry attempt: 1 VDI error 1010: Failed to get configuration from server SQL Error 3013 and SQL error 3201 Thx Rudi
0 votes
Hi Hope all is well. I read in one of the posts that SQL BackUp 5.3 sorts out a problem regarding to the LSN numbering. Will that sort out my problem? I am still having a lot of problems with my log restore. (SQL Error 4305) When the job runs on server B with the wild card for the log name DECLARE @exitcode int DECLARE @sqlerrorcode int exec master..sqlbackup N'-sql "RESTORE LOG [Cellular] FROM DISK = ''F:\CellularLogs\LOG__Cellular_*.sqb'' WITH STANDBY = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\UNDO_Cellular.DAT'', ERASEFILES = 7, FILEOPTIONS = 1, MOVETO = ''F:\CellularLogs\done\''"', @exitcode OUTPUT, @sqlerrorcode OUTPUT IF (@exitcode <>0) OR (@sqlerrorcode <> 0) BEGIN RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode) END the job wil fail with SQL error 4305 But if I run the same job in SQL Query and spesify the log name the restore job will succeed... Thx Rudi / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Error 4305
Hi Hope all is well. I read in one of the posts that SQL BackUp 5.3 sorts out a problem regarding to the LSN numbering. Will that sort out my problem? I am still having a lot of problems with my lo...
0 votes
Log on Server A (The Log Failed to Restore on Server B with the error code 4305) SQL Backup log file 5.2.0.2825 2008/02/10 14:40:00: Backing up Cellular (transaction log) to: 2008/02/10 14:40:00: [image] \CellularLogs\LOG__Cellular_20080210_144000.sqb 2008/02/10 14:40:00: BACKUP LOG [Cellular] TO DISK = 'D:\CellularLogs\LOG__Cellular_<DATETIME yyyymmdd_hhnnss>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 7, COPYTO = '\\192.168.110.48\CellularLogs', COMPRESSION = 1, THREADS = 1 2008/02/10 14:40:06: Backup data size : 73.500 MB 2008/02/10 14:40:06: Compressed data size: 21.210 MB 2008/02/10 14:40:06: Compression rate : 71.14% Processed 8698 pages for database 'Cellular', file 'Cellular_Log' on file 1. BACKUP LOG successfully processed 8698 pages in 4.351 seconds (16.375 MB/sec). 2008/02/10 14:40:07: Deleting old backup file: [image] \CellularLogs\LOG__Cellular_20080203_144000.sqb 2008/02/10 14:40:09: Copied [image] \CellularLogs\LOG__Cellular_20080210_144000.sqb to \\192.168.110.48\CellularLogs\LOG__Cellular_20080210_144000.sqb. 2008/02/10 14:40:09: SQL Backup process ended. This is the Latest Log On server A (The Log Failed to Restore on Server B with the error code 4305) SQL Backup log file 5.2.0.2825 2008/02/10 18:40:00: Backing up Cellular (transaction log) to: 2008/02/10 18:40:00: [image] \CellularLogs\LOG__Cellular_20080210_184000.sqb 2008/02/10 18:40:00: BACKUP LOG [Cellular] TO DISK = 'D:\CellularLogs\LOG__Cellular_<DATETIME yyyymmdd_hhnnss>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 7, COPYTO = '\\192.168.110.48\CellularLogs', COMPRESSION = 1, THREADS = 1 2008/02/10 18:40:31: 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.) 2008/02/10 18:40:41: SQL error 3013: BACKUP LOG is terminating abnormally. 2008/02/10 18:40:41: SQL error 3201: Cannot open backup device 'SQLBACKUP_E6A26A88-FFC3-4663-B1CC-858EA96F5A70'. Operating system error 0x80070002(The system cannot find the file specified.). 2008/02/10 18:40:41: 2008/02/10 18:40:41: Memory profile 2008/02/10 18:40:41: Type Maximum Minimum Average Blk count Total 2008/02/10 18:40:41: 2008/02/10 18:40:41: Commit 68050944 4096 1168870 1546 1807073280 2008/02/10 18:40:41: Reserve 2088960 4096 112132 311 34873344 2008/02/10 18:40:41: Free 156958720 4096 1725827 177 305471488 2008/02/10 18:40:41: Private 68050944 4096 1248368 1415 1766440960 2008/02/10 18:40:41: Mapped 1060864 4096 111323 56 6234112 2008/02/10 18:40:41: Image 24707072 4096 179459 386 69271552 2008/02/10 18:40:41: 2008/02/10 18:40:41: Warning 300: Backup failed. Retry attempt: 1 2008/02/10 18:40:43: BACKUP LOG [Cellular] TO DISK = 'D:\CellularLogs\LOG__Cellular_20080210_184000.sqb' WITH NAME = 'Database (Cellular), 2008/02/10 18:40:00', DESCRIPTION = 'Backup on 2008/02/10 18:40:00 Server: CAPS Database: Cellular', INIT, ERASEFILES = 7, COPYTO = '\\192.168.110.48\CellularLogs', COMPRESSION = 1, THREADS = 1 2008/02/10 18:40:49: Backup data size : 89.063 MB 2008/02/10 18:40:49: Compressed data size: 28.612 MB 2008/02/10 18:40:49: Compression rate : 67.87% Processed 11232 pages for database 'Cellular', file 'Cellular_Log' on file 1. BACKUP LOG successfully processed 11232 pages in 5.460 seconds (16.850 MB/sec). 2008/02/10 18:40:49: Deleting old backup file: [image] \CellularLogs\LOG__Cellular_20080203_183001.sqb 2008/02/10 18:40:49: Deleting old backup file: [image] \CellularLogs\LOG__Cellular_20080203_184000.sqb 2008/02/10 18:40:53: Copied [image] \CellularLogs\LOG__Cellular_20080210_184000.sqb to \\192.168.110.48\CellularLogs\LOG__Cellular_20080210_184000.sqb. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Error 4305
Log on Server A (The Log Failed to Restore on Server B with the error code 4305) SQL Backup log file 5.2.0.2825 2008/02/10 14:40:00: Backing up Cellular (transaction log) to: 2008/02/10 14:40:00: ...
0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2