Just to be clear, the reason I suggested going to the SIMPLE Recovery Model in my example was to, in fact, break the Log File chain in an...

Yes.  Your original post stated...

My personal feeling is that you're looking at the...

I wouldn't wholesale reduce, leave, or raise spending. I'd be more judicious about where I did any of those.

I also would look to incentivize others to find ways to...

Just to be clear, the reason I suggested going to the SIMPLE Recovery Model in my example was to, in fact, break the Log File chain in an attempt to...

As I know, freelancers in that field don't struggle with lack of work, they're always in demand, so you shouldn't have any problems with that regarding the number of...

I think the word "innovation" is a buzzword, the meaning of which has been bastardized just as the meaning of the title of "DBA" and the real "DevOps" has become.

What's...

"Shoddy" is the correct term for the rounding of the SMALLDATETIME datatype.

 SELECT CONVERT(SMALLDATETIME,'31 Dec 2022 23:59:30.000');

Result... next day, week, month, and year.

May 10, 2023 at 2:26 pm

#4187425

My apologies... I don't use any of the things that use the log file of a database so I don't actually know what else to check on this issue.  My...

If partitioning IS present, why is there a need for any of this?  SWITCH the old data out.  Copy it to a new table in the archive.  Then SWITCH that...

I will want to have this solution in my arsenal. What is the code to install ACE Drivers? How do I set it up?

Please, show me easy and step...

I'm pretty sure that BCP doesn't work on actual spreadsheets...

I think the answer is "because".  😉  I've not checked privs on system versioned temporal tables before but it may very well be that if the user has write privs...

Thanks for the advice.

So i read this before and did a log backup.

Backup Type: Transaction Log

It doesnt work... Or do you mean anything else?

Edit: So i turned the log...

If you look for the accepted answer at the following link...

https://social.msdn.microsoft.com/Forums/en-US/1fb51bb5-a09f-4bd6-8880-4f0c15227db5/what-does-it-mean-when-dbcc-loginfo-returns-many-rows-with-status-2-and-dbcc-opentran-returns-no?forum=sqldatabaseengine

... it says...

Status = 2 means that VLF can't be reused (overwritten) at this time and it...

I'm pretty sure that BCP doesn't work on actual spreadsheets ((but I...