Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL2K Log Shipping

Status
Not open for further replies.

wbodger

Programmer
Apr 23, 2007
769
US
OK, I have setup Log Shipping before on a different box, no problems. Now, with 2 new boxes, I seem to be dead in the water. I run thru everything and then I get this message

Code:
Microsoft SQL-DMO (ODBC SQLState: 42000)

Error 3201: Cannot open backup Device
'\\SQL01\backup\utility\utility_logshipping_init.bak'. Device error or device off-line. See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally.

I am running SQL Server and the SQL Server AGent under the domain admin account, I have made sure the domain admin has full access to the drive where I am trying to create the backups. Not sure what I may be missing. The error log shows Operating system error 5(access is denied), but I start the services (SQL Server and SQL Server Agent) as the domain admin. Does it not run the maintenance plans under the same account that runs the service? Anyone got any thoughts on this one?

Willie
 
Well, after reading another post 3 more times, IO realized I was using a UNC for the local backup, so I switched that and now the backup works, but the copy to the secondary server doesn't work. So, here is my question. I have the service on both machines starting under the domain admin account. I have gone in and given the domain admin full control over pretty much everything on both machines as I am trying to get this to work. So, does Log Shipping not run under the account that starts the service?

Help?

wb
 
Note, it is copying the initialization file that does not work, if that makes any difference.

wb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top