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 |
|
wtech
Starting Member
11 Posts |
 Posted - 2004-11-03 : 09:31:43
|
| hi,i have created a database maintenance plan i which i have to copy the backup files of the source database to the destination server.The problem is as i finish the plan the backup file is being copied into the transaction server but after that at the next scheduled time it si not copying the file to the destination server. it is just copying the backup files in the default directory of the source server.i don't know where the problem is.thanks and regards,wtech |
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-11-04 : 04:04:57
|
| Hi,In log shipping the primary database backs up its transaction logs to a directory on which you put a fileshare.The SQL Agent on the destination server copies these logs and saves them somewhere local, then the local restore job restores them.When you run the wizard you get to the "Specify Transaction Log Backup Disk Directory" dialog, that is the local directory on the primary server. You have to create the fileshare (next dialog "Specify the Transaction Log Share") on this directory.On the “Add Destination Database” dialog you give the "Trasnaction Log Destination directory", this is the local directory on the dest. server where the copy job copies the logs.If there's no copying going on make sure the above is all correct, esp. that the share is pointing to the right directory and that the account on which the SQL Agent on the secondary server is running can access the share on the primary server.Hope this helpsChidd |
 |
|
|
|
|
|
log shipping