viernes, 21 de septiembre de 2012

SQLSERVER - backup and restore database command

BACKUP DATABASE [database]
TO  DISK = N'F:\backups\databasebackup.bak'
WITH NOFORMAT,
NOINIT,
NAME = N'databasebackup-Full Database Backup',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10
GO

--------------------------------------------------------------------------------------------

RESTORE DATABASE [databasebackup]
FROM  DISK = N'F:\backups\databasebackup.bak'
WITH  FILE = 1,
MOVE N'file_intranet_data'
TO N'E:\DB\databasebackup.mdf',
MOVE N'file_intranet_log'
TO N'E:\DB\databasebackup_log.ldf',
NOUNLOAD,
REPLACE,  STATS = 10
GO

No hay comentarios:

Publicar un comentario