RestoreDB_sql

電腦小知識

RESTORE FILELISTONLY FROM DISK = ‘D:DBBackupxxxxxxx.bak’

GO

RESTORE DATABASE xxxxxxx

FROM DISK = ‘D:DBBackupxxxxxxx.bak’

WITH MOVE ‘xxxx_Data’ TO ‘D:SQL Server Dataxxxxxxx_Data.MDF’,

MOVE ‘xxxx_Log’ TO ‘E:SQL Server Logxxxxxxx_Log.LDF’,

REPLACE

GO

, , , ,