apologies - I read "truncate table" as "truncate log" my mistake

additionally were you running previously in simple recovery mode?  the database may have been changed to full recovery and there is no t-log backup job..... just guessing.

you could also try...

just for clarification (before I give you the wrong advice) - You mentioned Replication and CDC (change data capture)

which one are you using? they are very different things

I think you are right, Mike. I'm certain that in my position I don't have the clout to effect change. Developers and DBAs are viewed as people who keep...

gotta disagree with frederico on this one... if the software is licenced to the client and the client owns the server then they can do what the heck they want...

I told them when they hired me that I can be a walking HR violation and that they should seat me near people that are not easily offended when I...

• This reply was modified 6 years, 2 months ago by MVDBA (Mike Vessey).

Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long...

Jeff???? really - you have an age column? whoever did that needs a beating - even as a 16 year old (a long time ago)...

This article, Kendra, comes at a critical time for my work, which in the last 18 months had begun to adopt a more agile approach to software development. We...

Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP...

filegroups in a database can be used for a few things (filestream, memory optimised tables etc etc) but splitting your storage is your main gain.. (perhaps a tiny improvement if...

an alternative (if you can't use the view because it points to a linked server) is to use transactional replication and update the table in small chunks, rather than a...

Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead

again -...

Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead

again - sorry jeff,...

It’s interesting to think about developer time when it comes to the top two results: the “freeing up developer time” isn’t simply about allowing them time to code more changes which are delivered more...