1. 系统还原

1.1. WEB

略

1.2. 数据库

1.2.1. 附加数据库

--1.附加数据库,路径改成相应路径即可
use master
EXEC  sp_attach_db  @dbname  =  'ebs2java',
@filename1  =  '/var/opt/mssql/data/ebs/ebs2java.mdf',
@filename2  =  '/var/opt/mssql/data/ebs/ebs2java.ldf'
go
EXEC  sp_attach_db  @dbname  =  'ebs_kernel',
@filename1  =  '/var/opt/mssql/data/ebs/ebs_kernel.mdf',
@filename2  =  '/var/opt/mssql/data/ebs/ebs_kernel.ldf'
go

1.2.2. 还原数据库

--linux无库还原数据库：
use master 
go
restore database ebs2java  from disk = '/home/ebs/ebs2java.bak' with 
        move 'ebs2java' to '/var/opt/mssql/data/ebs2java.mdf',
        move 'ebs2java_log' to '/var/opt/mssql/data/ebs2java.ldf' ; 

restore database ebs_kernel from disk = '/home/ebs/ebs_kernel.bak' with 
        move 'ebs_kernel' to '/var/opt/mssql/data/ebs_kernel.mdf',
        move 'ebs_kernel_log' to '/var/opt/mssql/data/ebs_kernel.ldf' ; 

restore database ebs20_order from disk = '/home/ebs/ebs20_order.bak' with 
        move 'ebs20_order' to '/var/opt/mssql/data/ebs20_order.mdf',
        move 'ebs20_order_log' to '/var/opt/mssql/data/ebs20_order.ldf' ; 

--linux有库还原数据库：
use master 
go
alter database [ebs2java] set offline with rollback immediate
restore database ebs2java  from disk = '/home/ebs/ebs2java.bak' with replace;
alter database [ebs2java] set online 

alter database [ebs_kernel] set offline with rollback immediate;
restore database ebs_kernel from disk = '/home/ebs/ebs_kernel.bak' with replace;
alter database [ebs_kernel] set online 

alter database [ebs20_order] set offline with rollback immediate;
restore database ebs20_order from disk = '/home/ebs/ebs20_order.bak' with replace;
alter database [ebs20_order] set online 

--windows 有库还原
use master 
go
alter database [ebs2java] set offline with rollback immediate
restore database ebs2java  from disk = 'C:\db\ebs2java_authentic.bak' with replace;
alter database [ebs2java] set online 

alter database [ebs_kernel] set offline with rollback immediate;
restore database ebs_kernel from disk = 'C:\db\ebs_kernel_autentic.bak' with replace;
alter database [ebs_kernel] set online 

--无库还原数据库 
use master 
go
restore database ebs2java  from disk = 'C:\ftp\db_download\ebsdb\ebs2java_authentic.bak' with 
            move 'ebs2java' to 'C:\ftp\db\ebs2java.mdf',
            move 'ebs2java_log' to 'C:\ftp\db\ebs2java.ldf' ; 

restore database [ebs20_order]  from disk = 'C:\ftp\db_download\ebsdb\ebs20_order_authentic.bak' with 
            move 'ebs20_order' to 'C:\ftp\db\ebs20_order.mdf',
            move 'ebs20_order_log' to 'C:\ftp\db\ebs20_order.ldf' ; 

restore database ebs_kernel from disk = 'C:\ftp\db_download\ebsdb\ebs_kernel_autentic.bak' with 
            move 'ebs_kernel' to 'C:\ftp\db\ebs_kernel.mdf',
            move 'ebs_kernel_log' to 'C:\ftp\db\ebs_kernel.ldf' ;