Hi-FiÀu½èI.Tºô¡GSQL Server ?ˆï¿½ï¿???forum_id=43-°Q½×°Ï
±z©|¥¼µn¤J...
±b¸¹:
±K½X:

§Ñ°O±K½X¡@
°Q½×°Ï>>SQL Server ?ˆï¿½ï¿???forum_id=43<<

 
 
µo°_¤H¡G
ruby
¤@¯ë·|­û
±i¶K®É¶¡¡G2009/02/15-13:23:01
   ÀËÁ|

¡@¥DÃD¡GÅܧó SQL Server ¹w³]ªº¸ê®ÆÀɸô®|»P³Æ¥÷Àɸô®|

Åܧó SQL Server ¹w³]ªº¸ê®ÆÀɸô®|»P³Æ¥÷Àɸô®|


·í§A¦w¸Ë¦n SQL Server 2005/2008 ¤§«á¡A³q±`¬ÛÃöÀɮתº¹w³]¦w¸Ë¸ô®|³£·|¦b C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL ¥Ø¿ý¤U¡A¦Ó¸Ó¥Ø¿ý¤U¦³¨â­Ó«Ü­«­nªº¥Ø¿ý¡A¤À§O¬O DATA (¸ê®ÆÀÉÀx¦s¥Ø¿ý) »P Backup (³Æ¥÷ÀÉÀx¦s¥Ø¿ý)¡A¦pªG§A§Æ±æ±N³o¨Ç­«­nÀÉ®×Àx¦s¦b¨ä¥LºÏºÐ¾÷®É¡Aª½±µ³z¹L SQL Server Management Studio (SSMS) ´N¥i¥H­×§ï DATA (¸ê®ÆÀÉÀx¦s¥Ø¿ý) ªº¹w³]¸ô®|¡A¤£¹L«oµLªk³z¹L SSMS ­×§ï¹w³]³Æ¥÷Àɪº¸ô®|¡C


§Ú­Ó¤Hªº¶}µoÀô¹Ò C ºÏºÐ¾÷¤w¸g¥u³Ñ¤U 1GB ¤F¡A©Ò¥H¨C¦¸¦b¶}¸ê®Æ®wªº®É­Ô¡A³£·|¤â°Ê½Õ¾ã¸ê®ÆÀɪº¸ô®|¡C¥t¥~¡A¨C¦¸¤â°Ê³Æ¥÷¸ê®Æ®w®É¡A¤]³£­n¤â°Ê¿ï¨ú³Æ¥÷ªº¥Ø¿ý¡A±`±`°µÃþ¦üªº°Ê§@¯uªº¬O¤£³Ó¨äÂZ¡A¦]¦¹§ä¥X¤F­×¥¿³o¨â­Ó¹w³]¸ô®|ªº¤èªk¡C


1. Åܧó¹w³]ªº¸ê®ÆÀɸô®|


§ïÅÜ¸ê®ÆÀɹw³]¸ô®|­ËÁÙ²³æ¡Aª½±µ³z¹L SSMS ´N¥i¥H­×§ï¤F¡C


­º¥ý¡A¶i¤J SSMS «á¦b Server Name ÂI¿ï·Æ¹«¥kÁä¡A¿ï¨ú¡uÄÝ©Ê(Properties)¡v



µM«áÂI¿ï¡u¸ê®Æ®w³]©w(Database Settings)¡v­¶ÅÒ¡C


2. Åܧó¹w³]ªº³Æ¥÷Àɸô®|


­n­×§ï¹w³]ªº³Æ¥÷¸ô®|´N¥²¶·¤â°Ê­×§ï¾÷½X¤F¡C




­º¥ý¡A¥ý¶}±Òµn¿ý½s¿èµ{¦¡(regedit.exe)¡A¨Ã§ä¨ì HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer ¾÷½X¡A¸Ó¾÷½X¤U¦³­Ó BackupDirectory ¦r¦ê­È¡Aª½±µ­×§ï¦¨§A­nªº¥Ø¿ý¸ô®|§Y¥i¡C


³Æµù¡G­Y­n­×§ï SQLEXPRESS ªº³Æ¥÷¸ô®|¡A­n­×§ï HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer ¾÷½X¤¤ªº BackupDirectory ¦r¦ê­È¡C


ñ¦W
By Ruby

 



 

Hi-FiÀu½èI.Tºô”¯¸¤º©Ò¦³¤å³¹¡B¹Ï¤ù°£¯S§O¥[µù¥~§¡ÄÝ¥»¯¸©Ò¦³,¦p¦³¥ô¦ó°ÝÃD½Ð¨Ó«H§iª¾
½Ð¤ä«ù¨¥½×¦Û¥Ñ¡A°Q½×°Ï©Òµoªí¤§¨¥½×¤£¥Nªí¥»¯¸¥ß³õ
Hi-FiÀu½èI.Tºô”ª©Åv©Ò¦³2004©
---³Ì¨ÎÅã¥Ü®ÄªG1024*768---