What is the business case here for replication?  HADR? Readable copies for reporting etc?

With replication, you can always start the subscriber from a backup, rather than doing a...

What is the business case here for replication?  HADR? Readable copies for reporting etc?

With replication, you can always start the subscriber from a backup, rather than doing a snapshot.

https://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/

But the...

• This reply was modified 2 years, 4 months ago by Ant-Green. Reason: Updated

Your log backups are small, but your log used it large, so something must be preventing log re-use.

exec sp_whoisactive @show_sleeping_spids = 2, @get_transaction_info = 1

Anything sleeping with...

Anything holding a transaction open?

Do you have SP_WHOISACTIVE or SP_BLITZWHO scripts available?

And the LSBackup job is that reporting success or failure when running?

Could you supply the output of this code?

USE [ANTRAGO]
GO
SELECT 
DatabaseName = DB_NAME(), 
FileID = df.file_id, 
LogicalName...

OK, so you have built the cluster, created the AG and all thats working, it's just the databases wont add into the group.

So with the FULL method, you need to...

SELECT
    name AS DatabaseName,
    log_reuse_wait_desc AS LogBlocking,
    recovery_model_desc AS RecoveryModel
FROM sys.databases

What is the results from the query above? ...

Most likely is going to be some form of localisation, say British English to American English, and DMY / MDY based formatting.

When the package is executed in Visual Studio it...

As long as you have the necessary full backup and an intact log chain yes.

But please make sure you have something backing up the D:\DADOS-LOG folder, if that was to...

Create a SQL Server Agent job (if using Standard/Enterprise/Developer) or Windows Task Scheduler job (if using any edition), which runs that code every 1 hour.

You may want to also remove...

What type of 'Always On' are you trying to deploy as the term 'Always On' encompasses both 'Always On Failover Cluster Instances (FCI)' and 'Always On Availability Groups (AOAG)'.

Both of...

Sounds like your options here are using DTS/SSIS or using linked servers, it is no where near going to be instant, there is going to be delays, just how big...

It would all depend on requirements etc.

But you could use SSIS / ADF and ETL out the log shipped copy to Azure, custom scripting, BACPAC (if the DB size is...

Also you're not going to be able to do it in one go.

You have absolutely no cat in hells chance of getting a 2000 database to move to 2019 in...

Or where you do this

DECLARE @RECORD_ADD_DT datetime
SET @RECORD_ADD_DT = @RECORD_ADD_DATE

do this instead

DECLARE @RECORD_ADD_DT varchar(26)
SET @RECORD_ADD_DT = convert(varchar(26),@RECORD_ADD_DATE,121)