RESTORE DATABASE Supervision FROM DISK = 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\Backup\Supervision.bak'
with replace,
MOVE 'Supervision' TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\Supervision.mdf',
MOVE 'Supervision_log' TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\Supervision_log.ldf'、
RESTORE DATABASE db(数据库名称) FROM DISK = 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\Backup\Supervision.bak(还原文件目录)'
with replace,
MOVE db(数据库名称)TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\db(数据库名称).mdf',
MOVE 'db(数据库名称)_log' TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\db(数据库名称).ldf'
with replace,
MOVE 'Supervision' TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\Supervision.mdf',
MOVE 'Supervision_log' TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\Supervision_log.ldf'、
RESTORE DATABASE db(数据库名称) FROM DISK = 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\Backup\Supervision.bak(还原文件目录)'
with replace,
MOVE db(数据库名称)TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\db(数据库名称).mdf',
MOVE 'db(数据库名称)_log' TO 'D:\SQLDERVER2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\db(数据库名称).ldf'