Pages

Thursday, November 27, 2008

SQL Server Restore DB Backup(Advanced)

RESTORE FILELISTONLY
FROM DISK = 'H:\Backup\BPM_MWS_71_VICTORS.bak'

RESTORE DATABASE [BPM_MWS_71_VICTORS]
FROM DISK = 'H:\Backup\BPM_MWS_71_VICTORS.bak'
WITH REPLACE, MOVE 'BPM_MWS_71_VICTORS' TO 'G:\LFC\BPM_MWS_71_VICTORS.MDF',
MOVE 'BPM_MWS_71_VICTORS_log' TO 'G:\LFC\BPM_MWS_71_VICTORS_log.LDF'

No comments: