November 25, 2008 at 3:51 pm
Hi,
Iam trying to setup logshipping.
On primary server...Database->properties->Transaction Logshipping->enable it and click Backup settings.
In The Transaction log backup settings Iam trying to backup to local drive on the primary server as C:\backup.But the OK button in the wizard is not getting enabled? see the attached screen shot
So my question is Can we take the log backups to the local drive on primary server or not?
If yes how to do that?
Thanks
November 25, 2008 at 4:19 pm
On the primary server we have the following set up
A folder called c:\sql\shipping_out which is then shared as shipping_out.
Does SQLServer have access to your c:\Backup folder?
David
November 25, 2008 at 5:08 pm
thanks David,
Its working now. I have to bring the secondary database up, right now it is in restoring mode,every 15 min the log backups are restoring.
If 4:00pm lobg backup is restored and I want to bring the secondary database up before 4:15pm log backup is restored.
plz advice me
November 26, 2008 at 9:23 am
Do you want to switch roles of the primary and secondary databases?
If yes, then read Reversing Roles under http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx#EIF
HTH,
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply