SQL SERVER – Restore Database Backup using SQL Script (T-SQL)

preview_player
Показать описание
Restores backups taken using the BACKUP command. This command enables you to perform the following restore scenarios:

Restore an entire database from a full database backup (a complete restore).

Restore part of a database (a partial restore).

Restore specific files or filegroups to a database (a file restore).

Restore specific pages to a database (a page restore).

Restore a transaction log onto a database (a transaction log restore).

Revert a database to the point in time captured by a database snapshot.
Рекомендации по теме
Комментарии
Автор

Use this when I failed to try restore db from the task (because different version SQL Server Management Version) Thanks this video helpful

ilhamakbari
Автор

This title is misleading and is poor education for anyone wanting to learn about real database restores.This is a typical developer approach to 'restoring' a database who thinks that scripting database moves is a restore.  This is NOT restoring a database.  This is SCRIPTING CRUD statements from another database--DML operations.   True restores involve the RESTORE DATABASE TSQL script

CatholicSchoolAlum
join shbcf.ru