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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-03 : 08:00:54
|
| Farid Uddin writes "Log shipping does not seem to be working. I have copied .TRN file in my Primary Server schedully. But it is not copiied and restored in my Seconadary Server. How I restore my transaction log file (.trn) in my secondary server? Please help me. If you have any document where I will get how to SHip the log in seconadary server and restore then send it to me. Thank youFarid Uddin" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-03 : 15:57:19
|
| What is the error?Tara |
 |
|
|
wtech
Starting Member
11 Posts |
Posted - 2004-12-07 : 04:17:16
|
| hi,i have a similar problem with log shipping but my problem is that i am not able to copy the backup files from the source server to the shared folder in destination server.hi tara, i don't have any error. the db maintenance plan is executed sucessfully, but the transaction files are not in the folder in the destination server. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-07 : 12:19:08
|
| Did you create a share and use that in the maintenance plan?Tara |
|
|
|
wtech
Starting Member
11 Posts |
Posted - 2004-12-14 : 02:04:06
|
| hi tara,sorry for the late reply.i have set up a shared folder in the destination server.I was successful in creating a maintenace plan also but the problem is as soon as i create the plan it starts the maintenace plan.It is in run mode that is because i have selected Enable while creating the schedules that is answered for but my problem is suppose i have created the plan at 12.55pm and in the maintenance plan i have set the job to run at 1.00pm exactly 5 mins after i have created the plan it doesn't copy the files to the destination server. Only the two files initially created(that is when the plan runs for the first time when i press finish button in maintenance plan wizard) are copied to the shared folder in the destination server. Why aren't the transaction files getting copied to the destinatioon server as per the schedule?Can u help me out?regards,wtech |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-12-16 : 07:55:23
|
| Some hints...1. Is your sql agent running ?2. I think you need a same domain account on the the servers. Or atleast same userid/pwds on both the servers.3. Is your destination server on stand by mode?I faced lot of problems while implementing log shipping...but eventually i settled down to merge replication..which i found easy to implement and very interesting...------------------------I think, therefore I am |
|
|
|
|
|
|
LOG Shipping