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