July 8, 2009 at 10:18 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 has 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 10, 2009 at 2:56 am
Give full permission to everyone on this file ..
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply