SQL Server 2005ÖеÄÎļþºÍÎļþ×é
1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹Øϵ
ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØƽºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf ºÍ Data3.ndf£©£¬²¢½«ÕâÈý¸öÎļþÖ¸Åɵ½Îļþ×é fgroup1 ÖС£È»ºó£¬¿ÉÒÔÃ÷È·µØÔÚÎļþ×é fgroup1 ÉÏ´´½¨Ò»¸ö±í¡£¶Ô±íÖÐÊý¾ÝµÄ²éѯ½«·ÖÉ¢µ½Èý¸ö´ÅÅÌÉÏ£¬Òò¶øÐÔÄܵÃÒÔÌá¸ß¡£ÔÚ RAID£¨´ÅÅÌÈßÓàÕóÁÐ)Ìõ´ø¼¯ÉÏ´´½¨µ¥¸öÎļþÒ²¿ÉÒÔ»ñµÃÏàͬµÄÐÔÄܸÄÉÆ¡£È»¶ø£¬ÎļþºÍÎļþ×éʹÄúµÃÒÔÔÚдÅÅÌÉÏÇáÒ×µØÌí¼ÓÐÂÎļþ¡£ÁíÍ⣬Èç¹ûÊý¾Ý¿â³¬¹ýµ¥¸ö Microsoft Windows ÎļþµÄ×î´ó´óС£¬Ôò¿ÉÒÔʹÓôÎÒªÊý¾ÝÎļþÔÊÐíÊý¾Ý¿â¼ÌÐøÔö³¤¡£
2¡¢Îļþ¡¢Îļþ×éÔÚʵ¼ùÓ¦ÓÃÖг£¼ûµÄÎÊÌâ
ͨ³£Çé¿öÏÂÎÒÃǹ¹ÔìµÄÊý¾Ý¿â¶¼Ö»ÓÐÁ½¸öÎļþ,mdfÎļþºÍldfÎļþ.µ«ÊÇÕâÑùÓÐÁ½¸öȱµã£º
(Ò»)ÈÝÒ×µ¼ÖÂÎļþ¹ý´ó
ÎÒÃÇÖªµÀ,mdfÎļþÊÇÊý¾Ý¿âÎļþ,ÕâÑùµÄ»°Ò²¾ÍÒâζ×ÅËæ×ÅÊý¾Ý¿âµÄÔö´ómdf¾Í»áÏàÓ¦µÄÔö´ó,ÏÔÈ»ÔÚÏÖÔÚµÄÓ¦ÓÃÖÐÊý¾ÝÅòÕÍÊÇÌ«³£¼ûµÄÊÂÇéÁË,µ±ÄãµÄÓ¦Óñä´óºó,mdfÎļþÒ²»á±ä´ó,È»¶øwindows¶ÔÎļþµÄ´óСÊÇÓÐÒªÇóµÄ,ÕâÑùµÄ»°ºÜÈÝÒ×µ¼ÖÂmdfÎļþ´ïµ½windowsËùÔÊÐíµÄÎļþ´óСµÄ½çÏÞ(ÓÚÊÇÊý¾Ý¿â¾Í±ÀÀ£ÁË)¡£
(¶þ)ûÓÐÀûÓõ½´ÅÅÌÕóÁÐ
´óÐ͵ķþÎñÆ÷ºÃ¶à¶¼ÓдÅÅÌÕóÁÐ,Äã¿ÉÒÔ°Ñ´ÅÅÌÕóÁмòµ¥µÄ¼ÙÏó³Én¸öÒ»¿éת¶¯µÄ´ÅÅÌ,´ÅÅÌÕóÁеÄÉè¼ÆÊÇÏ£Íûͨ¹ý¶à¸ö´ÅÅ̵Ĵ®ÁªÀ´µÃµ½¸ü´óµÄ¶ÁдЧÂÊ.µ«ÊÇÈç¹ûÄãµÄÊý¾Ý¿âÖ»ÓÐÒ»¸ömdfÎļþ(ldfÎļþÔÝʱ²»¿¼ÂÇ),ÄÇôÄã×ÜÊÇÖ»Äܹ»ÀûÓÃÕâ¸ö´ÅÅÌÕóÁÐÀïÃæµÄÒ»¸ö´ÅÅ̶øÒÑ.ÄÇÑùµÄ»°°º¹óµÄ´ÅÅÌÕóÁеÄЧÂʾÍÓɲ¢Áª±ä³É´®ÁªÁË.ÊÔÏëÈç¹ûÎÒÃÇÄܹ»ÈÃmdf·ÖÉ¢³É¶à¸öÎļþ,±ÈÈç˵´ÅÅÌÕóÁÐÉϵÄÿ¸ö´ÅÅÌÖж¼·ÖÅäÒ»¸öÎļþ,È»ºó°ÑmdfÖеÄÊý¾Ý·ÖÉ¢µ½¸÷¸öÎļþÖÐ,ÎÒÔÚ¶ÁÈ¡µÄʱºò¾ÍÊÇ´®ÁªµÄ¶ÁÈ¡ÁË,ÕâÑù¾Í³ä·ÖµÄÀûÓÃÁË´ÅÅÌÕóµÄ´æȡЧÄÜ.
ÕâÁ½¸öÎÊÌâƽ³£ÎÒÃÇûÓÐÓöµ½¹ý(Ìõ¼þ²»¾ß±¸),µ«ÊÇ×ö´óÐ͵ķþÎñ¿ª·¢µÄʱºòÕ⼸ºõÊÇÖÂÃüµÄ.
3¡¢²éѯÎļþ×éºÍÎļþÓï¾ä
ÕâÔÚ2005Ï£¬ÔËÐÐ
SELECT df.[name],
df.physical_name,
df.[size],
df.growth,
f.[name][filegroup],
f.is_default
from sys.database_files df JOIN sys.filegroups f
ON df.data_space_id = f.data_space_id
4¡¢MSDN¹Ù·½½âÊÍ
Á˽âÎļþºÍÎļþ×é
ÿ¸ö SQL Server Êý¾Ý¿âÖÁÉÙ¾ßÓÐÁ½¸ö²Ù×÷ϵͳÎļþ£ºÒ»¸öÊý¾ÝÎļþºÍÒ»¸öÈÕÖ¾Î
Ïà¹ØÎĵµ£º
ÎÊÌâÃèÊö£º
±¾ÌâÓõ½ÏÂÃæÈý¸ö¹Øϵ±í£º
CARD ½èÊ鿨¡£ CNO ¿¨ºÅ£¬NAME ÐÕÃû£¬CLASS °à¼¶
BOOKS ͼÊé¡£ BNO ÊéºÅ£¬BNAME ÊéÃû,AUTHOR ×÷Õߣ¬PRICE µ¥¼Û£¬QUANTITY ¿â´æ²áÊý
BORROW ½èÊé¼Ç¼¡£ CNO ½èÊ鿨ºÅ£¬BNO ÊéºÅ ......
ÅäÖÃsql server 2000ÒÔÔÊÐíÔ¶³Ì·ÃÎÊÊʺϹÊÕÏ:1. ÓÃsqlÆóÒµ¹ÜÀíÆ÷ÄÜ·ÃÎÊsql server 2000(ÒòΪËüÊDzÉÓÃÃüÃû¹ÜµÀ(named pipes)·½Ê½½øÐз½Ê½),µ«ÓÃado.net ·½Ê½(udp)²»ÄÜ·ÃÎÊ.2. ²ÉÓÃado.net·½Ê½²»ÄÜÔ¶³Ì·ÃÎÊ.¹ÊÕϵĿÉÄÜÔÒòÓÐ:1.sql server 2000ûÓа²×°sql server 2000 sp3a¼°ÒÔÉÏÉý¼¶°ü,»¹Î´ÆôÓò¢¿ª·Å1433¶Ë¿Ú(udp);2 ......
@SuppressWarnings("unchecked")
public List<ZxFunction> selectFunctionParentByUserId(final int userId) {
try {
final String sql = "select * from zx_function ......
ÎÊÌâÃèÊö£º
±¾ÌâÓõ½ÏÂÃæÈý¸ö¹Øϵ±í£º
CARD ½èÊ鿨¡£ CNO ¿¨ºÅ£¬NAME ÐÕÃû£¬CLASS °à¼¶
BOOKS ͼÊé¡£ BNO ÊéºÅ£¬BNAME ÊéÃû,AUTHOR ×÷Õߣ¬PRICE µ¥¼Û£¬QUANTITY ¿â´æ²áÊý
BORROW ½èÊé¼Ç¼¡£ CNO ½èÊ鿨ºÅ£¬BNO ÊéºÅ ......
ÎÒÃÇÔÚÊý¾Ý¿âÖÐʹÓñíµÄʱºò,¾³£»áÓöµ½Á½ÖÖʹÓñíµÄ·½·¨,·Ö±ð¾ÍÊÇʹÓÃÁÙʱ±í¼°±í±äÁ¿¡£ÔÚʵ¼ÊʹÓõÄʱºò£¬ÎÒÃÇÈçºÎÁé»îµÄÔÚ´æ´¢¹ý³ÌÖÐÔËÓÃËüÃÇ£¬ËäÈ»ËüÃÇʵÏֵŦÄÜ»ù±¾ÉÏÊÇÒ»ÑùµÄ£¬¿ÉÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÖÐÓÐʱºòȥʹÓÃÁÙʱ±í¶ø²»Ê¹Óñí±äÁ¿£¬ÓÐʱºòȥʹÓñí±äÁ¿¶ø²»Ê¹ÓÃÁÙʱ±íÄØ?
¡¡¡¡ÁÙʱ±í
¡¡¡¡ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬ ......