December 3, 2008 at 3:39 am
Hi,
I am trying to setup Log Shipping on SQL server 2005 with the secondary database initialized option. That is the third option in the Initialize Secondary Database Tab.
In this case, the backup job on the primary server is not being created.
Please suggest.
TIA
December 3, 2008 at 8:34 am
Are you setting up log shipping on the primary server or secondary server when you do this?
December 3, 2008 at 10:48 pm
I am trying to setup log shipping on primary server.
Actually the backup job was created on a second atempt and it started taking transaction log backups (.trn files) after I first initially copied a Full Backup of the primary Database to the folder where the Backup_Job is supposed to take transactional backups to. I took the backup manually using script.
Please explain this option of having the secondary database already initialized.
TIA
December 4, 2008 at 7:13 am
what that means is the wizard expects you to have already restored the databse on the secondary in norecovery mode.
---------------------------------------------------------------------
December 4, 2008 at 9:11 am
Exactly.
Can you please tell me the queries that I should use to verify that the Transaction Log of the recent changes has been applied to the Secondary Server.
That is to bring the Secondary Database online assuming the Backup Folder on the Primary Server is still available, and we have access to the .trn files.
Thanks.
December 4, 2008 at 9:34 am
skyw (12/4/2008)
Exactly.Can you please tell me the queries that I should use to verify that the Transaction Log of the recent changes has been applied to the Secondary Server.
check the history of the lsrestore job or check the SQL errorlog to see last tranlog applied
That is to bring the Secondary Database online assuming the Backup Folder on the Primary Server is still available, and we have access to the .trn files.
when all logs avaialble to you have been restored, run this command to bring database online
restore database dbname with recovery
Only do this if you are failing over though, once database bought online you cannot restore any more transaction log backups.
you may also need to synch your users at this point if they are orphaned (see sp_change_users_login)
Thanks.
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply