Sqlserver 还原分区数据库的sql脚本

USE master;
GO

RESTORE DATABASE [DataBaseName02]
FROM DISK = 'G:/DBFile/DBback/DataBaseName.bak'
WITH REPLACE,
MOVE 'DataBaseName'
TO 'G:/DBFile/DataBaseFile/DataBaseName02.mdf',
MOVE 'DataBaseName_log'
TO 'G:/DBFile/DataBaseFile/DataBaseName02_log.ldf',
MOVE 'DataBaseName_DataS'
TO 'G:/DBFile/DataBaseFile/DataBaseName02_DataS.mdf',
MOVE 'DataBaseName_DataSIndex'
TO 'G:/DBFile/DataBaseFile/DataBaseName02_DataSIndex.mdf';

GO

RESTORE

Sqlserver 还原分区数据库的sql脚本最先出现在Python成神之路。