データベースのバックアップについて

[tyosida]

SQL Server 2005 Standard$B$K$D$$$F$465<($/$@$5$$!#(B

$B%U%k%P%C%/%"%C%W$H:9J,%P%C%/%"%C%W$N$r(BSSIS$B$***@_Dj$7$?$N$G$9$,!"(B

SQL Management Studio$B$N!X4IM}!Y"*!X%a%s%F%J%s%9%W%i%s!Y$NCf$+$i!"(B
$B:9J,%P%C%/%"%C%WMQ$N%G%6%$%s$r3+$-!"!Z%G!<%?%Y!<%9$N%P%C%/%"%C%W(B $B%?%9%/![$r3NG'$7$F$$$k$N$G$9$,!"(B
$B!X%G!<%?%Y!<%9!J(BD$B!K!Y$G!XFCDj$N%G!<%?%Y!<%9!Y$rA*Br$G$-$^$;$s!#(B
$B!X$3$l$i$N%G!<%?%Y!<%9!J(BT$B!K!Y$G%G!<%?%Y!<%9$rA*Br$7$F$b!"(B
$B:FEY3NG'$7$F$_$k$H!"A*Br$,30$l$F$*$j$^$9!#(B

$B:9J,%P%C%/%"%C%W$N>l9g$O%G!<%?%Y!<%9$NA*Br$r$9$kI,MW$OL5$$$N$G$7$g$&$+!)(B
$B!J@=IJ;EMM!)!K(B

$B$A$J$_$K!"%U%k%P%C%/%"%C%W$N>l9g$OA*Br2DG=$G$9!#(B

$B4pK\E*$J$3$H$+$b$7$l$^$;$s$,$J$K$H$>$h$m$7$/$*4j$$$$$?$7$^$9!#(B

[にゃお]

$B$K$c$*$G$9!#(B($B!&!&(B)/

$B$4;HMQ$N(BSQL 2005$B$N>\:Y$J%P!<%8%g%s$r7G<($7$F2<$5$$!#(B
# $BF1MM$N;v$G:$$C$F$$$kJ}$N0Y$N>pJs8;$***@.$k0Y!#!#!#(B

$B;d$,;nMQ$7$F$$$k4D6-$G$O8=>]$,8=$l$F$$$J$$0Y!"(B
Service Pack$B$d%Q%C%A$NE,MQEY$K4s$C$F$b8=>]$,(B
$BJQ$o$C$FMh$k$h$&$G$9$+$i!D(B
$B$^$:$O>\:Y$J%P!<%8%g%s$r3NG'$7$F2<$5$$!#(B
$B"(;d$NJ}$O!V(BStandard Edition SP3(v9.00.4035.00)$B!W$G$9!#(B

$B!|%P!<%8%g%s$N3NG'J}K!!'(B
$B!!BgDq$O%$%s%9%H!<%k$7$?%U%)%k%@$N%m%0%U%)%k%@$XF0:n%m%0$,(B
$BA]$-=P$5$l$k$N$G!"$=$l$r3NG'$7$F2<$5$$!#(B
$BNc!K(BC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
$B"(>e5-$N%U%)%k%@Fb$N!V(BERRORLOG$B!W$r3NG'!#(B

$B!|%P%C%/%"%C%W$N%F%9%H(B
$B!&#D#BI|5l%b%G%k!'C1=c(B(Simple)
$B!!"*%P%C%/%"%C%W%b!<%I(B($B40A4(B)$B!'(BOK
$B!!"*%P%C%/%"%C%W%b!<%I(B($B:9J,(B)$B!'(BOK
$B!!"*%P%C%/%"%C%W%b!<%I(B($B%H%i%s%6%/%7%g%s%m%0(B)$B!'$J$7(B

$B!&#D#BI|5l%b%G%k!'0l3g%m%0(B
$B!!"*%P%C%/%"%C%W%b!<%I(B($B40A4(B)$B!'(BOK
$B!!"*%P%C%/%"%C%W%b!<%I(B($B:9J,(B)$B!'(BOK
$B!!"*%P%C%/%"%C%W%b!<%I(B($B%H%i%s%6%/%7%g%s%m%0(B)$B!'(BOK

$B!&#D#BI|5l%b%G%k!'40A4(B(Full)
$B!!"*%P%C%/%"%C%W%b!<%I(B($B40A4(B)$B!'(BOK
$B!!"*%P%C%/%"%C%W%b!<%I(B($B:9J,(B)$B!'(BOK
$B!!"*%P%C%/%"%C%W%b!<%I(B($B%H%i%s%6%/%7%g%s%m%0(B)$B!'(BOK

$B$***@5>o$K%U%k$*$h$S:9J,%P%C%/%"%C%W$,:***@.=PMh$^$9$N$G(B
$B@=IJ;EMM$G$O$4$6$$$^$;$s!#(B(^-^;
# $B>e5-%F%9%H$G$O!V$9$Y$F$N#D#B!W!VFCDj$N#D#B!W$J$I(B
# $B9T$J$C$F$$$^$9!#(B

$B%U%k%F%-%9%H$^$G$O3NG'$7$F$$$^$;$s$,!D(B
$B4pK\E*$K%P%C%/%"%C%W$O9T$J$($^$9$N$G!"!"!"(B

$BF0:n>u67$r$h$/$h$/3NG'$7$F$_$F2<$5$$!#(Bm(_ _)m

Post by tyosida
SQL Management Studio$B$N!X4IM}!Y"*!X%a%s%F%J%s%9%W%i%s!Y$NCf$+$i!"(B
$B:9J,%P%C%/%"%C%WMQ$N%G%6%$%s$r3+$-!"!Z%G!<%?%Y!<%9$N%P%C%/%"%C%W(B $B%?%9(B
$B%/![$r3NG'$7$F$$$k$N$G$9$,!"(B
$B!X%G!<%?%Y!<%9!J(BD$B!K!Y$G!XFCDj$N%G!<%?%Y!<%9!Y$rA*Br$G$-$^$;$s!#(B
$B!X$3$l$i$N%G!<%?%Y!<%9!J(BT$B!K!Y$G%G!<%?%Y!<%9$rA*Br$7$F$b!"(B
$B:FEY3NG'$7$F$_$k$H!"A*Br$,30$l$F$*$j$^$9!#(B
$B:9J,%P%C%/%"%C%W$N>l9g$O%G!<%?%Y!<%9$NA*Br$r$9$kI,MW$OL5$$$N$G$7$g$&$+!)(B
$B$A$J$_$K!"%U%k%P%C%/%"%C%W$N>l9g$OA*Br2DG=$G$9!#(B
$B4pK\E*$J$3$H$+$b$7$l$^$;$s$,$J$K$H$>$h$m$7$/$*4j$$$$$?$7$^$9!#(B

[にゃお]

$B$K$c$*$G$9!#(B($B!&!&(B)/

$B3:Ev$N>I>u$+!)!!H=$j$^$;$s$,!D(B
KB$BJ8=q$,$"$j$^$7$?$N$GFI$s$G8+$F$b$$$$$+$b!#!#!#(B

$B!|(B[FIX$B!"%a%s%F%J%s%9(B $B%W%i%s$G%G!<%?%Y!<%9$rA*Br$7$?$,A*Br$5$l$J$/(B SQL Server
$B!!(B2005 Service Pack 2 $B$N%G!<%?%Y!<%9$N%P%C%/%"%C%W(B $B%?%9%/$rJT=8$9$k$H$-(B
$B!!(Bhttp://support.microsoft.com/kb/938912/ja

$B;29M$K$7$F2<$5$$!#(Bm(_ _)m

Post by tyosida
SQL Management Studio$B$N!X4IM}!Y"*!X%a%s%F%J%s%9%W%i%s!Y$NCf$+$i!"(B
$B:9J,%P%C%/%"%C%WMQ$N%G%6%$%s$r3+$-!"!Z%G!<%?%Y!<%9$N%P%C%/%"%C%W(B $B%?%9(B
$B%/![$r3NG'$7$F$$$k$N$G$9$,!"(B
$B!X%G!<%?%Y!<%9!J(BD$B!K!Y$G!XFCDj$N%G!<%?%Y!<%9!Y$rA*Br$G$-$^$;$s!#(B
$B!X$3$l$i$N%G!<%?%Y!<%9!J(BT$B!K!Y$G%G!<%?%Y!<%9$rA*Br$7$F$b!"(B
$B:FEY3NG'$7$F$_$k$H!"A*Br$,30$l$F$*$j$^$9!#(B
$B:9J,%P%C%/%"%C%W$N>l9g$O%G!<%?%Y!<%9$NA*Br$r$9$kI,MW$OL5$$$N$G$7$g$&$+!)(B
$B$A$J$_$K!"%U%k%P%C%/%"%C%W$N>l9g$OA*Br2DG=$G$9!#(B
$B4pK\E*$J$3$H$+$b$7$l$^$;$s$,$J$K$H$>$h$m$7$/$*4j$$$$$?$7$^$9!#(B

[tyosida]

$BK\2TF0$N(BServer$B$***@_Dj$OI]$$$N$G!"(B
$***@h$:2>A[E*$K%F%9%H$7$F$_$^$7$?!#(B
$BF1$8>I>u$N$h$&$G!"(B
$B2<5-FbMF$G2r7h$G$-$^$7$?!#(B

$B$K$c$*$5$sM-Fq$&$4$6$$$^$9!#(B

Post by にゃお
$B$K$c$*$G$9!#(B($B!&!&(B)/
$B3:Ev$N>I>u$+!)!!H=$j$^$;$s$,!D(B
KB$BJ8=q$,$"$j$^$7$?$N$GFI$s$G8+$F$b$$$$$+$b!#!#!#(B
$B!|(B[FIX$B!"%a%s%F%J%s%9(B $B%W%i%s$G%G!<%?%Y!<%9$rA*Br$7$?$,A*Br$5$l$J$/(B SQL
Server
$B!!(B2005 Service Pack 2 $B$N%G!<%?%Y!<%9$N%P%C%/%"%C%W(B $B%?%9%/$rJT=8$9$k$H$-(B
$B!!(Bhttp://support.microsoft.com/kb/938912/ja
$B;29M$K$7$F2<$5$$!#(Bm(_ _)m

Post by tyosida
SQL Management Studio$B$N!X4IM}!Y"*!X%a%s%F%J%s%9%W%i%s!Y$NCf$+$i!"(B
$B:9J,%P%C%/%"%C%WMQ$N%G%6%$%s$r3+$-!"!Z%G!<%?%Y!<%9$N%P%C%/%"%C%W(B $B%?%9(B
$B%/![$r3NG'$7$F$$$k$N$G$9$,!"(B
$B!X%G!<%?%Y!<%9!J(BD$B!K!Y$G!XFCDj$N%G!<%?%Y!<%9!Y$rA*Br$G$-$^$;$s!#(B
$B!X$3$l$i$N%G!<%?%Y!<%9!J(BT$B!K!Y$G%G!<%?%Y!<%9$rA*Br$7$F$b!"(B
$B:FEY3NG'$7$F$_$k$H!"A*Br$,30$l$F$*$j$^$9!#(B
$B:9J,%P%C%/%"%C%W$N>l9g$O%G!<%?%Y!<%9$NA*Br$r$9$kI,MW$OL5$$$N$G$7$g$&$+!)(B
$B$A$J$_$K!"%U%k%P%C%/%"%C%W$N>l9g$OA*Br2DG=$G$9!#(B
$B4pK\E*$J$3$H$+$b$7$l$^$;$s$,$J$K$H$>$h$m$7$/$*4j$$$$$?$7$^$9!#(B