March 19, 2003 at 10:28 pm
I want to setup a warm standby server using log shippnig. I have 2 SQLServer SP3, both have same setting, and use windows local administrator account login(none of them in a domain) , but when i start maintainence plan, there is an error said can't wirte to the standby server.
My question is: I must setup a windows domain, then using same domain account to login both server to establish a standby server?
or I am something wrong ? or there is a way to setting log shipping between 2 Server that not in a domain?
thanks a lot !
March 23, 2003 at 7:27 pm
No one know about this?
March 24, 2003 at 5:56 am
When you set up the log shipping, you must specify a shared forlder in the stand by server, so SQL can put all the logs backup in that folder. You should use for SQL Server Agent, a login account that has access to that folder.
March 24, 2003 at 10:46 am
You can copy the whole database daily or twice a day and Logshipping every hour in the above method racosta suggested.
.
March 24, 2003 at 11:50 am
The production server does nothing other than generate transaction backups. Drop your transaction logs on the production server.
SQLServerAgent on the stand by server should be started with an account login that has access to the production server file share that the transaction logs are going to. Use a copy job to pull the transaction logs.
I Log ship about 60 databases here.
Cheers
Will setup Log shipping for food
John Zacharkan
John Zacharkan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply