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 |
|
paqguy
Starting Member
1 Post |
 Posted - 2004-06-18 : 11:01:00
|
| I can't seem to find a definitive answer on this. If I import data using the DTS, does this activity get recorded in the log files when using Bulk Insert recovery model? BCP and BULK INSERT do, but what about DTS? And if it does, would the easiest way to prevent this from happening be to ALTER DATABASE and change the recovery model to SIMPLE during the import then change it back when completed?Thanks for your input.Shaun Beane |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-18 : 11:40:30
|
| I don't think it would help but anyway you would have to take a new full backup after changing it back to full.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-18 : 11:42:07
|
| Be careful about sp3 and 3a for v2k. They have the same version number and you have to look at the version of a dll to tell the difference.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
DTS activity logged using Bulk Insert