-------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
-------------------- dZGOlD 备份数据库文件恢复---------------------------------------------------------------
---------------------------------------------------------------------------------------
declare @dZGOlD_BAK_NAME as varchar(50),
	@dZGOlD_BAK_DATA_NAME as varchar(50),
	@dZGOlD_BAK_LOG_NAME as varchar(50)

-- 需要修改部分
set @dZGOlD_BAK_NAME      = 'E:\ERPX_DB\2008112016_dZGOlD.DAT'  --备份数据库文件路径及文件名称
set @dZGOlD_BAK_DATA_NAME = 'E:\ERPX_DB\dZGOlD.DAT'	     --恢复数据库数据文件路径及文件名称
set @dZGOlD_BAK_LOG_NAME  = 'E:\ERPX_DB\dZGOlDLOG.DAT'	     --恢复数据库日志文件路径及文件名称
-- 需要修改部分结束

RESTORE DATABASE dZGOlD 
   FROM DISK= @dZGOlD_BAK_NAME
   WITH NORECOVERY, 
--      MOVE 'DZ_GOLD' TO 'F:\ERPX_DB\temp\dZGOlD.DAT', 
--      MOVE 'DZ_GOLDLOG' TO 'F:\ERPX_DB\temp\dZGOlDLOG.DAT'
      MOVE 'DZ_GOLD' TO @dZGOlD_BAK_DATA_NAME, 
      MOVE 'DZ_GOLDLOG' TO @dZGOlD_BAK_LOG_NAME

RESTORE LOG dZGOlD
--   FROM DISK= 'F:\ERPX_DB\temp\2006042615_dZGOlD.DAT'
   FROM DISK= @dZGOlD_BAK_NAME
   WITH RECOVERY
-------------------------------

--  USE MSDE INSTALL NEO-X DATABASE
use [master]
go

--  데이터베이스파일이 있는 폴더주소를 지정하는데 환경에 맞게 수정해야됩니다.
--  根据数据库存放位子,修改路径.
--sp_attach_db N'dZGOlD', N'F:\ERPX_db\dZGOlD.DAT',N'F:\ERPX_db\dZGOlDLOG.DAT'
--go
use [dZGOlD]
go

--  사용자추가
sp_addlogin 'dZGOlD','dZGOlD','dZGOlD'
go

use [dZGOlD]
go
exec sp_dbcmptlevel N'dZGOlD'
go
use [dZGOlD]
go
exec sp_defaultlanguage N'dZGOlD'
go
use [dZGOlD]
go
exec sp_defaultdb N'dZGOlD', N'dZGOlD'
go
use [dZGOlD]
go

--  사용자변경
SP_CHANGE_USERS_LOGIN 'UPDATE_ONE', 'dZGOlD', 'dZGOlD'
GO

-- CHANGE SA PASSWORD -- SA PASSWORD IS IMPUTY -- SA 암호가 없을때 암호설치 NEW_PASSWORD를 대응암호로 변경
-- exec sp_password NULL,'NEW_PASSWORD','Victoria'
-- GO

-- CHANGE SA PASSWORD -- SA PASSWORD IS existed -- SA 암호가 있을때 다른 암호로변경
-- EXEC SP_PASSWORD 'OLD_PASSWORD','NEW_PASSWORD'
-- GO

---------------------------------------------------------------------------------------