DelphiʹÓÃiniÅäÖÃÎļþÁ¬½ÓMS SQLÊý¾Ý¿â
ºÜÔç×ö¹ýµÄÒ»¸ödelphiÏîÄ¿£¬°ÑÀïÃæÓõ½µÄ¼¼Êõ×ܽáһϣ¬Ö÷ÒªÊÇÕë¶ÔÏóÎÒÕâÑùµÄdelphiÐÂÊÖ£¬¼¼ÊõÉÏ×ö¸ö»ýÀÛ°É£¡
¼ÙÉèÎÒÃǵÄÊý¾Ý¿âÅäÖÃÎļþServerInfo.iniÄÚÈÝÈçÏ£º
[ServerInfo]
ServerIP=192.168.1.5
SQLDBName=Data
SQLUserID=sa
SQLPwd=
ÎÒÃǶ¨ÒåÒ»¸öÁ¬½ÓÊý¾Ý¿âµÄ¹ý³ÌDBConnectÄÚÈÝÓ¦ÈçÏÂ
procedure TDM.DBConnect();
var
ini:TiniFile;
Server,User,Pass,DBName:string;
begin
ini := TiniFile.Create(ExtractFilePath(Application.ExeName)+'dbconn.ini'); //³õʼ»¯iniÎļþ
Server := ini.ReadString('serverinfo','ServerIP',''); //Êý¾Ý¿âipµØÖ·
DBName := ini.ReadString('serverinfo','SQLDBName',''); //Êý¾Ý¿âÃû
User := ini.ReadString('serverinfo','SQLUserID',''); //Êý¾Ý¿âÓû§Ãû
Pass := ini.ReadString('serverinfo','SQLPwd',''); //Êý¾Ý¿âÃÜÂë
try
DM.ADOConn.ConnectionString := 'Provider=SQLOLEDB.1;Persist Security Info=False;'
+'User ID='+trim(User)
+';Password='+trim(Pass)
+';Initial Catalog='+trim(DB)
+';Data Source='+trim(Server);
DM.ADOConn.Open ;
except
application.MessageBox('Êý¾Ý¿âÁ¬½Óʧ°Ü£¬Çë¼ì²éINIÅäÖÃÎļþ','Ìáʾ',64);
application.Terminate ;
end;
end;
ÏàÐÅ´ó¼Ò¶¼ÄÜ¿´¶®£¬×¢ÒâʹÓÃTiniFileÀàµÄº¯Êý»ò¹ý³ÌÓ¦ÒýÈëINIFilesµ¥Ôª¡£
Ïà¹ØÎĵµ£º
SQL×¢Èë¹¥»÷
¡¡¡¡SQL×¢Èë¹¥»÷ÊǺڿͶÔÊý¾Ý¿â½øÐй¥»÷µÄ³£ÓÃÊÖ¶ÎÖ®Ò»¡£Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´ú ......
Use DatabaseName
--DB shrink
--»ñÈ¡database ¿ÕÓà¿Õ¼ä£¬¡¡¾ö¶¨ÊÇ·ñ×÷shrinkDB
exec [DBNAME].dbo.sp_spaceused
DBCC ShrinkDB(DBNAME)
--Log file shrink
Use DatabaseName
GO
Alter Database DatabaseName Set Recovery Simple
GO
Alter Database DatabaseName Set Recovery Full
GO
DBCC SHRINKFILE ('Log ......
Èç¹ûÄãµÄÉí·ÝÑéÖ¤·½Ê½ÎªWindows¼¯³ÉÉí·ÝÑéÖ¤¸ü¸ÄΪ»ìºÏ·½Ê½µÄÉí·ÝÑéÖ¤£¬ÐèÒªÔÚSQL Server Configuration ManagementÖУ¬°ÑTCP/IPµÄ»î¶¯ÆôÓã¬Ò²¾ÍÊǵÚÒ»¸öÑ¡ÔñµÄµØ·½£¬Ñ¡ÔñÆôÓᣲ¢ÇÒʹÓü¯³ÉÉí·ÝÑéÖ¤·½Ê½µÇ¼ºó£¬ÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏÑ¡ÔñÊôÐÔ£¬°Ñ°²È«ÐÔϵÄWINDOWSģʽ¸ÄΪSQLÓëWINDOWSģʽ ......
ijÏîĿ֮ǰµÄÊý¾Ý¿âÓб仯£¬µ«ÊÇÒÔǰдµÄ³ÌÐòÊÇÖ§³ÖÀÏÊý¾Ý¿âµÄ£¬ÐÂÊý¾Ý¿âÓÐһЩÎÊÌ⣬ÐèÒªÐ޸쬵«ÊÇÊý¾Ý¿â¾ÍÖØ¸´ÁË£¬ÓÚÊǾÍÒª°Ñ¿ª·¢»úÉÏ֮ǰµÄÊý¾Ý¿âÖØÐÂÃüÃû¡£
ÕâÀï¼Ç¼һϲ½Ö裨¾ÉÃû³Æ£ºMobileMsg£¬ÐÂÃû³Æ£ºMobileMsg_old£©£º
1¡¢¹ØµôÆóÒµ¹ÜÀíÆ÷£¬´ò¿ª²éѯ·ÖÎöÆ÷£»
2¡¢ÐÞ¸ÄÊý¾Ý¿âÃû³Æ£º
EXEC sp_dboption 'MobileMs ......
֮ǰΪÁË·½±ã²Ù×÷¾ÍÔÚSql ServerµÄÆóÒµ¹ÜÀíÆ÷Àï×¢²áÁËÔ¶³Ì·þÎñÆ÷£¬µ«ÊÇǰһ¶Îʱ¼äÔÚÔ¶³Ì·þÎñÆ÷ÉÏÐÞ¸ÄÁ˸ÃÊý¾Ý¿âµÄÃÜÂ룬ÿ´Îµã»÷¸Ã×¢²á·þÎñÆ÷ϵͳҪµÈºÜ³¤Ê±¼ä£¬ÏóËÀ»úÒ»Ñù£»ÐÞ¸ÄÁ¬½ÓÊôÐÔÒ²Ð޸IJ»ÁË£¬µã»÷ºóҲûÓз´Ó¦£¬ÓÚÊǾÍÏëɾ³ýÖØÐÂ×¢²á£¬¼ÈÈ»ÎÞ·¨ÔÚ¹ÜÀíÆ÷Àïɾ³ý£¬¾ÍÏë´Ó×¢²á±íÀïɾ³ý£¬ÕÒÁ˺þÃÖÕÓÚÕÒµ½ÁË£¬¶ÔÓ¦µÄsql ......