Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thinknight
Starting Member
3 Posts |
 Posted - 2008-12-15 : 08:08:55
|
| I want to set up Log shipping mechanism with two different servers.One of these; 192.168.140.XX and the other is 192.168.140.YY. Both of them is in DMZ.XX is the primary and YY is the secondary server.I try to establish Data transfers several times But I could not.The first step is to take full backup, it is OK.But the following steps fails. There is not a copy of the full backup in the secondary server shared area.And I am geeting the below error int the YY (Secondary) server.BackupDiskFile::OpenMedia: Backup device '\\XX\Ecom$\EComDB.bak' failed to open. Operating system error 53(error not found)Then I a create a local user on both two server, then try to establish data transfer, it did not work.I share the folder and give full control access to the everyone. And Also i create Logshipper user in both two server as a local system user with same passwords.Where am i making mistake?Waiting for your responses |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-15 : 09:20:56
|
| Your services should run in domain account and allow wizard to copy the full backup to other server.Make shared folder contains all permession to implement log shipping. |
 |
|
|
|
|
|
Could not establish Log shipping