°¨»çÇÕ´Ï´Ù. ¸»¾¸ÇϽŴë·Î »èÁ¦ ÈÄ °Ô½Ã°¡ µÇ³×¿ä.
ÁÁÀº ÇÏ·ç µÇ¼¼¿ä.
===========================================================================
¹Ú¿ëÁØ °»ç ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä. ¹Ú¿ëÁØÀÔ´Ï´Ù.
¿ì¼±,
Áú¹® ÁֽŠºÎºÐ°ú °ü·ÃÇؼ´Â
¾Æ¹«·¡µµ
ÀÌ¹Ì ¸¸µé¾îÁ® ÀÖ´Â
MemoEngine µ¥ÀÌÅͺ£À̽º¸¦
·ÎÄà DB¿¡¼ »èÁ¦ÇÑ ÈÄ ´Ù½Ã
SQL Server µ¥ÀÌÅͺ£À̽º ÇÁ·ÎÁ§Æ®¸¦ °Ô½ÃÇØ º¸½Ã´Â °É ±ÇÀåÇØ µå¸³´Ï´Ù.
Àúµµ Áö±Ý±îÁö Çѵιø ºñ½ÁÇÑ ¿¡·¯°¡ ³µ덨´ø °°Àºµ¥¿ä.
±×·²¶§¿¡´Â
·ÎÄà DBÀÇ µ¥ÀÌÅͺ£À̽º¸¦ Áö¿ì°í, ´Ù½Ã °Ô½ÃÇϰųª,
MemoEngine2 ½ÄÀ¸·Î ´Ù¸¥ À̸§ÀÇ µ¥ÀÌÅͺ£À̽º·Î
°Ô½ÃÇØ º¸¸é Àß µÉ °Í °°½À´Ï´Ù.
±×·¡µµ ¾ÈµÈ´Ù¸é,
SQL Server µ¥ÀÌÅͺ£À̽º ÇÁ·ÎÁ§Æ® ÀÚü¸¦ »õ·Ó°Ô ¸¸µé°í
ÀÌ°÷¿¡ ±âÁ¸ sql ÆÄÀÏÀ» ¿Å°Ü ´ã¾Æ¼
»õ·Ó°Ô ¸¸µç µ¥ÀÌÅͺ£À̽º ÇÁ·ÎÁ§Æ®¿¡¼ °Ô½Ã¸¦ ÁøÇàÇØ º¸¼Åµµ µÇ±¸¿ä.
À§ 2°¡Áö ´Ü°è ¾È¿¡¼ ÇØ°áÀÌ µÉ µí ÇÕ´Ï´Ù.
ÇÁ·ÎÁ§Æ® ¸¸µé°í ¿î¿µÇÏ´Ùº¸¸é,
°¡²û À߸øÀ¸·Î ÀÎÇؼ
»õ·Ó°Ô ÇÁ·ÎÁ§Æ®¸¦ ¸¸µé°í ÁøÇàÇÏ´Â °æ¿ìµµ Àϳ⿡ ÇѵιøÀº Àúµµ
ÁøÇàÇϱ⿡ »õ·Ó°Ô ¸¸µå´Â °Í¿¡ ´ëÇؼ´Â ³Ê¹« ¾Æ½±°Ô »ý°¢ÇÏ½Ç ÇÊ¿ä´Â ¾øÀ» °Í °°½À´Ï´Ù.
¾Æ¹«Æ°, Á¤È®ÇÑ ´äº¯ÀÌ µÇ¾îµå¸®Áö ¸øÇÑ Á¡ Á˼ÛÇÕ´Ï´Ù.
ÀÌ»óÀÔ´Ï´Ù.
Àü¼®È¯ ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä. °»ç´Ô °ÀǸ¦ ¿½ÉÈ÷ µè°í ÀÖ´Â ¸¸Çеµ ÀÔ´Ï´Ù.
°ÀÇ APS.NET ÇÁ·ÎÁ§Æ® Part2 50¹ø °ÀÇ µû¶óÇϱâ ÁßÀε¥
¾Æ·¡¿Í °°ÀÌ ¿À·ù°¡ ¹ß»ý ÇÕ´Ï´Ù. È®ÀÎ ÇÏ½Ã¾î ´äº¯ ºÎŹµå¸³´Ï´Ù.
============================================================
(43,1): SQL72014: .Net SqlClient Data Provider: ¸Þ½ÃÁö 5061, ¼öÁØ 16, »óÅ 1, ÁÙ 5 ALTER DATABASE failed because a lock could not be placed on database 'MemoEngine'. Try again later.
(39,0): SQL72045: ½ºÅ©¸³Æ® ½ÇÇà ¿À·ùÀÔ´Ï´Ù. ½ÇÇàÇÑ ½ºÅ©¸³Æ®:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET CONTAINMENT = NONE
WITH ROLLBACK IMMEDIATE;
END
(43,1): SQL72014: .Net SqlClient Data Provider: ¸Þ½ÃÁö 5069, ¼öÁØ 16, »óÅ 1, ÁÙ 5 ALTER DATABASE statement failed.
(39,0): SQL72045: ½ºÅ©¸³Æ® ½ÇÇà ¿À·ùÀÔ´Ï´Ù. ½ÇÇàÇÑ ½ºÅ©¸³Æ®:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET CONTAINMENT = NONE
WITH ROLLBACK IMMEDIATE;
END
ÀÏ°ý 󸮸¦ ½ÇÇàÇÏ´Â µ¿¾È ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù.
===========================================================================
|