¥È¥Ã¥× ºÇ¿· Äɵ­

¥µ¥¤¥é¥¹¤ÎËÜê


2012-04-03

¡¦ [SQL] SQL Server ¥³¥Þ¥ó¥É¥é¥¤¥ó¤Ç¥ê¥¹¥È¥¢¤¹¤ëÊýË¡

cmd¤Ç¥³¥Þ¥ó¥É¥×¥í¥ó¥×¥È¤ò³«¤­¡Ösqlcmd -E -S [ÀܳÀè¤Î SQL Server¥¤¥ó¥¹¥¿¥ó¥¹Ì¾] -d master¡×¤ò¼Â¹Ô¤·°Ê²¼¤Î¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤·¤Þ¤¹¡£
1> RESTORE DATABASE [DB̾] FROM DISK=N'[¥Ð¥Ã¥¯¥¢¥Ã¥×¥Õ¥¡¥¤¥ë¥Ñ¥¹]' WITH REPLACE
2> go
ËÜÆü¤Î¥ê¥ó¥¯¸µ | 47 | 14 | 6 | 2 | 2 | 1 | 1 | 1 |