[SQL] 命令远程恢复数据库

最新推荐文章于 2020-11-05 13:51:32 发布

weixin_30810583

最新推荐文章于 2020-11-05 13:51:32 发布

阅读量71

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/Areas/p/5806685.html

sp_configure 'show advanced options', 1; 
RECONFIGURE;
GO
sp_configure 'xp_cmdshell', 1; 
RECONFIGURE;
GO
EXEC master..xp_cmdshell 'net use  \\70.2.199.153\1111 sds@3150 /user:ARISAMDEV153\spfarm';

--RESTORE DATABASE ArisamCafe FILE = N'ArisamCafe' FROM  DISK = N'\\70.2.199.153\1111\ArisamCafe_20160824.bak'
--WITH MOVE 'ArisamCafe_Data' TO 'D:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\DATA\ArisamCafe_Data.mdf',
--   MOVE 'ArisamCafe_Log' TO 'D:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\DATA\ArisamCafe_Log.ldf' ,REPLACE;
--GO

RESTORE DATABASE ArisamDB FILE = N'ArisamDB' FROM  DISK = N'\\70.2.199.153\1111\ArisamDB_20160824.bak'
WITH MOVE 'ArisamDB' TO 'D:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\DATA\ArisamDB.mdf',
    MOVE 'ArisamDB2' TO 'D:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\DATA\ArisamDB2.mdf',
   MOVE 'ArisamDB_log' TO 'D:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\DATA\ArisamDB_log.ldf',
   MOVE 'ArisamDB_log2' TO 'D:\Microsoft SQL Server\MSSQL10_50.SPS\MSSQL\DATA\ArisamDB_log2.ldf' ,REPLACE;
GO