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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2008-06-12 : 05:31:11
|
| hello all, I Have configured log shipping on production databases on Sql server 2000 but due to the full recovery mode of the databases the log file is taking too much of the free space . should i shrink them or they will cause an erro in log shipping.thank u |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-12 : 11:41:15
|
| How recently do you backup log in Primary server? You should backup log frequently so log growth is controlled. Yes you can shrink the log file but donot manually backup log with truncate_only option as it will break log chain . |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-06-13 : 05:13:33
|
quote:
Originally posted by sodeep
How recently do you backup log in Primary server? You should backup log frequently so log growth is controlled. Yes you can shrink the log file but donot manually backup log with truncate_only option as it will break log chain .
thank you |
|
|
|
|
|
|
log shipping