sql server 的.bak文件还原到数据库

RESTORE DATABASE chugui
FROM DISK = 'F:\ftp\红田\2.bak'
WITH MOVE 'chugui' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\chugui',
MOVE 'chugui_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\chugui_log'

posted @ 2013-12-27 10:21 zhushang 阅读(352) 评论(0) 收藏举报