Using the full backup strategy

The restore process consists of several phases. The first phase is called safety check. If we are attempting to restore a database with the same name but different files, the restore process is terminated. When the database does not exist on the instance of SQL Server but some file on disk is in name conflict with some filename that is going to be restored, the restore process is terminated as well.

If restore is used for database creation, don't create an empty database before. SQL Server will do it for you using information from the backup device.

The second phase tries to remove the rest of the corrupted database. After this phase, the database is recreated and recovered from backup.

Never try to delete physically ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.