SQL Server
한국(한국어) 로그인
홈 2012 2008 R2 2008 이전 버전 라이브러리 포럼
TechNet 라이브러리
SQL Server
SQL Server 2005
제품 설명서
SQL Server 2005 설명서
SQL Server 2005 온라인 설명서
SQL Server 언어 참조
Transact-SQL 참조
Transact-SQL 구문 규칙(Transact-SQL)
Transact-SQL의 새로운 기능 및 향상된 기능(Transact-SQL)
+(더하기)(Transact-SQL)
+(단항 더하기)(Transact-SQL)
+(문자열 연결)(Transact-SQL)
-(음수)(Transact-SQL)
-(빼기)(Transact-SQL)
*(곱하기)(Transact-SQL)
/(나누기)(Transact-SQL)
%(모듈로)(Transact-SQL)
%(와일드카드 - 일치하는 문자)(Transact-SQL)
&(비트 AND)(Transact-SQL)
|(비트 OR)(Transact-SQL)
^(배타적 비트 OR)(Transact-SQL)
~(비트 NOT)(Transact-SQL)
=(같음)(Transact-SQL)
>(보다 큼)(Transact-SQL)
<(보다 작음)(Transact-SQL)
>=(크거나 같음)(Transact-SQL)
<=(작거나 같음)(Transact-SQL)
<>(같지 않음)(Transact-SQL)
!<(보다 작지 않음)(Transact-SQL)
!= (같지 않음)(Transact-SQL)
!>(보다 크지 않음)(Transact-SQL)
-- (주석)(Transact-SQL)
/*...*/(주석)(Transact-SQL)
[ ](와일드카드 - 일치하는 문자)(Transact-SQL)
[^](와일드카드 - 일치하지 않는 문자)(Transact-SQL)
_ (와일드카드 - 문자 하나와 일치)(Transact-SQL)
$PARTITION(Transact-SQL)
@@CONNECTIONS(Transact-SQL)
@@CPU_BUSY(Transact-SQL)
@@CURSOR_ROWS(Transact-SQL)
@@DATEFIRST(Transact-SQL)
@@DBTS(Transact-SQL)
@@ERROR(Transact-SQL)
@@FETCH_STATUS(Transact-SQL)
@@IDENTITY(Transact-SQL)
@@IDLE(Transact-SQL)
@@IO_BUSY(Transact-SQL)
@@LANGID(Transact-SQL)
@@LANGUAGE(Transact-SQL)
@@LOCK_TIMEOUT(Transact-SQL)
@@MAX_CONNECTIONS(Transact-SQL)
@@MAX_PRECISION(Transact-SQL)
@@NESTLEVEL(Transact-SQL)
@@OPTIONS(Transact-SQL)
@@PACK_RECEIVED(Transact-SQL)
@@PACK_SENT(Transact-SQL)
@@PACKET_ERRORS(Transact-SQL)
@@PROCID(Transact-SQL)
@@REMSERVER(Transact-SQL)
@@ROWCOUNT(Transact-SQL)
@@SERVERNAME(Transact-SQL)
@@SERVICENAME(Transact-SQL)
@@SPID(Transact-SQL)
@@TEXTSIZE(Transact-SQL)
@@TIMETICKS(Transact-SQL)
@@TOTAL_ERRORS(Transact-SQL)
@@TOTAL_READ(Transact-SQL)
@@TOTAL_WRITE(Transact-SQL)
@@TRANCOUNT(Transact-SQL)
@@VERSION(Transact-SQL)
ABS(Transact-SQL)
ACOS(Transact-SQL)
ADD SIGNATURE(Transact-SQL)
ALL(Transact-SQL)
ALTER APPLICATION ROLE(Transact-SQL)
ALTER ASSEMBLY(Transact-SQL)
ALTER ASYMMETRIC KEY(Transact-SQL)
ALTER AUTHORIZATION(Transact-SQL)
ALTER CERTIFICATE(Transact-SQL)
ALTER CREDENTIAL(Transact-SQL)
ALTER DATABASE(Transact-SQL)
ALTER ENDPOINT(Transact-SQL)
ALTER FULLTEXT CATALOG(Transact-SQL)
ALTER FULLTEXT INDEX(Transact-SQL)
ALTER FUNCTION(Transact-SQL)
ALTER INDEX(Transact-SQL)
ALTER LOGIN(Transact-SQL)
ALTER MASTER KEY(Transact-SQL)
ALTER MESSAGE TYPE(Transact-SQL)
ALTER PARTITION FUNCTION(Transact-SQL)
ALTER PARTITION SCHEME(Transact-SQL)
ALTER PROCEDURE(Transact-SQL)
ALTER QUEUE(Transact-SQL)
ALTER REMOTE SERVICE BINDING(Transact-SQL)
ALTER ROLE(Transact-SQL)
ALTER ROUTE(Transact-SQL)
ALTER SCHEMA(Transact-SQL)
ALTER SERVICE(Transact-SQL)
ALTER SERVICE MASTER KEY(Transact-SQL)
ALTER SYMMETRIC KEY(Transact-SQL)
ALTER TABLE(Transact-SQL)
ALTER TRIGGER(Transact-SQL)
ALTER USER(Transact-SQL)
ALTER VIEW(Transact-SQL)
ALTER XML SCHEMA COLLECTION(Transact-SQL)
AND(Transact-SQL)
ANY(Transact-SQL)
APPLOCK_MODE(Transact-SQL)
APPLOCK_TEST(Transact-SQL)
APP_NAME(Transact-SQL)
ASCII(Transact-SQL)
ASIN(Transact-SQL)
ASSEMBLYPROPERTY(Transact-SQL)
AsymKey_ID(Transact-SQL)
ATAN(Transact-SQL)
ATN2(Transact-SQL)
AVG(Transact-SQL)
BACKUP(Transact-SQL)
BACKUP CERTIFICATE(Transact-SQL)
BACKUP MASTER KEY(Transact-SQL)
BACKUP SERVICE MASTER KEY(Transact-SQL)
BEGIN...END(Transact-SQL)
BEGIN CONVERSATION TIMER(Transact-SQL)
BEGIN DIALOG CONVERSATION(Transact-SQL)
BEGIN DISTRIBUTED TRANSACTION(Transact-SQL)
BEGIN TRANSACTION(Transact-SQL)
BETWEEN(Transact-SQL)
binary 및 varbinary(Transact-SQL)
BINARY_CHECKSUM
bit(Transact-SQL)
BREAK(Transact-SQL)
BULK INSERT(Transact-SQL)
CASE(Transact-SQL)
CAST 및 CONVERT(Transact-SQL)
CATCH (TRY...CATCH)(Transact-SQL)
CEILING(Transact-SQL)
CertProperty(Transact-SQL)
Cert_ID(Transact-SQL)
char 및 varchar(Transact-SQL)
CHAR(Transact-SQL)
CHARINDEX(Transact-SQL)
CHECKPOINT(Transact-SQL)
CHECKSUM(Transact-SQL)
CHECKSUM_AGG(Transact-SQL)
CLOSE(Transact-SQL)
CLOSE MASTER KEY(Transact-SQL)
CLOSE SYMMETRIC KEY(Transact-SQL)
COALESCE(Transact-SQL)
COLLATE(Transact-SQL)
COLLATIONPROPERTY(Transact-SQL)
COL_LENGTH(Transact-SQL)
COL_NAME(Transact-SQL)
COLUMNPROPERTY(Transact-SQL)
COLUMNS_UPDATED(Transact-SQL)
COMMIT TRANSACTION(Transact-SQL)
COMMIT WORK(Transact-SQL)
COMPUTE(Transact-SQL)
상수(Transact-SQL)
CONTAINS(Transact-SQL)
CONTAINSTABLE(Transact-SQL)
CONTEXT_INFO(Transact-SQL)
CONTINUE(Transact-SQL)
흐름 제어 언어(Transact-SQL)
CONVERT(Transact-SQL)
COS(Transact-SQL)
COT(Transact-SQL)
COUNT(Transact-SQL)
COUNT_BIG(Transact-SQL)
CREATE AGGREGATE(Transact-SQL)
CREATE APPLICATION ROLE(Transact-SQL)
CREATE ASSEMBLY(Transact-SQL)
CREATE ASYMMETRIC KEY(Transact-SQL)
CREATE CERTIFICATE(Transact-SQL)
CREATE CONTRACT(Transact-SQL)
CREATE CREDENTIAL(Transact-SQL)
CREATE DATABASE(Transact-SQL)
CREATE DEFAULT(Transact-SQL)
CREATE ENDPOINT(Transact-SQL)
CREATE EVENT NOTIFICATION(Transact-SQL)
CREATE FULLTEXT CATALOG(Transact-SQL)
CREATE FULLTEXT INDEX(Transact-SQL)
CREATE FUNCTION(Transact-SQL)
CREATE INDEX(Transact-SQL)
CREATE LOGIN(Transact-SQL)
CREATE MASTER KEY(Transact-SQL)
CREATE MESSAGE TYPE(Transact-SQL)
CREATE PARTITION FUNCTION(Transact-SQL)
CREATE PARTITION SCHEME(Transact-SQL)
CREATE PROCEDURE(Transact-SQL)
CREATE QUEUE(Transact-SQL)
CREATE REMOTE SERVICE BINDING(Transact-SQL)
CREATE ROLE(Transact-SQL)
CREATE ROUTE(Transact-SQL)
CREATE RULE(Transact-SQL)
CREATE SCHEMA(Transact-SQL)
CREATE SERVICE(Transact-SQL)
CREATE STATISTICS(Transact-SQL)
CREATE SYMMETRIC KEY(Transact-SQL)
CREATE SYNONYM(Transact-SQL)
CREATE TABLE(Transact-SQL)
CREATE TRIGGER(Transact-SQL)
CREATE TYPE(Transact-SQL)
CREATE USER(Transact-SQL)
CREATE VIEW(Transact-SQL)
CREATE XML SCHEMA COLLECTION(Transact-SQL)
CURRENT_REQUEST_ID(Transact-SQL)
CURRENT_TIMESTAMP(Transact-SQL)
CURRENT_USER(Transact-SQL)
SET(Transact-SQL)
CURSOR_STATUS(Transact-SQL)
커서(Transact-SQL)
DATABASEPROPERTY(Transact-SQL)
DATABASEPROPERTYEX(Transact-SQL)
DATABASE_PRINCIPAL_ID(Transact-SQL)
데이터 형식(Transact-SQL)
DATALENGTH(Transact-SQL)
DATEADD(Transact-SQL)
DATEDIFF(Transact-SQL)
DATENAME(Transact-SQL)
DATEPART(Transact-SQL)
날짜 및 시간(Transact-SQL)
DAY(Transact-SQL)
DB_ID(Transact-SQL)
DB_NAME(Transact-SQL)
DBCC(Transact-SQL)
DEALLOCATE(Transact-SQL)
decimal 및 numeric(Transact-SQL)
DECLARE @local_variable(Transact-SQL)
DECLARE CURSOR(Transact-SQL)
DecryptByAsymKey(Transact-SQL)
DecryptByCert(Transact-SQL)
DecryptByKey(Transact-SQL)
DecryptByKeyAutoAsymKey(Transact-SQL)
DecryptByKeyAutoCert(Transact-SQL)
DecryptByPassPhrase(Transact-SQL)
DEGREES(Transact-SQL)
DELETE(Transact-SQL)
DENSE_RANK(Transact-SQL)
DENY(Transact-SQL)
DIFFERENCE(Transact-SQL)
DISABLE TRIGGER(Transact-SQL)
DROP AGGREGATE(Transact-SQL)
DROP APPLICATION ROLE(Transact-SQL)
DROP ASSEMBLY(Transact-SQL)
DROP ASYMMETRIC KEY(Transact-SQL)
DROP CERTIFICATE(Transact-SQL)
DROP CONTRACT(Transact-SQL)
DROP CREDENTIAL(Transact-SQL)
DROP DATABASE(Transact-SQL)
DROP DEFAULT(Transact-SQL)
DROP ENDPOINT(Transact-SQL)
DROP EVENT NOTIFICATION(Transact-SQL)
DROP FULLTEXT CATALOG(Transact-SQL)
DROP FULLTEXT INDEX(Transact-SQL)
DROP FUNCTION(Transact-SQL)
DROP INDEX(Transact-SQL)
DROP LOGIN(Transact-SQL)
DROP MASTER KEY(Transact-SQL)
DROP MESSAGE TYPE(Transact-SQL)
DROP PARTITION FUNCTION(Transact-SQL)
DROP PARTITION SCHEME(Transact-SQL)
DROP PROCEDURE(Transact-SQL)
DROP QUEUE(Transact-SQL)
DROP REMOTE SERVICE BINDING(Transact-SQL)
DROP ROLE(Transact-SQL)
DROP ROUTE(Transact-SQL)
DROP RULE(Transact-SQL)
DROP SCHEMA(Transact-SQL)
DROP SERVICE(Transact-SQL)
DROP SIGNATURE(Transact-SQL)
DROP STATISTICS(Transact-SQL)
DROP SYMMETRIC KEY(Transact-SQL)
DROP SYNONYM(Transact-SQL)
DROP TABLE(Transact-SQL)
DROP TRIGGER(Transact-SQL)
DROP TYPE(Transact-SQL)
DROP USER(Transact-SQL)
DROP VIEW(Transact-SQL)
DROP XML SCHEMA COLLECTION(Transact-SQL)
DUMP(Transact-SQL)
ELSE(IF...ELSE)(Transact-SQL)
ENABLE TRIGGER(Transact-SQL)
EncryptByAsymKey(Transact-SQL)
EncryptByCert(Transact-SQL)
EncryptByKey(Transact-SQL)
EncryptByPassPhrase(Transact-SQL)
END(BEGIN...END)(Transact-SQL)
END CONVERSATION(Transact-SQL)
ERROR_LINE(Transact-SQL)
ERROR_MESSAGE(Transact-SQL)
ERROR_NUMBER(Transact-SQL)
ERROR_PROCEDURE(Transact-SQL)
ERROR_SEVERITY(Transact-SQL)
ERROR_STATE(Transact-SQL)
EVENTDATA(Transact-SQL)
EXCEPT 및 INTERSECT(Transact-SQL)
EXECUTE AS(Transact-SQL)
EXECUTE AS 절(Transact-SQL)
EXECUTE(Transact-SQL)
EXISTS(Transact-SQL)
EXP(Transact-SQL)
식(Transact-SQL)
FETCH(Transact-SQL)
FILE_ID(Transact-SQL)
FILE_IDEX(Transact-SQL)
FILE_NAME(Transact-SQL)
FILEGROUP_ID(Transact-SQL)
FILEGROUP_NAME(Transact-SQL)
FILEGROUPPROPERTY(Transact-SQL)
FILEPROPERTY(Transact-SQL)
float 및 real(Transact-SQL)
FLOOR(Transact-SQL)
fn_get_sql(Transact-SQL)
fn_helpcollations(Transact-SQL)
fn_listextendedproperty(Transact-SQL)
fn_my_permissions(Transact-SQL)
fn_servershareddrives(Transact-SQL)
fn_trace_geteventinfo(Transact-SQL)
fn_trace_getfilterinfo(Transact-SQL)
fn_trace_getinfo(Transact-SQL)
fn_trace_gettable(Transact-SQL)
fn_virtualfilestats(Transact-SQL)
fn_virtualservernodes(Transact-SQL)
FOR 절(Transact-SQL)
FORMATMESSAGE(Transact-SQL)
FREETEXT(Transact-SQL)
FREETEXTTABLE(Transact-SQL)
FROM(Transact-SQL)
FULLTEXTCATALOGPROPERTY(Transact-SQL)
FULLTEXTSERVICEPROPERT(Transact-SQL)
함수(Transact-SQL)
GET CONVERSATION GROUP(Transact-SQL)
GET_TRANSMISSION_STATUS(Transact-SQL)
GETANSINULL(Transact-SQL)
GETDATE(Transact-SQL)
GETUTCDATE(Transact-SQL)
GO(Transact-SQL)
GOTO(Transact-SQL)
GRANT(Transact-SQL)
GROUP BY(Transact-SQL)
GROUPING(Transact-SQL)
HAS_DBACCESS(Transact-SQL)
Has_Perms_By_Name(Transact-SQL)
HashBytes(Transact-SQL)
HAVING(Transact-SQL)
힌트(Transact-SQL)
HOST_ID(Transact-SQL)
HOST_NAME(Transact-SQL)
IDENT_CURRENT(Transact-SQL)
IDENT_INCR(Transact-SQL)
IDENT_SEED(Transact-SQL)
IDENTITY(함수)(Transact-SQL)
IDENTITY(속성)(Transact-SQL)
IF...ELSE(Transact-SQL)
image(Transact-SQL)
IN(Transact-SQL)
INDEXKEY_PROPERTY(Transact-SQL)
NDEXPROPERTY(Transact-SQL)
INDEX_COL(Transact-SQL)
INSERT(Transact-SQL)
int, bigint, smallint 및 tinyint(Transact-SQL)
INTO 절(Transact-SQL)
IS_MEMBER(Transact-SQL)
IS_SRVROLEMEMBER(Transact-SQL)
ISDATE(Transact-SQL)
IS [NOT] NULL(Transact-SQL)
ISNULL(Transact-SQL)
ISNUMERIC(Transact-SQL)
Key_GUID(Transact-SQL)
Key_ID(Transact-SQL)
KILL(Transact-SQL)
KILL QUERY NOTIFICATION SUBSCRIPTION(Transact-SQL)
KILL STATS JOB(Transact-SQL)
LEFT(Transact-SQL)
LEN(Transact-SQL)
LIKE(Transact-SQL)
LOAD(Transact-SQL)
LOG(Transact-SQL)
LOG10(Transact-SQL)
LOGINPROPERTY(Transact-SQL)
LOWER(Transact-SQL)
LTRIM(Transact-SQL)
MAX(Transact-SQL)
MIN(Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transact-SQL)
money 및 smallmoney(Transact-SQL)
MONTH(Transact-SQL)
MOVE CONVERSATION(Transact-SQL)
NCHAR(Transact-SQL)
nchar 및 nvarchar(Transact-SQL)
NEWID(Transact-SQL)
NEWSEQUENTIALID()
NOT(Transact-SQL)
ntext, text 및 image(Transact-SQL)
NTILE(Transact-SQL)
NULLIF(Transact-SQL)
numeric(Transact-SQL)
OBJECT_DEFINITION(Transact-SQL)
OBJECT_ID(Transact-SQL)
OBJECT_NAME(Transact-SQL)
OBJECT_SCHEMA_NAME(Transact-SQL)
OBJECTPROPERTY(Transact-SQL)
OBJECTPROPERTYEX(Transact-SQL)
OPEN(Transact-SQL)
OPEN MASTER KEY(Transact-SQL)
OPEN SYMMETRIC KEY(Transact-SQL)
OPENDATASOURCE(Transact-SQL)
OPENQUERY(Transact-SQL)
OPENROWSET(Transact-SQL)
OPENXML(Transact-SQL)
연산자(Transact-SQL)
OPTION 절(Transact-SQL)
OR(Transact-SQL)
ORDER BY 절(Transact-SQL)
ORIGINAL_LOGIN(Transact-SQL)
OUTPUT 절(Transact-SQL)
OVER 절(Transact-SQL)
PARSENAME(Transact-SQL)
PATINDEX(Transact-SQL)
PERMISSIONS(Transact-SQL)
PI(Transact-SQL)
POWER(Transact-SQL)
조건자(Transact-SQL)
PRINT(Transact-SQL)
PUBLISHINGSERVERNAME(Transact-SQL)
QUOTENAME(Transact-SQL)
RADIANS(Transact-SQL)
RAISERROR(Transact-SQL)
RAND(Transact-SQL)
RANK(Transact-SQL)
READTEXT(Transact-SQL)
real(Transact-SQL)
RECEIVE(Transact-SQL)
RECONFIGURE(Transact-SQL)
REPLACE(Transact-SQL)
REPLICATE(Transact-SQL)
예약된 키워드(Transact-SQL)
백업 복원, 복구 및 관리를 위한 RESTORE 문
RESTORE MASTER KEY(Transact-SQL)
RESTORE SERVICE MASTER KEY(Transact-SQL)
RETURN(Transact-SQL)
REVERSE(Transact-SQL)
REVERT(Transact-SQL)
REVOKE(Transact-SQL)
RIGHT(Transact-SQL)
ROLLBACK TRANSACTION(Transact-SQL)
ROLLBACK WORK(Transact-SQL)
ROUND(Transact-SQL)
ROWCOUNT_BIG(Transact-SQL)
ROW_NUMBER(Transact-SQL)
RTRIM(Transact-SQL)
SAVE TRANSACTION(Transact-SQL)
SCHEMA_ID(Transact-SQL)
SCHEMA_NAME(Transact-SQL)
SCOPE_IDENTITY(Transact-SQL)
검색 조건(Transact-SQL)
SELECT @local_variable(Transact-SQL)
SELECT(Transact-SQL)
SEND(Transact-SQL)
SERVERPROPERTY(Transact-SQL)
SESSION_USER(Transact-SQL)
SESSIONPROPERTY(Transact-SQL)
SET @local_variable(Transact-SQL)
SET(Transact-SQL)
SETUSER(Transact-SQL)
SHUTDOWN(Transact-SQL)
SIGN(Transact-SQL)
SignByAsymKey(Transact-SQL)
SignByCert(Transact-SQL)
SIN(Transact-SQL)
smalldatetime(Transact-SQL)
smallint(Transact-SQL)
smallmoney(Transact-SQL)
SOME | ANY(Transact-SQL)
SOUNDEX(Transact-SQL)
SPACE(Transact-SQL)
sql_variant(Transact-SQL)
SQL_VARIANT_PROPERTY(Transact-SQL)
SQRT(Transact-SQL)
SQUARE(Transact-SQL)
STATS_DATE(Transact-SQL)
STDEV(Transact-SQL)
STDEVP(Transact-SQL)
STR(Transact-SQL)
STUFF(Transact-SQL)
SUBSTRING(Transact-SQL)
SUM(Transact-SQL)
SUSER_ID(Transact-SQL)
SUSER_NAME(Transact-SQL)
SUSER_SID(Transact-SQL)
SUSER_SNAME(Transact-SQL)
시스템 저장 프로시저(Transact-SQL)
시스템 테이블(Transact-SQL)
시스템 뷰(Transact-SQL)
sys.fn_builtin_permissions(Transact-SQL)
sys.fn_translate_permissions(Transact-SQL)
sys.login_token(Transact-SQL)
sys.user_token(Transact-SQL)
SYSTEM_USER(Transact-SQL)
table(Transact-SQL)
TAN(Transact-SQL)
TERTIARY_WEIGHTS
text(Transact-SQL)
TEXTPTR(Transact-SQL)
TEXTVALID(Transact-SQL)
timestamp(Transact-SQL)
tinyint(Transact-SQL)
TOP(Transact-SQL)
추적 플래그(Transact-SQL)
트랜잭션(Transact-SQL)
TRY...CATCH(Transact-SQL)
TRIGGER_NESTLEVEL(Transact-SQL)
TRUNCATE TABLE(Transact-SQL)
TYPE_ID(Transact-SQL)
TYPE_NAME(Transact-SQL)
TYPEPROPERTY(Transact-SQL)
UNICODE(Transact-SQL)
UNION(Transact-SQL)
uniqueidentifier(Transact-SQL)
UPDATE(Transact-SQL)
UPDATE()(Transact-SQL)
UPDATE STATISTICS(Transact-SQL)
UPDATETEXT(Transact-SQL)
UPPER(Transact-SQL)
USE(Transact-SQL)
USER(Transact-SQL)
USER_ID(Transact-SQL)
USER_NAME(Transact-SQL)
VAR(Transact-SQL)
varbinary(Transact-SQL)
varchar(Transact-SQL)
VARP(Transact-SQL)
VerifySignedByCert(Transact-SQL)
VerifySignedByAsmKey(Transact-SQL)
WAITFOR(Transact-SQL)
WHERE(Transact-SQL)
WHILE(Transact-SQL)
WITH common_table_expression(Transact-SQL)
WITH XMLNAMESPACES(Transact-SQL)
WRITETEXT(Transact-SQL)
XACT_STATE(Transact-SQL)
xml(Transact-SQL)
xml_schema_namespace(Transact-SQL)
YEAR(Transact-SQL)
확장 최소화
이 항목은 아직 평가되지 않았습니다.- 이 항목 평가

BACKUP MASTER KEY(Transact-SQL)

SQL Server 2005

데이터베이스 마스터 키를 내보냅니다.

항목 링크 아이콘 Transact-SQL 구문 표기 규칙

복사 

BACKUP MASTER KEY TO FILE = 'path_to_file' 
    ENCRYPTION BY PASSWORD = 'password'
FILE = 'path_to_file'

마스터 키를 내보낼 파일에 대한 파일 이름을 포함한 전체 경로를 지정합니다. 이 경로는 로컬 경로 또는 네트워크 위치에 대한 UNC 경로일 수 있습니다.

PASSWORD = 'password'

파일의 마스터 키를 암호화하는 데 사용되는 암호입니다. 이 암호의 복잡성을 확인해야 합니다. 자세한 내용은 암호 정책을 참조하십시오.

마스터 키를 열어야 하기 때문에 백업하기 전에 암호를 해독해야 합니다. 서비스 마스터 키를 사용하여 암호화된 경우 마스터 키를 명시적으로 열 필요가 없습니다. 하지만 마스터 키가 암호로만 암호화된 경우 명시적으로 열어야 합니다.

마스터 키는 만들자 마자 백업하고 외부의 안전한 위치에 보관하는 것이 좋습니다.

데이터베이스에 대한 CONTROL 권한이 필요합니다.

다음 예에서는 AdventureWorks 마스터 키의 백업을 만듭니다. 이 마스터 키는 서비스 마스터 키로 암호화되지 않았기 때문에 마스터 키를 열려면 암호를 지정해야 합니다.

복사 
USE AdventureWorks;
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'sfj5300osdVdgwdfkli7';
BACKUP MASTER KEY TO FILE = 'c:\temp\exportedmasterkey' 
    ENCRYPTION BY PASSWORD = 'sd092735kjn$&adsg';
GO
이 정보가 도움이 되었습니까?
(1500자 남음)

커뮤니티 추가 항목

추가
© 2013 Microsoft
|
사이트 의견
© 2013 Microsoft. All rights reserved.