dbms:mssql:recovery:user

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- dbms:mssql:recovery:user [2016/09/23 09:52]
starlits [TDE 적용]
+++ dbms:mssql:recovery:user [2016/09/23 09:56] (현재)
starlits [예정정보]
@@ 줄 11: / 줄 11: @@
 ^ Backup File | d:\backup\admin_20160923.bak |
 ^ Recovery Directory | d:\MSSQL\ADMIN\ |
-^ Database Name | admindb |
+^ Database Name | **admindb** |
-^ Database User | db_manager |
+^ Database User | **db_manager** |
-^ Database Password | 12345a |
+^ Database Password | **12345a** |
@@ 줄 28: / 줄 28: @@
 	DECRYPTION BY PASSWORD = 'abcde1'
 );
+GO
+</code>
+==== 복구 ====
+  - HOWTO <code>
+-- We have the correct certificate and we've also restored the
+-- private key. Now everything should work. Finally!
+restore DATABASE [admindb]
+FROM disk= N'D:\backup\admindb_20160923.bak'
+WITH move 'admindb' TO N'D:\MSSQL\ADMIN\admindb_data.mdf',
+     move 'admindb_log' TO N'D:\MSSQL\ADMIN\admindb_data_log.ldf';
 GO
 </code>

dbms/mssql/recovery/user.1474591962.txt.gz · 마지막으로 수정됨: 2016/09/23 09:52 저자 starlits