数据库还原脚本

restore database [game798bbs]
from disk='F:\game798bbs_db_201101020300.BAK'  with replace,

 file=1
,move 'dnt.game798.com_Data' to 'E:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\game798bbs.MDF'
,move 'dnt.game798.com_Data2' to 'E:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\game798bbs2.MDF'
,move 'dnt.game798.com_Data3' to 'E:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\game798bbs3.MDF'
,move 'dnt.game798.com_Log' to 'E:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\game798bbs.ldf'
,move 'dnt.game798.com_Log2' to 'E:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\game798bbs2.ldf'

posted @ 2011-01-10 23:52  暗香浮动  阅读(821)  评论(0编辑  收藏  举报