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 |
|
NP
Starting Member
5 Posts |
 Posted - 2008-11-05 : 22:06:52
|
| Hello, Log backup job in the logshipping is taking too much time to execute. it takes around 6 min to take the tlog backup of just 81kb file!!!! I reset log shipping 3 to 4 times but it still taking that much of time. Even i ran job forcefully but still the same. only when i backup log from Query analyser it runs in 2 sec!! can anybody put some light why LSBackjob is taking so much time. |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-11-06 : 01:03:11
|
| is your T log backup file 81KB or the T log itself is 81KB?How many databases do you have? |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-11-06 : 04:17:27
|
| It also depend upon the link(Bandwidth between the machines). Just try copying some file between the servers and note the time. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-06 : 09:14:25
|
| I guess you must be backing up to fileshare for Lsjob? Is it local or UNC path? |
|
|
|
NP
Starting Member
5 Posts |
Posted - 2008-11-06 : 15:41:58
|
quote:
Originally posted by steel
It also depend upon the link(Bandwidth between the machines). Just try copying some file between the servers and note the time.
It worked it was problem with linkThanks,NP |
|
|
|
|
|
|
Log Backup job