different types backups

Sql Server Online Backup

SQL Server provides a way to back up your data online, without having to stop the SQL Server service. This is a great feature, especially for larger databases that can take a long time to back up using the traditional methods.

To use the online backup feature, you first need to create a backup job. You can do this by opening SQL Server Management Studio and connecting to your SQL Server instance. In the Object Explorer pane, expand the server …

June 28, 2022 by Backup

Backup Copy Only Sql Server

Backup Copy Only Sql Server is a new feature in Sql Server 2016 which allows you to create a copy of a backup without including the data files. This can be useful if you need to create a backup for a different server or if you need to create a backup of a backup.

To create a backup copy only, you can use the Backup-SqlDatabase cmdlet. The cmdlet has the -CopyOnly parameter which you can use to create the backup …

May 27, 2022 by Backup
Manent is an algorithmically strong backup and archival program