Conception Et Réalisation (SQL Server) by Grare Stéphane - HTML preview
PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.
Download the book in PDF, ePub, Kindle for a complete version.
Restauration par le code
Avec du code T-SQL, c’est l’instruction RESTORE qui va nous permettre d’effectuer une
restauration de base de données :
/**** Restauration de la base après suppression ****/
RESTORE DATABASE [Papyrus] FROM DISK = N'C:\Backup Papyrus\Data.bak' WITH
FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10
RESTORE DATABASE [Papyrus] FROM DISK = N'C:\Backup Papyrus\Data.bak' WITH
FILE = 2, NOUNLOAD, STATS = 10
GO