--------------------备份数据库文件恢复1---------------------------------------------------------------
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      = 'F:\ERPX_DB\temp\2006042615_DZGOLD.DAT'  --备份数据库文件路径及文件名称
set @DZGOLD_BAK_DATA_NAME = 'F:\ERPX_DB\temp\DZGOLD.DAT'	     --恢复数据库数据文件路径及文件名称
set @DZGOLD_BAK_LOG_NAME  = 'F:\ERPX_DB\temp\DZGOLDLOG.DAT'	     --恢复数据库日志文件路径及文件名称
-- 需要修改部分结束

RESTORE DATABASE DZGOLD_bak 
   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_bak
--   FROM DISK= 'F:\ERPX_DB\temp\2006042615_DZGOLD.DAT'
   FROM DISK= @DZGOLD_BAK_NAME
   WITH RECOVERY
----------------------------------------------------------------------------------------------------

--------------------备份数据库文件恢复2---------------------------------
RESTORE DATABASE DZGOLD_bak
   FROM DISK='F:\ERPX_DB\temp\2006042615_DZGOLD.DAT'
   WITH NORECOVERY, 
      MOVE 'DZ_GOLD' TO 'F:\ERPX_DB\temp\DZGOLD.DAT', 
      MOVE 'DZ_GOLDLog' TO 'F:\ERPX_DB\temp\DZGOLDLOG.DAT'

RESTORE LOG DZGOLD_bak
   FROM DISK='F:\ERPX_DB\temp\2006042615_DZGOLD.DAT'
   WITH RECOVERY
----------------------------------------------------------


select * from DZGOLD_bak.dzgold.sacct


UPDATE DZGOLD.DZGOLD.SACCT SET PRT_NMK = A.PRT_NMK
FROM DZGOLD.DZGOLD.SACCT S, (SELECT CO_CD,ACCT_CD, PRT_NMK FROM DZGOLD_BAK.DZGOLD.SACCT) A
WHERE S.CO_CD = A.CO_CD AND S.ACCT_CD = A.ACCT_CD

UPDATE DZGOLD.DZGOLD.SACCT SET ACCT_NMK = A.ACCT_NMK
FROM DZGOLD.DZGOLD.SACCT S, (SELECT CO_CD,ACCT_CD, ACCT_NMK FROM DZGOLD_BAK.DZGOLD.SACCT) A
WHERE S.CO_CD = A.CO_CD AND S.ACCT_CD = A.ACCT_CD


--分离数据库
use [master]
go
EXEC sp_detach_db 'DZGOLD_BAK', 'true'




-------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
-------------------- 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      = 'F:\ERPX_DB\2007062514_DZGOLD.DAT'  --备份数据库文件路径及文件名称
set @DZGOLD_BAK_DATA_NAME = 'F:\ERPX_DB\DZGOLD.DAT'	     --恢复数据库数据文件路径及文件名称
set @DZGOLD_BAK_LOG_NAME  = 'F:\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

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