b? my c s? d? li?u t? m?t phin b?n c? c?a SQL Server s? tr? thnh khng s? d?ng ?c khi b?n nh km n vo m?t th? hi?n c?a SQL Server 2012

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2710782 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

TRI?U CH?NG

H?y xem xt k?ch b?n sau y:
  • B?n ci ?t chuyn bi?t m?t th? hi?n c?a Microsoft SQL Server 2005, c?a Microsoft SQL Server 2008 hay c?a Microsoft SQL Server 2008 R2.
  • Th? hi?n c?a my ch? SQL ?c ?t tn theo INST1 v ch? b? my c s? d? li?u ?c ?t tn Test_RO_FG_DB.
  • b? my c s? d? li?u ch?a cc nhm t?p tin sau y:
    • Ti?u h?c
    • RO_FG
    • RW_FG
  • Filegroup ?c ?t tn RO_FG ?c nh d?u ki?m l READ_ONLY.
  • B?n ci ?t chuyn bi?t m?t tr?ng h?p m?i c?a Microsoft SQL Server 2012. Tr?ng h?p ny SQL Server 2012 ?c ?t tn INST2.
  • B?n tch b? my c s? d? li?u Test_RO_FG_DB t? INST1.
  • B?n th? ? nh km b? my c s? d? li?u Test_RO_FG_DB ? INST2.
  • B?n nh?n ?c m?t thng bo l?i tng t? v?i nh?ng i?u sau y:
    Msg 3415, c?p 16, bang 2, d?ng 1
    b? my c s? d? li?u 'Test_RO_FG_DB' khng th? nng c?p b?i v? n l ch?-?c, c t?p ch?-?c ho?c ng?i dng khng c quy?n ? s?a ?i m?t s? cc t?p tin. Lm cho b? my c s? d? li?u ho?c cc t?p tin c th? ghi, b?t ln v ch?y l?i ph?c h?i.
  • B?n c? g?ng ? reattach b? my c s? d? li?u Test_RO_FG_DB ? INST1.
Trong tr?ng h?p ny, b?n khng th? reattach b? my c s? d? li?u ? INST1. V, b?n nh?n ?c thng bo l?i sau y trong Nh?t k? l?i SQL Server:

2012-05-03 22:55:45.37 spid52 B?t ?u l?p b? my c s? d? li?u 'Test_RO_FG_DB'.
2012-05-03 22:55:45.78 spid52 * *******************************************************************************
2012-05-03 22:55:45.78 spid52 * B?t ?u ngn x?p b?i ch?a:
2012-05-03 22:55:45.78 spid52 * 05/03/12 22: 55: 45 spid 52
2012-05-03 22:55:45.78 spid52 * v? tr: logscan.cpp:1490
2012-05-03 22:55:45.78 spid52 * bi?u hi?n: sai
2012-05-03 22:55:45.78 spid52 * b?n ghi d?ch v? SPID: 52
2012-05-03 22:55:45.78 spid52 * qu tr?nh ID: 9156
2012-05-03 22:55:45.78 spid52 * m t?: gi tr? khng h?p l? chuy?n ?i
2012-05-03 22:55:45.78 spid52 * ?u vo b? ?m 98 byte -
2012-05-03 22:55:45.78 spid52 * lm thay ?i b? my c s? d? li?u Test_RO_FG_DB ?t tr?c tuy?n
2012-05-03 22:55:51.05 spid52 Error: 17065, m?c ? nghim tr?ng: 16, bang: 1.
2012-05-03 22:55:51.05 spid52 SQL Server kh?ng ?nh: t?p tin: <logscan.cpp>, d?ng = 1490 th?t b?i trong vi?c kh?ng ?nh = 'Gi?' khng h?p l? chuy?n gi tr?. L?i ny c th? lin quan ?n th?i gian. N?u l?i v?n c?n sau khi connectcomputer tuyn b?, s? d?ng DBCC CHECKDB ? ki?m tra b? my c s? d? li?u cho c?u trc ton v?n, ho?c kh?i ?ng l?i my ch? ? ?m b?o cc c?u trc d? li?u trong b? nh? khng b? h?ng.
2012-05-03 22:55:51.10 spid52 Error: 3624, m?c ? nghim tr?ng: 20, bang: 1.
2012-05-03 22:55:51.10 spid52 a h? th?ng ki?m tra kh?ng ?nh ? th?t b?i. Ki?m tra Nh?t k? l?i SQL Server ? bi?t chi ti?t. Thng th?ng, m?t s? th?t b?i kh?ng ?nh gy ra b?i m?t ph?n m?m l?i ho?c d? li?u tham nh?ng. ? ki?m tra cc b? my c s? d? li?u tham nh?ng, xem xt vi?c ch?y DBCC CHECKDB. N?u b?n ? ?ng ? ? g?i b?i cho Microsoft khi thi?t l?p, k?t xu?t nh? s? ?c g?i cho Microsoft. M?t b?n C?p Nh?t c th? s?n sng t? Microsoft trong Service Pack m?i nh?t ho?c trong m?t QFE t? h? tr? k? thu?t.
2012-05-03 22:56:09.16 spid52 Error: 3414, m?c ? nghim tr?ng: 21, bang: 1.
2012-05-03 22:56:09.16 spid52 m?t l?i ? x?y ra trong th?i gian ph?c h?i, ngn ch?n b? my c s? d? li?u 'Test_RO_FG_DB' (c s? d? li?u ID 19) kh?i ?ng l?i. Ch?n on cc ph?c h?i l?i v s?a ch?a chng, ho?c khi ph?c t? ?ng g?i lu t?t ?c bi?t ?n. N?u l?i khng s?a ch?a ho?c mong ?i, lin h? v?i h? tr? k? thu?t.
2012-05-03 22:56:09.18 spid52 Error: 928, m?c ? nghim tr?ng: 20, bang: 1.
2012-05-03 22:56:09.18 spid52 trong th?i gian nng c?p, b? my c s? d? li?u nu ra ngo?i l? 926, m?c ? nghim tr?ng 14, bang 1, ?a ch? 0000000000F6A971. S? ngo?i l? s? d?ng ? xc ?nh nguyn nhn.</logscan.cpp>


Lu ? V?n ? ny ch? x?y ra khi b?n c? g?ng nh km m?t b? my c s? d? li?u c ch?a m?t filegroup nh d?u ki?m READ_ONLY. V?n ? ny khng x?y ra khi b?n c? g?ng di chuy?n b? my c s? d? li?u READ_ONLY trong t?t c? cc d? li?u ?c nh d?u ki?m READ_ONLY.

NGUYN NHN

V?n ? ny x?y ra v? SQL Server 2012 khng pht hi?n filegroup ch?-?c tr?c khi n B?t ?u ? nng c?p b? my c s? d? li?u. Sau khi nng c?p ? B?t ?u, SQL Server 2012 ghi m?c Nh?t k? giao d?ch. Phin b?n tr?c khng th? ?c m?c Nh?t k? giao d?ch m?i.

T?NH TR?NG

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong cc s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".

GI?I PHP

Cumulative update C?p nh?t thng tin

SQL Server 2012

S?a ch?a cho v?n ? ny l?n ?u tin ?c pht hnh trong Cumulative Update 2 cho SQL Server 2012. ? bi?t thm chi ti?t v? gi cumulative update C?p nh?t ny, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
2703275 Tch l?y gi 2 cho SQL Server 2012
Lu ? B?i v? cc b?n xy d?ng tch l?y, m?i s?a ch?a m?i pht hnh ch?a t?t c? cc hotfix v t?t c? cc s?a l?i b?o m?t ?c bao g?m trong nm 2012 tr?c my ch? SQL S?a ch?a pht hnh. Microsoft khuy?n co b?n h?y xem xt vi?c p d?ng s?a ch?a pht hnh g?n y nh?t c ch?a hotfix ny. ? bi?t thm chi ti?t, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
2692828 SQL Server 2012 xy d?ng ?c pht hnh sau khi SQL Server 2012 ?c pht hnh
B?n ph?i p d?ng m?t hotfix SQL Server 2012 cho ti?n tr?nh ci ?t chuyn bi?t SQL Server 2012.

CCH GI?I QUY?T KHC

? lm vi?c xung quanh v?n ? ny, s? d?ng m?t trong nh?ng phng php sau y.

Phng php 1

Khi ph?c ?ng g?i lu c?a b? my c s? d? li?u t? INST1 ngy INST2.

Lu ? V?n ? ?c m t? trong ph?n "Tri?u ch?ng" khng x?y ra trong SQL Server 2012 khi b?n khi ph?c ?ng g?i lu t? m?t phin b?n c?.

Phng php 2

Th?c hi?n t?i-ch? nng c?p c?a phin b?n tr?c c?a SQL Server SQL Server 2012.

Phng php 3

Di chuy?n m?t b? my c s? d? li?u c ch?a m?t ch? ?c filegroup ? m?t th? hi?n c?a SQL Server 2012. ? th?c hi?n vi?c ny, h?y lm theo cc b?c sau.

Lu ? Th?c hi?n b?c 4 ?n 11 trn my ch? ang ch?y SQL Server 2012. V d?, th?c hi?n b?c 4 ?n 11 ngy INST2.
  1. Ngy INST1, tch b? my c s? d? li?u. V d?, tch b? my c s? d? li?u Test_RO_FG_DB.
  2. Di chuy?n t?p b? my c s? d? li?u ?n my ch? lu tr? tr?ng h?p INST2.
  3. H?y th? ? nh km b? my c s? d? li?u ? INST2. M?u m? sau y cho th?y lm th? no ? lm i?u ny:
    CREATE DATABASE [Test_RO_FG_DB] ON PRIMARY ( NAME = N'Test_RO_FG', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RO_FG.mdf' ), 
    FILEGROUP [RO_FG] ( NAME = N'Test_RO_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RO_FG_File1.ndf' ), 
    FILEGROUP [RW_FG] ( NAME = N'Test_RW_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RW_FG_File1.ndf' )
    LOG ON ( NAME = N'Test_RO_FG_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RO_FG_log.ldf' )
    FOR ATTACH;
    GO
    Lu ? B?n s? nh?n ?c cc thng bo l?i 3425 ?c ? c?p trong ph?n "Tri?u ch?ng".
  4. M?t d?u ki?m nh?c l?nh, ?i t?p ? ?t tn tin b? my c s? d? li?u. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    rename Test_RO_FG.mdf original_Test_RO_FG.mdf
    rename Test_RO_FG_File1.ndf original_Test_RO_FG_File1.ndf
    rename Test_RW_FG_File1.ndf original_Test_RW_FG_File1.ndf
    rename Test_RO_FG_log.ldf original_Test_RO_FG_log.ldf
  5. Trong SQL Server Management Studio, t?o b? my c s? d? li?u c cng tn v c c?u v?t l? nh l b? my c s? d? li?u m b?n mu?n nh km. M?u m? sau y cho th?y lm th? no ? lm i?u ny:
    CREATE DATABASE [Test_RO_FG_DB] ON PRIMARY ( NAME = N'Test_RO_FG_DB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RO_FG_DB.mdf' , SIZE = 4072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
    FILEGROUP [RO_FG] ( NAME = N'Test_RO_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RO_FG_File1.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
    FILEGROUP [RW_FG] ( NAME = N'Test_RW_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RW_FG_File1.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
    LOG ON ( NAME = N'Test_RO_FG_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\Test_RO_FG_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
    GO
  6. Thi?t l?p b? my c s? d? li?u ? gin tuy?n. ? lm i?u ny, h?y ch?y l?nh sau:
    ALTER DATABASE [Test_RO_FG_DB] SET OFFLINE
    GO
  7. M?t d?u ki?m nh?c l?nh, ?i tn cc t?p tin trong b? my c s? d? li?u m?i. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    rename Test_RO_FG.mdf new_Test_RO_FG.mdf
    rename Test_RO_FG_File1.ndf new_Test_RO_FG_File1.ndf
    rename Test_RW_FG_File1.ndf new_Test_RW_FG_File1.ndf
    rename Test_RO_FG_log.ldf new_Test_RO_FG_log.ldf
  8. M?t d?u ki?m nh?c l?nh, ?i tn cc t?p tin trong b? my c s? d? li?u m b?n di chuy?n trong b?c 2. ?i tn cc t?p tin ? ph h?p v?i b? my c s? d? li?u m b?n ? t?o ? b?c 4. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    rename original_Test_RO_FG.mdf Test_RO_FG.mdf 
    rename original_Test_RO_FG_File1.ndf Test_RO_FG_File1.ndf 
    rename original_Test_RW_FG_File1.ndf Test_RW_FG_File1.ndf 
    rename original_Test_RO_FG_log.ldf Test_RO_FG_log.ldf
  9. Thi?t l?p b? my c s? d? li?u ? ONLINE. ? lm i?u ny, h?y ch?y l?nh sau:
    ALTER DATABASE [Test_RO_FG_DB] SET ONLINE
    GO
  10. Ki?m ch?ng r?ng b? my c s? d? li?u tr?c tuy?n, v thi?t l?p l?i cc ch?c nng b?n ghi d?ch v? mi gi?i.
  11. Xa cc t?p tin b? my c s? d? li?u m khng c?n thi?t. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    del /P new_Test_RO_FG.mdf
    del /P new_Test_RO_FG_File1.ndf
    del /P new_Test_RW_FG_File1.ndf
    del /P new_Test_RO_FG_log.ldf
Method 4

Reattach b? my c s? d? li?u c ch?a m?t ch? ?c filegroup ? th? hi?n tr?c c?a SQL Server. ? th?c hi?n vi?c ny, h?y lm theo cc b?c sau.

Ghi ch
  • b? my c s? d? li?u c?ng ch?a cc giao d?ch m?i k nh?p m?c t? vi?c nng c?p th?t b?i.
  • Th?c hi?n b?c 3 thng qua 10 trn my ch? ang ch?y m?t phin b?n c? c?a SQL Server. V d?, th?c hi?n b?c 3 thng qua 10 ngy INST1.

  1. Di chuy?n t?p b? my c s? d? li?u cho tr?ng h?p my ch? SQL ?c lu tr? INST1.
  2. H?y th? ? nh km b? my c s? d? li?u ? INST1. M?u m? sau y cho th?y lm th? no ? lm i?u ny:
    CREATE DATABASE [Test_RO_FG_DB] ON PRIMARY ( NAME = N'Test_RO_FG_DB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RO_FG_DB.mdf' ), 
    FILEGROUP [RO_FG] ( NAME = N'Test_RO_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RO_FG_File1.ndf' ), 
    FILEGROUP [RW_FG] ( NAME = N'Test_RW_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RW_FG_File1.ndf' )
    LOG ON ( NAME = N'Test_RO_FG_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RO_FG_log.ldf' )
    FOR ATTACH
    GO
    Lu ? B?n s? nh?n ?c cc thng bo l?i 3624 ?c ? c?p trong ph?n "Tri?u ch?ng". B?n c?ng s? nh?n ?c m?t thng bo l?i 1813.
  3. M?t d?u ki?m nh?c l?nh, ?i t?p ? ?t tn tin b? my c s? d? li?u trn INST1. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    rename Test_RO_FG.mdf original_Test_RO_FG.mdf
    rename Test_RO_FG_File1.ndf original_Test_RO_FG_File1.ndf
    rename Test_RW_FG_File1.ndf original_Test_RW_FG_File1.ndf
    rename Test_RO_FG_log.ldf original_Test_RO_FG_log.ldf
  4. Trong SQL Server Management Studio, t?o b? my c s? d? li?u c cng tn v c c?u v?t l? nh l b? my c s? d? li?u m b?n mu?n nh km. M?u m? sau y cho th?y lm th? no ? lm i?u ny:
    CREATE DATABASE [Test_RO_FG_DB] ON PRIMARY ( NAME = N'Test_RO_FG_DB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RO_FG_DB.mdf' , SIZE = 4072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
    FILEGROUP [RO_FG] ( NAME = N'Test_RO_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RO_FG_File1.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), 
    FILEGROUP [RW_FG] ( NAME = N'Test_RW_FG_File1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RW_FG_File1.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
    LOG ON ( NAME = N'Test_RO_FG_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\DATA\Test_RO_FG_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
    GO
  5. Thi?t l?p b? my c s? d? li?u ? gin tuy?n. ? lm i?u ny, h?y ch?y l?nh sau:
    ALTER DATABASE [Test_RO_FG_DB] SET OFFLINE
    GO
  6. M?t d?u ki?m nh?c l?nh, ?i tn cc t?p tin trong b? my c s? d? li?u m?i. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    rename Test_RO_FG.mdf new_Test_RO_FG.mdf
    rename Test_RO_FG_File1.ndf new_Test_RO_FG_File1.ndf
    rename Test_RW_FG_File1.ndf new_Test_RW_FG_File1.ndf
    rename Test_RO_FG_log.ldf new_Test_RO_FG_log.ldf
  7. M?t d?u ki?m nh?c l?nh, ?i tn cc t?p tin trong b? my c s? d? li?u m b?n di chuy?n trong b?c 2. ?i tn cc t?p tin ? ph h?p v?i b? my c s? d? li?u m b?n ? t?o ? b?c 4. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    rename original_Test_RO_FG.mdf Test_RO_FG.mdf 
    rename original_Test_RO_FG_File1.ndf Test_RO_FG_File1.ndf 
    rename original_Test_RW_FG_File1.ndf Test_RW_FG_File1.ndf 
    rename original_Test_RO_FG_log.ldf Test_RO_FG_log.ldf
  8. Thi?t l?p b? my c s? d? li?u ? ch? ? kh?n c?p, v th?c hi?n m?t s?a ch?a. ? th?c hi?n vi?c ny, h?y ch?y l?nh sau y.

    Lu ? Cc b?n ghi c?a giao d?ch b? my c s? d? li?u ?c xy d?ng l?i trong b?c ny. i?u ny c th? d?n ?n m?t d? li?u. V? v?y, chng ti khuyn b?n sao lu b? my c s? d? li?u tr?c khi b?n th?c hi?n b?c ny.
    ALTER DATABASE Test_RO_FG_DB SET EMERGENCY
    GO
    ALTER DATABASE Test_RO_FG_DB SET SINGLE_USER
    GO
    DBCC CHECKDB (Test_RO_FG_DB, repair_allow_data_loss) WITH ALL_ERRORMSGS
    GO
    ALTER DATABASE Test_RO_FG_DB SET MULTI_USER
    GO
  9. Ki?m ch?ng r?ng b? my c s? d? li?u tr?c tuy?n, v thi?t l?p l?i cc ch?c nng b?n ghi d?ch v? mi gi?i.
  10. Xa cc t?p tin b? my c s? d? li?u m khng c?n thi?t. L?nh m?u cho th?y lm th? no ? lm i?u ny:
    del /P new_Test_RO_FG.mdf
    del /P new_Test_RO_FG_File1.ndf
    del /P new_Test_RW_FG_File1.ndf
    del /P new_Test_RO_FG_log.ldf

THNG TIN THM

C m?t vi b?c x?y ra khi m?t b? my c s? d? li?u g?n li?n v?i m?t th? hi?n c?a SQL Server. Cc b?c ny bao g?m vi?c Khi ph?c b? my c s? d? li?u v nng c?p cc t?p tin t? phin b?n tr?c c?a SQL Server.

Trong cc v?n ? ?c m t? trong ph?n "Tri?u ch?ng", SQL Server 2012 B?t ?u qu tr?nh nng c?p, tr?c khi cc t?p ch?-?c trong b? my c s? d? li?u ?c pht hi?n. Cc b?c nng c?p bao g?m B?t ?u t? m?t giao d?ch ? xa cc "s?ch ng c?a" bit trong trang kh?i ?ng c?a b? my c s? d? li?u. Phin b?n tr?c c?a SQL Server khng th? ?c cc b?n ghi c?a giao d?ch B?t ?u. Do , b? my c s? d? li?u khng ph?i l c th? s? d?ng trong phin b?n tr?c c?a SQL Server v SQL Server t?o ra l?i 3624.

T?i-ch? nng c?p khi b? my c s? d? li?u ?c nh d?u ki?m l ch?-?c

Khi b?n th?c hi?n t?i-ch? nng c?p m?t th? hi?n c?a SQL Server c ch?a b? my c s? d? li?u ch? ?c ?c ?t tn Test_RO_DB v?i SQL Server 2012, b?n c th? nh?n ?c cc thng bo l?i tng t? nh sau trong Nh?t k? l?i SQL Server:

2012-05-04 21:03:59.23 spid19s B?t ?u l?p b? my c s? d? li?u 'Test_RO_DB'.
2012-05-04 21:03:59.56 spid19s Converting database 'Test_RO_DB' t? phin b?n 661 ? phin b?n hi?n t?i 706.
2012-05-04 21:03:59.56 spid19s Error: 928, m?c ? nghim tr?ng: 20, bang: 1.
2012-05-04 21:03:59.56 spid19s trong th?i gian nng c?p, b? my c s? d? li?u nu ra ngo?i l? 3415, m?c ? nghim tr?ng 16, bang 1, ?a ch? 000007FEE66D784A. S? ngo?i l? s? d?ng ? xc ?nh nguyn nhn.
2012-05-04 21:03:59.61 spid19s Error: 3415, m?c ? nghim tr?ng: 16, bang: 1.
2012-05-04 21:03:59.61 spid19s b? my c s? d? li?u 'Test_RO_DB' khng th? nng c?p b?i v? n l ch?-?c, c t?p ch?-?c ho?c ng?i dng khng c quy?n ? s?a ?i m?t s? cc t?p tin. Lm cho b? my c s? d? li?u ho?c cc t?p tin c th? ghi, b?t ln v ch?y l?i ph?c h?i.


Vo cu?i c?a qu tr?nh nng c?p, b? my c s? d? li?u Test_RO_DB s? trong nh n?c RECOVERY_PENDING. B?n ph?i s? d?ng l?nh Thay ?i b? my c s? d? li?u ? thi?t l?p b? my c s? d? li?u ? READ_WRITE. Sau s? d?ng l?nh Thay ?i b? my c s? d? li?u ? thi?t l?p b? my c s? d? li?u ? READ_ONLY. i?u ny cho php cc cng c? SQL Server nng c?p b? my c s? d? li?u phin b?n chnh xc.

T?i-ch? nng c?p khi ?c/ghi b? my c s? d? li?u ch?a cc nhm t?p tin ?c nh d?u ki?m ch? ?c

Khi b?n th?c hi?n t?i-ch? nng c?p SQL Server 2012, b?n c th? nh?n ?c tin th thoai tng t? nh sau trong Nh?t k? l?i SQL Server. V?n ? ny x?y ra khi th? hi?n tr?c c?a SQL Server ch? b? my c s? d? li?u ?c/ghi v c ch?a cc nhm t?p tin ?c nh d?u ki?m READ_ONLY. Tuy nhin, qu tr?nh nng c?p k?t thc nh mong ?i, v b? my c s? d? li?u B?t ?u tr?c tuy?n.

Lu ? Trong thng bo l?i sau, b? my c s? d? li?u ?c ?t tn theo Test_RO_FG:

2012-05-04 21:03:59.23 spid18s B?t ?u l?p b? my c s? d? li?u 'Test_RO_FG'.
2012-05-04 21:03:59.71 spid18s Converting database 'Test_RO_FG' t? phin b?n 661 ? phin b?n hi?n t?i 706.
2012-05-04 21:03:59.71 spid18s b? my c s? d? li?u 'Test_RO_FG' ch?y b?c nng c?p t? phin b?n 661 Phin b?n 668.



Thu?c tnh

ID c?a bi: 2710782 - L?n xem xt sau cng: 18 Thang Sau 2012 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2012 Enterprise
T? kha:
kbsurveynew kbprb kbtshoot kbmt KB2710782 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 2710782

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com