its getting tiresome that you @semolina keep posting same information prior posts already gave, just for the sake of showing off. if you don't have new information to supply refrain...

see this link https://learn.microsoft.com/en-us/sql/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables?view=sql-server-ver17

scroll down to "Use custom cleanup script approach"

price should not be the reason - there are some free tools to use. and others (like EA from sparkx) isn't that expensive.

hum... I would query the client and see how they are loading the file (to whatever system) and what are the chars they consider NON UTF-8.

or is it that they...

• This reply was modified 1 weeks, 3 days ago by frederico_fonseca.

go read the manuals. your comment shows a lack of understanding of what the openrowset command is so you need to study it

you can backup the db to a UNC share - so if she has permissions to do backups, permissions to share a drive with the SQL Server account then she...

I would say it isn't setup correctly on the NAS.

as you are using a SP - check that the SQL Server account also has required permissions, not just the SQL...

also make sure the encrypted file is being sent in BINARY mode.

you can do it easily. and without substrings or the likes.

note that the pattern you have a "in" does not contain the % sign at the end of the pattern....

let it run - but don't do 100mb chunks. do 50 GB or 100 GB each time.

but it will take a long time to run for sure.

the server where it works is it a Named instance or default instance?

and my advise, for multiple reasons, is never to use the powershell from SQL Server and instead use...

check https://sqljana.wordpress.com/2019/03/08/ssas-automate-ssas-backups-with-powershell/

use a powershell script instead - you can get all db names, and then do backup https://learn.microsoft.com/en-us/powershell/module/sqlserver/backup-asdatabase?view=sqlserver-ps

one other possible option is to have a job that updates the xmla of...

• This reply was modified 1 months, 2 weeks ago by frederico_fonseca.
• This reply was modified 1 months, 2 weeks ago by frederico_fonseca.

hum... using that with SSIS would be a big no no for me - why use a cloud thing for local processing (SSIS is local to server) - if you...

have a look at this thread - I've posted good info about using the free winscp to do what you need.. from within ssis.

https://www.sqlservercentral.com/forums/topic/ssis-sftp-using-winscp