August 31, 2004 at 9:43 pm
A cheery g'day to everyone.
I would be grateful if anyone could help me out with the following:
I have two SQL Servers both running SQL Server 2000 Dev Ed for now, we are still evaluating, and I am wanting to set-up log shipping.
I have created a Log Shipping share on both the primary and secondary server and have tried to implement log shipping through Enterprise Manager and Maintenance Wizard. I do the following, forgive me if I am being dumb:
1) On primary go in to Create Maint plan wizard.
2) Select DB in this case BRENDAN_TEST (and select Log shipping at bottom).
3) Click through all options (I have chosen not to backup as part of plan, do I need to?) until I come to SPecify transaction log backup directory.
4) Select the directory as d:\SQL Server\log shipping and to remove files older than a week.
5) Network share I select \\ primaryservername\log shipping
6) Specify destination, I click on ADD and I select the secondary server from the drop down list. I change the directory to e:\Microsoft SQL Server \ Log Shipping which is where I want to save the shipped logs on the secondary server, I select to create and initalize new db BRENDAN_TEST, select no recovery mode, and to allow the DB to assume primary role and select the directory to \\ secondaryservername\log shipping
7) Select to perform full backup now
8) Select all defaults except for selecting my machine to be the monitoring machine, I have developer installed also.
9) Select default schedules and then click OK to confirm I get the following error message":
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Error 3201: Cannot open backup device '\\primaryservername\Log Shipping\Brendan_Test_logshipping_init.bak'. Device error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally.
Anyone got any suggestions?
September 2, 2004 at 2:30 am
HI,
Please check the ID that you are using to run the backup job. Does the ID have access to the share. Also Check the domains that your server are running on and see if you have a trust to execute the back up.
One other place to check would be the ID that is running your SQL service and see if that ID has access to the log share
Cheers
September 2, 2004 at 9:42 am
The SQL service accounts for both servers require Read/Write NTFS permissions to the folders and Change permissions to the shares. In addition, the SQL service accounts require SA permissions in SQL on both servers.
Diane
September 2, 2004 at 12:40 pm
Is the registration on the primary server under local or servername ? Make sure it is the servername and not local.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply