November 3, 2011 at 3:57 am
Hi,
I am trying to setup Log Shipping on my computer.
Configuration
Windows 2007
SQL Server 2008
Two instance
1. Training
2. Secondary
On the Training server, I have created a DB Test1. Under that I have created a table tb_date which contains only one column ID_Date. Using a job, I am inserting current date and time every minute. The data and log files are saved in default location.
Now when I am trying to create log Shipping, it is asking for network path for the backup location. I have added the local path of the backup folder. But the OK button is still greyed out.
Please let me know where I am doing wrong.
November 3, 2011 at 4:04 am
when you configuring the backup path, you should be getting two option. One for network location and other for local.
You might be overlooking the local path option where you have to specify your local backup file location.
----------
Ashish
November 3, 2011 at 5:37 am
Thanks for the reply.
But I am mentioning the local backup path as D:\SQL\Backup. Still the OK button remains greyed out. Only when I try and enter some information in network path then it highlights the OK button.
November 3, 2011 at 6:10 am
thats the network path so the secondary can pick up the logs
as its the same box, put \\hostname\d$\sql\backups
or make the backups folder a shared folder eg \\hostname\backups
November 4, 2011 at 1:03 am
:-)Thanks Anthony, ur solution worked.:-)
November 4, 2011 at 2:59 am
Not a problem
Just remember when you do go to production with this that you either give the Secondary's agent account the rights to access a $ share, so local admin, or you create the backups folder as a shared folder and grant the agent read access.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply