如何用sqldmo恢复数据库,急

我现在想将d:\aa.bak文件恢复到数据库中数据库名为“cc”
并将cc.mdf和cc_log.ldf放到c:\bb目录下怎样才能实现

用什么办法都可以
---------------------------------------------------------------

RESTORE FILELISTONLY
FROM DISK = 'd:\aa.bak'
RESTORE DATABASE CC
FROM DISK = 'd:\aa.bak'
WITH MOVE 'aa' TO 'd:\bb\cc.mdf',
MOVE 'aa_log' TO 'c:\bb\cc.ldf'
GO

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus