May 13, 2009 at 1:20 pm
Hi,
Firstly,Iam Configuring Log Shipping in SQL Server 2005 and I want to Backup the Transaction log backups to Local to Primary Server.
In Transaction Log Backup Settings Wizard, I entered the Backup Path as C:\Backup(in the Second row), But the OK button is Greyed out and I'm not able to go to next step
What should we have to do to backup the logs to C:\backup in primary server?
Secondly, If I choose Network path( in the First row) like \\Network server\Tlogs and Local path C:\Backup(second row), then the transaction log backups will be taken to both the paths at the same time?
plz see the attachment
Please clarify me how this works...
May 14, 2009 at 5:43 am
While the local path is optional, you must enter a network path. The network path must be a network share.
The information is used for restoring the backups to the stand-by server.
[font="Verdana"]Markus Bohse[/font]
May 14, 2009 at 5:51 am
klnsuddu (5/13/2009)
Hi,Firstly,Iam Configuring Log Shipping in SQL Server 2005 and I want to Backup the Transaction log backups to Local to Primary Server.
If you want to do this you would have to copy the log backups from the backup folder that you created. You need to specify one more job to do that and give access to the backup folder.
In Transaction Log Backup Settings Wizard, I entered the Backup Path as C:\Backup(in the Second row), But the OK button is Greyed out and I'm not able to go to next step
What should we have to do to backup the logs to C:\backup in primary server?
Secondly, If I choose Network path( in the First row) like \\Network server\Tlogs and Local path C:\Backup(second row), then the transaction log backups will be taken to both the paths at the same time?
You should specify the network path to the same backup folder.
May 14, 2009 at 10:54 am
Thank you,
Which one of the following is the best pratice:
1.Backup the transaction logs to Local to the primary server and then copy to Secondary server
2.Create network share On a 3rd server(Not the Primary or Secondary) and then From the network share copy to Secondary
3.Backup the transaction logs to Local to the primary server and create one more job to copy to network share On a 3rd server(Not the Primary or Secondary) then copy to Secondary.
The 1st 2 steps Iam able to do But in Step 3, how to create one more job to copy all the Transactions logs to Network share from primary server
Iam Using the Log Shipping wizard. I did not find any option to perform step3.
We have 16 databases to log ship and Iam creating one folder to each database to place log backups on the primary. So we have 16 folders(Z:\Tlogs\folder1....folder16)
Now how to copy from each tlogs from each of these folders to a network share? and when to copy? I mean as soon as the tlogs created in each folder on primary, do we need to immediately copy them to Network share and then Network share to Secondary? or Tlogs to Secondary direcrtly from Primary and without disturbing that simply create a job to copy these tolgs to secondary as a precaution?
How you guys do? please advice me....
thanks again
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply