Saturday, 10 December 2011

How to i Can Create Backup and Restore my File With LowDisk Space


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