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-11-04 : 08:48:10
|
| writes "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" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2004-11-04 : 13:04:01
|
| You need to make sure first, that your transaction backup job on the source is the only transaction backup job. Second, make sure that the job that backs up the log files is putting them in a shared directory that the other server can get to. Third, make sure your destination server sql agent login has permissions to the folder that is the source for your transaction logs. One place you might try for more detail and clues is the msdb database in the log shipping tables. There's usually more detailed information in the primaries table(may not be right on that name, but poke around).Mike"oh, that monkey is going to pay" |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-04 : 21:42:45
|
| double check your maintenance plan if it's doing as you say it should be doing and the schedule is correct. you could create your own package next time to make sure all the settings you've planned are correct.--------------------keeping it simple... |
|
|
|
|
|
|
log shipping from one server to another