Hi Is this the same script publish on technet? original link already removed i only can access it with archive.org

https://web.archive.org/web/20200318050435/https://gallery.technet.microsoft.com/scriptcenter/Script-to-Scipt-out-14a19eda

 

 

Backup strategy you describe at earlier post is already good.Backup Interval of those backup types can always be adjusted depending of the RPO/data loss that data owner can tolerate. I've...

Before answering your question, first you need to priorities why you need compression. If the answer is you need to save space, then you will benefit from index compression. Beware...

If you are using SQL Server that have SQL Agent Job, try using SQL maintenance job.

refer to this link

https://www.sqlservercentral.com/articles/backup-and-housekeeping-with-maintenance-plans

I've got same issue. in my case sql login NT Service\SQLTelemetry is missing, so i added again and grant same permission as in another server.

USE [master]
GO
CREATE LOGIN...

Indianrock (6/3/2009)

---

In test, this is working up to the point of putting the database back in standby or no recovery mode.

Msg 3153, Level 16, State 1, Line 1

The database is...