mssql恢复

restore database a from disk='b.bak' with file=1, nounload,replace, stats=10
with move 'a' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\a.mdf',
move  'a_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\a_log.LDF'
posted @ 2010-09-02 09:34  JustLive  阅读(211)  评论(0)  编辑  收藏  举报