BACKUP DATABASE DataBase
TO DISK='D:\checking\DataBase_1.bak',
DISK='D:\checking\DataBase_2.bak'
GO
RESTORE DATABASE DataBase1
FROM DISK='D:\checking\DataBase_1.bak',
DISK='D:\checking\DataBase_2.bak'
WITH MOVE 'LogicalNameofDB_Mdf' TO 'D:\DataBackup\DataBase.mdf',
MOVE 'LogicalNameofDB_Log' TO 'D:\DataBackup\DataBase.ldf'
GO
No comments:
Post a Comment