• Server name :  ÃÐºØ Server name ãËé¶Ù¡µéͧ

• Authentication: ¡Ó˹´ SQL Server Authentication

• Login : sa  ËÃ×Í user ·Õèä´é¡Ó˹´

• Password : prosoft ËÃ×Í·Õèä´éµÑ駤èÒäÇé

• ¡Ó˹´ Servername  ¼Ô´ à¾ÃÒÐ ¤èÒ Default ¢Í§¡ÒõԴµÑé§ SQL EXPRESS µéͧ¨ÐÁÕ Format ´Ñ§¹Õé   “SERVERNAME/SQLEXPRESS”

• 㹡Òà Connect SQLEXPRESS ¶éÒäÁè¡Ó˹´ÃËÑÊ SA  äÁèÊÒÁÒö Connect  àÃÒÊÒÁÒö仡Ó˹´,ź ÃËÑʼèÒ¹  sa ä´é

Right Click  àÅ×Í¡ ÊÃéÒ§ New  Database 

• ãÊè ª×èÍ Database name

• Click OK

àÁ×èÍÊÃéÒ§ Database ãËÁèáÅéÇ ¢Ñ鹵͹µèÍ仡ç¨Ðà»ç¹¡Òà restore database

• Right  Click ·Õè System Database àÅ×Í¡ Restore Database

• Click Select Source for Restore   From Device   

• Click Add  àÅ×Í¡ Database ·Õè Backup  Click OK

¤ÅÔ¡ä»·Õè Page Options>·Õè Page Option>ãËé Select restore options à»ç¹ Overwrite the existing database

¤ÅÔ¡ OK

»Ñ­ËÒ Restore base äÁèä´é à¹×èͧ¨Ò¡

• Path SQL ·ÕèãªéÍÂÙèäÁè¶Ù¡µéͧ

ÇÔ¸Õ¡ÒõÃǨÊͺ
     1. ¤ÅÔ¡ µÃ§ Restore with Standby ¨Ð»ÃÒ¡¯ Path Default ¢Í§ SQL SERVER
     2. Copy ÁÒÇÒ§ ·Õè Path:  Restore the database file as ãËé¶Ù¡µéͧ
     3. ¡ÒõÑ駪×èÍ File Restore As µéͧäÁè«éӡѺª×èÍ Database ·ÕèÁÕÍÂÙèà´ÔÁ

• àÁ×èÍãÊè Path File ¶Ù¡µéͧ áÅЪ×èÍ .mdf áÅÐ .ldf äÁè«éӡѹáÅéÇ

• àÅ×Í¡ Restore  Leave the Cannot be RESTORE WITH  RECOVERY

Click OK

• Right Click ·Õè database ·Õèµéͧ¡Òà Backup àÅ×Í¡ä»·Õè Tasks>Back upA

• àÅ×Í¡ Path ·Õèµéͧ¡ÒÃà¡çºä¿Åì Back up äÇé

Brown  Path ·Õèµéͧ¡ÒÃà¡çº

Click OK  àÁ×èÍàÅ×Í¡ Path ·Õèµéͧ¡ÒÃà¡çºàÃÕºÃéÍÂáÅéÇ

Click Ok

¡Òà Back up database àÊÃç¨ÊÁºÙóì