Åܧó 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ª½±µ×§ï¦¨§Anªº¥Ø¿ý¸ô®|§Y¥i¡C

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