restoreconfdb.sql

visual studio.net学习资料

restore database Conf
from disk='c:\Program Files\Msdntrain\2063\Labs\database\confdb.bak'
with recovery,
move 'Conf_data' to 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\conf.mdf',
move 'Conf_log' to 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\conf.ldf'