April 3, 2008 at 3:57 am
Hi:
Is there a way to copy data from a table from a database to another table to another database without having to write to the transaction log.
The data will be wiped out every night and is very big, so in this process need not do any transaction log, but do not know how to avoid that.
Not sure the bulk copy is the right direction.
Any suggestion and help mostly appreciate.
April 3, 2008 at 4:14 am
use bulk insert in combination with bulk logged recovery model
Keep in mind changing the recovery model will affect your DRP !
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
April 3, 2008 at 4:20 am
Thank you, I will do some reseach on the DRP (recovery procedure ?)
Can the database the table that need to copy to be a simple recovery and still use Bulk Insert and not involve using the transaction log, it help few things, it save time to write to logs and also take not space. many tables are big just need to cover some big selective data every night.
April 3, 2008 at 4:51 am
Hi
You can use bulk insert on a database which is in simple recovery mode. Recovery models define how much the data can be recovered in case of disasters.
Read up on these before making a decision.
"Keep Trying"
April 3, 2008 at 8:03 am
Thank you, I will do that.
Thx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply