??SQL Server???????????????????
???????????? ???????[ 2012/7/20 11:28:01 ] ????????
??????SQL Server?У?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
??????1??????????????
?????????????????????????????????????????????????????????????????
???????????????????????????????
?????????backup database ??????? to ?????豸?? with [name='?????????'][init /noinit]
<SPAN style="FONT-SIZE: 18px">backup database MagDB to MagDb_1 with init</SPAN>
?????????restore database ??????? from ?????豸?? with [norecovery/recovery]
<SPAN style="FONT-SIZE: 18px">restore database MagDb
from MagDb_1
with norecovery</SPAN>
??????2????????????????????
??????????????????????????????????????????
????????????????????????????????????β?????
?????????backup database ??????? to ?????豸?? with differential [name='?????????']
<SPAN style="FONT-SIZE: 18px">backup database MagDb to MagDb_1 defferential</SPAN>
?????????restore database ??????? from ?????豸?? with [norecovery/recovery]
<SPAN style="FONT-SIZE: 18px">restore database MagDb
from MagDb_1
with file =2??
recovery</SPAN>
??????3?????????????????
????????????????????????е????????????????????????????????
??????????????????????????????????????????????????????????????????????????????????????????????????????????л??????????????????????е???????????????????е????????????????????????????????????????????????β?????????????????β??????????е????????????????
?????????backup log ??????? to ?????豸?? with init/noinit
<SPAN style="FONT-SIZE: 18px">backup log DocDb to disk='c:databakDocDb_1.bat'</SPAN>
?????????restore log ??????? from ?????豸?? with [norecovery/recovery]
<SPAN style="FONT-SIZE: 18px">restore log DocDb
from disk='c:databakDocDb1.bat'</SPAN>
??????4???????????鱸??????
??????????????????????????????飬???????????????????????
??????????????????????????е?????????????????????
?????????backup database ??????? file='????????????'??filegroup) to ?????豸?? with init/noinit
<SPAN style="FONT-SIZE: 18px">backup database DocDb
file='DocDb_Data'
to disk='c:databakDocfile1.dat'</SPAN>
?????????restore database ??????? file='????????????'??filegroup) from ?????豸??
<SPAN style="FONT-SIZE: 18px">restore database DocDb
file="DocDb_Data"
from disk="c:databakDocfile1.dat"</SPAN>
????????????????????????????????????????ç·´???
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11