http://blog.naver.com/jicany/140053698688
ȸ翡 ϰ ִ SQL Server 2000
SQL Server 2008 ȹ ־ ߿ κ
ȹ Ʈ ߿ ֽϴ.
SQL Server 2008 ̵Ű ڽϴ.
SQL Server 2000 SQL Server 2008 ̵ ϹǷ
SQL Server 2005 SQL Server 2008 ̵ ϰ? ^^(
̵
[1/2] SQL Server 2000 (2005) SQL Server 2008 ̵
1. [] ǮϷ ̵Ű
2. [] MDF,LDF ̵Ű
[2/2] SQL Server 2000 (2005) SQL Server 2008 ̵
3. [ũƮ] ǮϷ ̵Ű
4. [ũƮ] MDF,LDF ̵Ű
|
1. [] ǮϷ ̵ Ű
1) SQL Server 2000 ͺ̽ ǮѴ.
(KSD ̸ ͺ̽ Ͽ.)
2) SQL Server 2008 ̵Ų.
(C:KSD.bak ġ״.)
3) SQL Server 2008 Ѵ.
A) ͺ̽ -> ʸ콺 Ŭ "
ͺ̽ (R)"
B) ͺ̽ ȭ "Ϲ"
a. ͺ̽ ̸ ԷѴ (KSD)
b. "ġ(D)" ϰ ġ Ѵ.
c. Ʈ Ѵ (check box ).
d. "ɼ" ŬѴ.
C) ͺ̽ ȭ ""
a. ͺ̽ " ͺ̽ " Ѵ.
(ʿ ɼ Ѵ.)
b. ͺ̽ ġ ԷѴ.
( ϰ α ġ ٸ Ҽ ִ.)
c. ¸ Ѵ.
d. "Ȯ" ư () Ѵ.
D) ͺ̽ ϷḦ ȮѴ.
a. "Ȯ" ư .
4) ͺ̽ "Ӽ" ȮѴ.
A) ȣȯ Ȯ
KSD ͺ̽ ϰ 콺 Ŭ ߿ "Ӽ" ϰ "ɼ" ŬѴ.
SQL Server 2000 ϿǷ ȣȯ "
SQL Server 2000(80)" Ǿִ.
a. ͺ̽ SQL Server 2008 ȣȯǵ Ϸ
ȣȯ "
SQL Server 2008(100)" ϰ "Ȯ" ư .
* ٸ ͺ̽ ̱ ̹Ƿ
"ɼ=>Ÿɼ => => " SINGLE_USER Ѵ ȣȯ ϰ
ϰ ٽ "MULTI_USER" Ͽ ڵ ֵ Ѵ.
b. ȣȯ SQL Server 2008
b-1. ALTER DATABASE SET SINGLE_USER Ͽ ͺ̽ մϴ.
b-2. ͺ̽ ȣȯ մϴ.
b-3. ALTER DATABASE SET MULTI_USER Ͽ ͺ̽ մϴ.
USE master
ALTER DATABASE KSD SET SINGLE_USER <?xml:namespace prefix = "o" />
ALTER DATABASE KSD
SET COMPATIBILITY_LEVEL = 100
ALTER DATABASE KSD SET MULTI_USER
|
ALTER DATABASE ͺ̽
SET COMPATIBILITY_LEVEL = 100
COMPATIBILITY_LEVEL { 80 | 90 | 100 }
ͺ̽ ȣȯǵ SQL Server Դϴ. ϳ մϴ.
80 = SQL Server 2000
90 = SQL Server 2005
100 = SQL Server 2008
|
2. [] MDF,LDF ̵Ű
1) SQL Server 2000 ߽ýŲ.
( ̸ ī .)
KSD.mdf , KSD_Log.LDF īϿ.
2) SQL Server 2008 ͺ̽ Ѵ.
A) SQL Server 2008 ͺ̽ mdf,ldf ġ īѴ.
B) ͺ̽ -> ʸ콺 Ŭ "(A)" .
C) ͺ̽ ۾.
a. "߰" ư ī mdf Ѵ(KSD.mdf)
߰ ϰ Ǹ Ʒ "KSD" ͺ̽ (T) ڵ Էµȴ.
b. "Ȯ" ư KSD ͺ̽ Ѵ.
c. ͺ̽ Ϸȴ.
3) ͺ̽ "Ӽ" ȮѴ.
A) ȣȯ Ȯ
KSD ͺ̽ ϰ 콺 Ŭ ߿ "Ӽ" ϰ "ɼ" ŬѴ.
SQL Server 2000 ϿǷ ȣȯ "SQL Server 2000(80)" Ǿִ.
a. ͺ̽ SQL Server 2008 ȣȯǵ Ϸ
ȣȯ "SQL Server 2008(100)" ϰ "Ȯ" ư .
* ٸ ͺ̽ ̱ ̹Ƿ
"ɼ=>Ÿɼ => => " SINGLE_USER Ѵ ȣȯ ϰ
ϰ ٽ "MULTI_USER" Ͽ ڵ ֵ Ѵ.