📄 db-3a.html
字号:
<html>
<head>
<title>sql汲摹苞沥</title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
</head>
<body bgcolor="#FFFFFF" topmargin=5 leftmargin=15>
<p><br>
<font size="4"><b>Database 客 Table 积己 棺 包府II</b></font></p>
<div align="left">
<hr width="70%" align="left">
</div>
<div align="left"></div>
<p><b><font color="#FF3333">⒀角嚼</font></b><br>
</p>
<table width="75%" border="1">
<tr>
<td width="25%"><font size="2"><b>单捞磐海捞胶 可记</b></font></td>
<td width="75%">
<div align="center"><font size="2"><b>汲 疙</b></font></div>
</td>
</tr>
<tr>
<td width="25%"><font size="2">dbo use only </font></td>
<td width="75%"><font size="2">单捞磐海捞胶甫 单捞磐海捞胶 家蜡磊父捞 荤侩且荐 乐霸 茄促.</font></td>
</tr>
<tr>
<td width="25%"><font size="2">read only </font></td>
<td width="75%"><font size="2">单捞磐海捞胶甫 佬扁 傈侩栏肺 沥狼茄促. <br>
老馆利栏肺 狼荤搬沥 单捞磐海捞胶狼 焊救阑 汲沥且锭 荤侩等促. </font></td>
</tr>
<tr>
<td width="25%" height="33"><font size="2">select into/bulk copy</font></td>
<td width="75%" height="33"><font size="2"> 单捞磐海捞胶啊 肺弊登瘤 臼绰 悼累阑 罐酒甸老 巴阑 倾侩茄促.
<br>
单捞磐狼 bulk copying 肚绰 transaction log 傍埃阑 焊粮窍扁 困秦 select into 巩捞 荤侩瞪锭 荤侩茄促.
</font></td>
</tr>
<tr>
<td width="25%"><font size="2">single user</font></td>
<td width="75%"><font size="2">单捞磐海捞胶 咀技胶甫 茄锅俊 茄 荤侩磊肺 力茄茄促. <br>
蜡瘤焊荐甫 荐青且 锭 荤侩茄促. </font></td>
</tr>
<tr>
<td width="25%"><font size="2">trunc. log on chkpt.</font></td>
<td width="75%"><font size="2">check point process啊 惯青且 锭付促 transaction log甫
力芭茄促.(committed 等 transaction log甫 力芭茄促).<br>
transaction log 傍埃阑 焊傈窍扁 困秦 俺惯悼救 荤侩茄促.</font></td>
</tr>
<tr>
<td width="25%"><font size="2">Autoshrink</font></td>
<td width="75%"><font size="2">单捞磐海捞胶 农扁甫 磊悼栏肺 临老 巴牢瘤甫 搬沥茄促.</font></td>
</tr>
</table>
<p><font size="2">sp_dboption testdb<br>
sp_dboption testdb 'autoshrink','true' /* 单捞磐海捞胶客 LOG size 磊悼栏肺 临捞扁*/<br>
sp_dboption testdb 'autoshrink','false' </font></p>
<p><font size="2">use testdb <br>
go sp_dboption testdb,'single user',true --老窜 single user肺 函券矫难具 弊 促澜俊 DB疙阑
函版矫懦荐 乐促. </font></p>
<p><font size="2">go <br>
sp_renamedb testdb,examdb <br>
go <br>
<br>
/* 单捞磐海捞胶 捞抚 函版矫 SQL Server Enterprise俊辑 捞抚阑 官曹 DB富绊 促弗 DB甫 急琶茄饶俊 且巴 */ </font></p>
<p><font size="2">use examdb <br>
go <br>
sp_dboption examdb,'single user',false <br>
go<br>
<br>
/* -- 荤侩磊 沥狼 颇老弊缝阑 积己窍绊 荤侩磊 沥狼 颇老弊缝俊 2瞒 单捞磐颇老 眠啊 --*/ <br>
<br>
alter database examdb <br>
add filegroup secondary <br>
go<br>
<br>
alter database examdb <br>
add file (name=examdb_data2, <br>
filename='c:\mssql7\data\examdb_data2.ndf', <br>
size=1, filegrowth=10%, maxsize=2) <br>
to filegroup secondary <br>
go<br>
<br>
alter database examdb <br>
add log file (name=examdb_log2, <br>
filename='c:\mssql7\data\examdb_log2.ldf', <br>
size=1, filegrowth=10%, maxsize=2) /*肺弊颇老 眠啊*/ </font></p>
<p><font size="2">/* --- <font color="#3333FF">单捞磐 海捞胶 昏力</font> --- */ <br>
use master <br>
drop database examdb <br>
<br>
-- 曼绊 : SQL SERVER俊辑 <font color="#FF3333">master, model, tempdb </font>单捞磐海捞胶绰
昏力且 荐 绝瘤父<br>
msdb 矫胶袍 单捞磐海捞胶绰 昏力且 荐 乐促. </font></p>
<p> </p>
<p align=right>...<a href="JavaScript:clickOn=history.go(-1)">
<FONT SIZE=-1 FACE=HELVETICA>
Prev</FONT></a><p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -