use master
GO
--断开所有连接
ALTER DATABASE [
数据库] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER database [数据库] set online
GO
www.2cto.com
--还原数据库
RESTORE DATABASE [数据库]
FROM DISK = '[bak路径]'
WITH MOVE '[数据库]' TO '[mdf保存路径]',
MOVE '[数据库]_log' TO '[log保存路径]',
STATS = 10, REPLACE--每完成10%输出
GO