July 5, 2012 at 3:20 am
Hi , I am fairly new to sql server so any help would be greatly appreciated, I set-up log shipping from the primary database to the secondary. Everything looks fine, I created the two shares, granted the permissions, enabled log shipping on the primary database etc.
The transaction logs are being copied over fine to the share in the secondary and are visible. The problem is that the restore job succeeds the first time but applies no log file. The subsequent restore jobs is now showing up as failing in job history. The error is
P.s I substituted the real database name below
Message
2012-07-05 10:00:02.84*** Error: An error occurred checking the log backup file ' \\DUBMRS01\LSCopy\DATABASE_NAME_20120705083002.trn' for secondary database 'DATABASE_NAME'.(Microsoft.SqlServer.Management.LogShipping) ***
2012-07-05 10:00:02.84*** Error: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ \\DUBMRS01\LSCopy\DATABASE_NAME_20120705083002.trn'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
RESTORE HEADERONLY is terminating abnormally.(.Net SqlClient Data Provider) ***
2012-07-05 10:00:02.85Deleting old log backup files. Primary Database: 'DATABASE_NAME'
July 5, 2012 at 4:43 am
When you initially set up log shipping, did you take a full backup of the primary db and restore it to the secondary server before kicking in the shipping?
Are there any backup jobs on the primary server which may be messing with your transaction log backup chain history?
Is there any possibility that your primary server is a higher version / edition of SQL than your secondary server?
July 5, 2012 at 4:51 am
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ \\DUBMRS01\LSCopy\DATABASE_NAME_20120705083002.trn
Is this path it is trying to get the trans log backup from valid? It does not seem correct. Specifically where the server name is listed with a space and then two back slashes does not seem valid in a local path. If you open up an Explorer window on the secondary server can you navigate to the directory that is listed in the LSRestore job? Is the file there?
Joie Andrew
"Since 1982"
July 5, 2012 at 5:06 am
I looked at the steps in the restore job and it runs the command "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Restore 6C118D90-1559-4597-A8B4-BC1076ADA50E -server DUBMRS01
This is not the location I set-up as a share. Does this command run the log shipping process to execute which in turn directs itself to my share which is \\DUBMRS01\LSCopy
July 5, 2012 at 5:13 am
Can you paste the actual command into the thread? Feel free to change the sensitive information. We just need to see the entire command.
July 5, 2012 at 6:02 am
Hi Brandie, this is the entire command from the step within the actual scheduled LSRestore job on the secondary server. "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Restore 6C118D90-1559-4597-A8B4-BC1076ADA50E -server DUBMRS01
thanks alot
July 5, 2012 at 6:05 am
Please execute the following and return the results
against primary
exec sp_help_log_shipping_primary_database @database = 'yourdb'
against secondary
exec sp_help_log_shipping_secondary_database @secondary_database = 'yourdb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2012 at 7:53 am
primary_idprimary_databasebackup_directorybackup_sharebackup_retention_periodbackup_compressionbackup_job_idmonitor_servermonitor_server_security_modebackup_thresholdthreshold_alertthreshold_alert_enabledlast_backup_filelast_backup_datelast_backup_date_utchistory_retention_period
C2BEA283-0F09-49C6-9B2A-1CEE4C626182mydatabase\\rentway1\BACKUP_RENTWAY\\rentway1\BACKUP_RENTWAY4320235497C9B-6E5D-4A1F-A0C2-3FB166FF7FD5NULLNULL60144201\\rentway1\BACKUP_RENTWAY\mydatabase_20120705133000.trn2012-07-05 14:30:05.3472012-07-05 13:30:05.3435760
cheers
July 5, 2012 at 8:35 am
If you access SQL on the primary and secondary instances through SSMS and right-click on each instance and go to Reports > Standard Reports > Transaction Log Shipping Status, what do the reports show? Can you paste screenshots of them here (blurring/cutting out specific server/database names if you need to of course)?
Joie Andrew
"Since 1982"
July 5, 2012 at 8:38 am
thomasrichardson2000 (7/5/2012)
primary_idprimary_databasebackup_directorybackup_sharebackup_retention_periodbackup_compressionbackup_job_idmonitor_servermonitor_server_security_modebackup_thresholdthreshold_alertthreshold_alert_enabledlast_backup_filelast_backup_datelast_backup_date_utchistory_retention_period
C2BEA283-0F09-49C6-9B2A-1CEE4C626182mydatabase\\rentway1\BACKUP_RENTWAY\\rentway1\BACKUP_RENTWAY4320235497C9B-6E5D-4A1F-A0C2-3FB166FF7FD5NULLNULL60144201\\rentway1\BACKUP_RENTWAY\mydatabase_20120705133000.trn2012-07-05 14:30:05.3472012-07-05 13:30:05.3435760
cheers
Where's the second one? For the Secondary Database?
July 5, 2012 at 8:53 am
sorry there is no second one ,it returns no rows
July 5, 2012 at 9:10 am
That tells me Log Shipping isn't set up (or isn't set up properly) on your secondary server.
You'll need to start over from scratch.
July 5, 2012 at 9:44 am
thomasrichardson2000 (7/5/2012)
sorry there is no second one ,it returns no rows
Check to make sure you supplied the correct database name.
If still no rows then as Brandie says, the LS secondary is not configured on that instance, check you have the right instance too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2018 at 7:23 am
This was removed by the editor as SPAM
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply