It is solved.

The only thing I changed was ' EXEC sp_executesql @RestoreSQL;'

I created a small procedure that reads the backup file and restores the DB daily. But...

It is solved.

The only thing I changed was ' EXEC sp_executesql @RestoreSQL;'

I created a small procedure that reads the backup file and restores the DB daily. But...

• This reply was modified 2 days, 23 hours ago by  Chitown.

Yes. CDC is enabled.

I have admin rights on the test server.

Unfortunately it didn't work for me since I believe master.dbo.xp_delete_file only works with backup and some other files but not with trace files

Found the issue. There was another folder created under msdb and all the packages were moved there. After I moved couple of packages back to msdb, reran the job and...

Thanks Phil. The link you shared was very detailed and helpful but unfortunately we don't want to build SSIS catalog. I still don't understand why the job runs when I...

"C:\program files (x86)\Microsoft SQL Server\150\DTS\Binn\dtexec.exe" /SQL "PackageName"  /SERVER sqlserver /CHECKPOINTING OFF /REPORTING E

I changed the job to point to old server and I no longer run into an issue. All...

• This reply was modified 2 years, 3 months ago by  Chitown.

Target server version is set to SQL Server 2019.

We use a third party tool 'ControlM' to create jobs, execute them since we have hundreds of jobs which run everyday so...

After changing just the compatibility level, queries are running efficiently. Thanks all...

Did you expand the AG then databases and see what it shows on other replicas which are part of forwarder? If it is in red then I believe it is...

Use DB.....That's where the problem was...... 🙂

Enterprise edition. DB is in simple recovery even though it is prod and we are aware of the data loss if there are any issues. 200GB of memory with 56...

No wonder I am losing hair.....

So I created one of the table from an existing DB, created one non clustered index, inserted more records into it. Made it 85% fragmented....

• This reply was modified 3 years, 4 months ago by  Chitown.

What if I save the DDL as .sql file and use powershell to execute that command from the location on each database? Will that work? If so, then what's the...