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-04-23 : 06:57:22
|
| hello all Can anyone tell me that can i configure log shipping along with a shrinkfile job which first takes a backup of the transaction log with no_log option.thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 11:39:28
|
| Why you need to shrink file? |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-04-24 : 05:42:43
|
| thanks for ur replyi want to shrink the file so that the size of the file doesnot grows to large.please tell me if I apply the command backup log abc to disk = 'c:\abc.bak'then which of the options i.e no_truncate,no_log etc are set by default. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-24 : 10:13:34
|
| You don't need to shrink file if log-shipping is configured to take T-log backup every 15-30 mins. That will control log growth. Donot take manual log backup as it will disturb LSN. |
|
|
|
|
|
|
log shipping