Now that you have your database set up, you need to configure backups. Backing up the SQL Server data files is not an adequate backup strategy, as those data files are live and may not be in a consistent state at the time of backup. Third-party tools that support SQL Server backups are also not recommended – the best way to back up SQL Server is to use the backup tools provided by Microsoft with the software.
Please review ‘Best Practice recommendations for SQL Server Database Backups’:
Back to Table of Contents