数据库还原脚本
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'