SQL Server - backup manager Cheat Sheet (DRAFT) by marucci.mauro

ALTER DATABASE [nombre_base] SET RECOVERY FULL
BACKUP DATABASE [nombre_base]
TO DISK = 'c:/direccion.bak' WITH FORMAT,
MEDIANAME = 'nombre_grupo_backups',
NAME = 'nombre_back_up';

RESTORE DATABASE  [nombre_base]
FROM DISK = 'C:\direccion.bak'
WITH DIFFERENTIAL;

BACKUP LOG [nombre_base] TO DISK = 'C:\direccion.bak';

use master;

RESTORE DATABASE [nueva_base]
FROM DISK = 'C:/direccion_full.bak'
WITH RECOVERY;

use master;

RESTORE DATABASE [nueva_base]
FROM DISK = 'C:/direccion_full.bak'
WITH NORECOVERY;

RESTORE LOG [nueva_base]
FROM DISK = 'C:/direccion_log1.bak'
WITH NORECOVERY;


RESTORE DATABASE [nueva_base] WITH RECOVERY;