July 8, 2009 at 10:19 pm
Dear All,
We have - SQL Server 2005 - EE ; SP2 :
When i try to configure LogShipping iam facing the below error.
Services running: Local system on both the machines.
Both are in single network ; same domain; same logon account ; i tried number of times , but still facing the issue...
Does any one have any solution for this... ??
ERROR :
_____________________________________________________________________________________
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:\Logshipping\PrimaryServer\MASK.bak'. Operating system error 5(access denied).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Cheers,
- Win.
" Have a great day "
July 8, 2009 at 10:23 pm
SORRY...!!
Post dropped 3 times....its not my mistake - i tried posting then it given application error - then again i tried to post the same for 3 times refreshing-
Finally posted in new browser... Donno how it gone duplicated...
Cheers,
- Win.
" Have a great day "
July 8, 2009 at 10:26 pm
<<<>>>> while posting the topic
Cheers,
- Win.
" Have a great day "
July 8, 2009 at 11:19 pm
Hello,
Can you check if you do have access to the following backup file:
'C:\Logshipping\PrimaryServer\MASK.bak'
sometime if system backups are running and copying this than it may create this kind of problem. If backup is small copy it to other location and than restore.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:28 pm
Yes it has access to that backup folder...
When i tried in same machine with two instances, it worked fine...
But, when i try using network machines the error raised....
Access given ; shared permissions provided; everything is fine as i checked....
Any thoughts please...
Cheers,
- Win.
" Have a great day "
July 8, 2009 at 11:35 pm
Register the other network machine to the primary server; if successful. Do Logshipping through wizard.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:39 pm
Yes,
First i connected to Primary server , windows login and from there am connecting to the secondary and trying configure LS with wizard....
Cheers,
- Win.
" Have a great day "
July 8, 2009 at 11:43 pm
You did get it. I want you to register the server first. And than connect.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply