Hi guys, With respect to both replies, I had a question I needed a straight answer.

To clarify, I have a Windows 2019 Server with two 2.20 GHz processors and...

For higher volume stores whose database can't fit within 10GB limit, we will deploy Standard Edition. Obviously Azure SQL would have advantages over on-sight deployments, but the issue is...

on a very busy system those values will cause many jobs to be cleared within hours.

on top of increasing those values (mainly the first one as it is the sum...

• This reply was modified 2 years, 9 months ago by frederico_fonseca.

are you using a ODBC connection setup on odbc32 ? if so ensure it is a SYSTEM connection, not a user connection.

ideally a DSN-less connection should be used if possible...

see https://www.sqlservercentral.com/forums/topic/cant-run-package-via-sql-agent#post-3999259 for an image of how to set the execution to 32 bit.

but I have to query WHY you are using a 32 bit driver on a 64 bit...

• This reply was modified 2 years, 9 months ago by frederico_fonseca.

and how are you running it manually on the server? through command line (32 or 64 bit depending on which folder you execute from) or through the DTUI (32 bit).

and...

and are you sure the server has the 32 bit installed and not just the 64 bit (preferable most of the times)?

@frederico, sorry I pressed report instead of reply, my sincerest apologies.

They specifically call it the "bloom" filter in the article, unsure if they renamed balloon to bloom at some...

You running on VMWare at all?  And if so are there any snapshots running at the times the errors are reported or is the bloom filter driver enabled via...

different

MOVE vs COPY

unless the client is able to do their own sql, the list of possible columns, or even formulas used, would be available upfront on the UI - so allowing them...

two comments

1 - your script is using Excel - this will not be supported on a Server and will have licensing implications to your company - are you aware of...

I partially disagree - splitting the backup into 4 or 8 files, and changing restore BUFFERCOUNT and MAXTRANSFERSIZE do affect restore performance.

but one thing that hugely affects restore is the...

• This reply was modified 2 years, 10 months ago by frederico_fonseca. Reason: change blocksize mention to the correct parameters on restore
• This reply was modified 2 years, 10 months ago by frederico_fonseca.

better to send email by PM and remove from post - easy pick for scammers

being a VM it is the same as having it on prem from an AD configuration point of view - unless someone decided to create a new domain for that...