apuntes de sql

Backup Database Practica
to disk = 'd:\Prueba\DBase1.bak'
with
Name = 'Parte_Uno',
Description = 'Primera Parte'

restore headeronly from disk = 'd:\Prueba\DBase2.bak'

Restore DatabasePractica
from disk = 'd:\Prueba\DBase1.bak'
with file = 4, recovery

SELECT DATABASEPROPERTYEX('Practica', 'RECOVERY')

ALTER DATABASE Practica SET RECOVERY FULL

USE Practica;
GO
EXECsp_spaceused @updateusage = N'TRUE';
GO

sp_helpdb N'Practica'; -- separa el espacio del back de log y diferencial

Use Practica;
GO
DBCC SQLPERF(LOGSPACE); -- me da el eapacio vacio en el log
GODBCC LOGINFO(Practica)

DBCC OPENTRAN;

USE Practica
CHECKPOINT


Restore Database Practica
from disk = 'd:\Prueba\Base2.bak'
with recovery, replace


Backup Database Practica
to disk= 'd:\Prueba\DBase1.bak'
with
Name = 'Agregado_Diferencial',
Description = 'Agregado_nofull_Parte',
Differential

use Practica
Checkpoint
Backup Log Practica
to disk = 'd:\Prueba\DBase1.bak'with
Name = 'Agregado_dos_Log',
Description = 'Agregado_tres_Parte'
DBCC SHRINKFILE(Practica_Log,100)

use Practica;
Go
declare @fecha nvarchar(MAX)
declare @archivo nvarchar(MAX)
set@fecha=CONVERT(nvarchar(MAX),GETDATE(),102)+'_'+SUBSTRING(Convert(nvarchar(10),getdate(),108),1,2)+SUBSTRING(Convert(Nvarchar(10),getdate(),108),4,2)+'horas'
set @archivo='D:\Prueba\DBase2'+@fecha+'.bak'Backup Database Practica
TO DISK = @Archivo
With Format,
Medianame='D_SQLServerBackups',
Name = 'Full backup'
GO






















Backup Database Practica
to disk ='d:\Prueba\Base1.bak'
with
Name = 'Parte_Uno',
Description = 'Primera Parte'

restore headeronly from disk = 'd:\Prueba\Base2.bak'

Restore Database Practica
from disk ='d:\Prueba\Base2.bak'
with file = 1, recovery

SELECT DATABASEPROPERTYEX('Practica', 'RECOVERY')

ALTER DATABASE Practica SET RECOVERY SIMPLE

USE Practica;
GO
EXEC sp_spaceused @updateusage = N'TRUE';...