Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Transaction log shipping not working, insufficient rights?
Thijs1979
Member Posts: 3
Hi all!
I'm trying all day to get transaction log shipping (SQL Server 2005) to work, but without success so far. I hope you can help me! Here's the situation:
I have an SQL Server 2005 in Domain A. I want to ship the transaction logs of a Nav 4.03 database to a SQL Server in Domain B. There is no trust between the domains.
On both servers I created a local (not domain!) account called "SQLAgentAc" with same password which I use on both servers to run the SQL Server Agent service. Therefore I added this account to the group called SQLServer2005SQLAgentUser$SERVERA$MSSQLSERVER (and SQLServer2005SQLAgentUser$SERVERB$MSSQLSERVER)
On both servers there is a shared folder to which "SQLAgentAc" has read+write access to. When I am on the server in domain A, I can access the shared folder on server B by using the "SQLAgentAc" username and password. I can create new files in the folder, so far so good.
Now I turn on Transaction Log Shipping for my database on server A. I tell the server to put the backup file in
\MSSQL\TRANSLOGS and copy it to \\SERVERB\TRANSLOGS.
Backing up the file is going OK, the BAK file appears in\MSSQL\TRANSLOGS on server A, but when it wants to copy the file to server B the error appears:
SQL Server Management Studio restore database 'DATABASENAME'
An exception occured while executing a Transact-SQL statement or batch (SqlManagerUI)
Cannot open backup device '\\SERVERA\TRANSLOGS\DATABASENAME.BAK' Operating system error 5(error not found). RESTORE FILELIST is terminating abnormally (Microsoft SQL Server, Error: 3201)
This is strange because the file is there, and I can even see it from Server B. What am I doing wrong??
I tried to create a manual backup job on server B using a new file on A, using the following command:
BACKUP DATABASE [DATABASENAME] TO DISK = N'\\SERVERA\TRANSLOGS\DATABASENAME.bak' WITH FORMAT, INIT, NAME = N'DATABASENAME-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
This results in the following error:
Executed as user: SERVERB\SQLAgentAc. Cannot open backup device '\\SERVERA\TRANSLOGS\DATABASENAME.bak'. Operating system error 5(error not found). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I hope someone can help me with this! Thanks in advance!
I'm trying all day to get transaction log shipping (SQL Server 2005) to work, but without success so far. I hope you can help me! Here's the situation:
I have an SQL Server 2005 in Domain A. I want to ship the transaction logs of a Nav 4.03 database to a SQL Server in Domain B. There is no trust between the domains.
On both servers I created a local (not domain!) account called "SQLAgentAc" with same password which I use on both servers to run the SQL Server Agent service. Therefore I added this account to the group called SQLServer2005SQLAgentUser$SERVERA$MSSQLSERVER (and SQLServer2005SQLAgentUser$SERVERB$MSSQLSERVER)
On both servers there is a shared folder to which "SQLAgentAc" has read+write access to. When I am on the server in domain A, I can access the shared folder on server B by using the "SQLAgentAc" username and password. I can create new files in the folder, so far so good.
Now I turn on Transaction Log Shipping for my database on server A. I tell the server to put the backup file in
\MSSQL\TRANSLOGS and copy it to \\SERVERB\TRANSLOGS.Backing up the file is going OK, the BAK file appears in
\MSSQL\TRANSLOGS on server A, but when it wants to copy the file to server B the error appears:SQL Server Management Studio restore database 'DATABASENAME'
An exception occured while executing a Transact-SQL statement or batch (SqlManagerUI)
Cannot open backup device '\\SERVERA\TRANSLOGS\DATABASENAME.BAK' Operating system error 5(error not found). RESTORE FILELIST is terminating abnormally (Microsoft SQL Server, Error: 3201)
This is strange because the file is there, and I can even see it from Server B. What am I doing wrong??
I tried to create a manual backup job on server B using a new file on A, using the following command:
BACKUP DATABASE [DATABASENAME] TO DISK = N'\\SERVERA\TRANSLOGS\DATABASENAME.bak' WITH FORMAT, INIT, NAME = N'DATABASENAME-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
This results in the following error:
Executed as user: SERVERB\SQLAgentAc. Cannot open backup device '\\SERVERA\TRANSLOGS\DATABASENAME.bak'. Operating system error 5(error not found). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I hope someone can help me with this! Thanks in advance!
0
Comments