BACKUP DATABASE [CityMallV8.4.1_junao] TO DISK = N'f:\data\bak\CityMallV8.4.1_junao20161111.bak' WITH NOFORMAT, NOINIT, NAME = N'CityMallV8.4.1_junao-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD, STATS = 10

BACKUP DATABASE [CityMallV8.4.1_junao] TO DISK = N'E:\data_bak\CityMallV8.4.1_junao201611221232.bak' WITH NOFORMAT, NOINIT, NAME = N'CityMallV8.4.1_junao-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO

=== restore database MallV840_baixinglinggou from disk='F:\MallV840_baixinglinggou(206.11.23).bak' with MOVE 'MallV840_baixinglinggou' TO 'C:\Users\Robert\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v12.0\MallV840_baixinglinggou.mdf', MOVE 'MallV840_baixinglinggou_log' TO 'C:\Users\Robert\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v12.0\MallV840_baixinglinggou.ldf', replace

USE MallV840_baixinglinggou; GO EXEC sp_helpfile; GO

RESTORE DATABASE [CityMallV8.4.1_junao] FROM DISK = N'f:\data\bak\CityMallV8.4.1_junao20161111.bak' WITH FILE = 1, NOUNLOAD, STATS = 10 GO

RESTORE DATABASE [CityMallV8.4.1_junao] FROM DISK = N'f:\data\bak\CityMallV8.4.1_junao20161111.bak' WITH FILE = 1, KEEP_REPLICATION, NOUNLOAD, REPLACE, STATS = 10 GO

RESTORE DATABASE [CityMallV8.4.1_junao5] FROM DISK = N'F:\data\bak\CityMallV8.4.1_junao20161111.bak' WITH FILE = 1, MOVE N'CityMallV8.4.1_junao' TO N'F:\fabu\111.mdf', MOVE N'CityMallV8.4.1_junao_log' TO N'F:\fabu\11.ldf', KEEP_REPLICATION, NOUNLOAD, REPLACE, STATS = 10 GO

=== RESTORE DATABASE [CityMallV8.4.1_junao5] FROM DISK = N'F:\CityMallV8.4.1_junao_backup_2017_02_04_0930.bak' WITH FILE = 1, MOVE N'CityMallV8.4.1_junao' TO N'F:\data\CityMallV8.4.1_junao5.mdf', MOVE N'CityMallV8.4.1_junao_log' TO N'F:\data\CityMallV8.4.1_junao5.ldf', KEEP_REPLICATION, NOUNLOAD, REPLACE, STATS = 10 GO