July 15, 2004 at 6:25 am
Hi,
is there any possibility to exclude sql statements from the sql server logging service?
I've got some stored procedures to do some temporary data copy from e.g. external ressources. I don't need to have these statements in the transaction log, it's only temporary stuff. But that's the reason, why the log file growing up enormously.
Thanks for all proposals,
Thilo
July 15, 2004 at 7:01 am
- you might consider bulk-copy-recovery model, but you 'll always have some logging.
- can you use @-table-datatype ? (sql2k) this one has less logging then # or @@-temp-tables.
- You might also consider to create an alternate database in which you can put your "temporary" objects, and have that db using simple-recovery.
- keep your transactions as short as possible
- take frequent log-backups
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 15, 2004 at 7:07 am
Hi
Have you tried BULK INSERTS? If certain criteria is met the transaction will not be logged.
Andy.
July 15, 2004 at 7:30 am
The idea to create an alternate database is a nice and simple solution.
Thanx a lot,
Thilo
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply