Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit Samria
You can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>
2012年2月24日星期五
Disabled/turn off Transcation logging while performing BCP opratio
标签:
article,
bcp,
bcpopration,
database,
disabled,
improve,
logging,
microsoft,
minmize,
mysql,
opratio,
oracle,
particular,
perfommace,
performing,
provide,
server,
sql,
transcation,
turn
订阅:
博文评论 (Atom)
没有评论:
发表评论