Know/DATABASE
[mssql] 복구 스크립트
Marine™
2006. 10. 20. 14:31
반응형
EXEC sp_attach_single_file_db 'maildbktf', 'D:\enomix5.3_KTCHAT\dbf\maildbktf_sys.mdf'
EXEC sp_attach_single_file_db 'selfdbktf', 'D:\enomix5.3_KTCHAT\dbf\selfdbktf_sys.mdf'
USER LOGIN 변경
EXEC sp_change_users_login 'Update_One', 'selfktf', 'selfktf'
EXEC sp_attach_single_file_db 'selfdbktf', 'D:\enomix5.3_KTCHAT\dbf\selfdbktf_sys.mdf'
USER LOGIN 변경
EXEC sp_change_users_login 'Update_One', 'selfktf', 'selfktf'
반응형