请问一下如何备份iq数据库？谢谢！
<p>请教一下大家都是怎么备份数据库的啊，备份时都应该注意些什么，谢谢！</p><p>感谢ehxz 和jonse的回复！</p><p>我想问一下，就是如何备份一个用户下的所有对象啊。</p>[此贴子已经被作者于2006-11-23 14:59:44编辑过]
这个没有用过，帮顶。不过估计是不是跟ASE差不许多啊。 <p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Wingdings; mso-bidi-font-size: 9.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings;"><span style="mso-list: Ignore;"><font size="3">§</font><span style="FONT: 7pt "Times New Roman";"> </span></span></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 9.0pt; mso-ascii-font-family: JansonText-Roman; mso-hansi-font-family: JansonText-Roman;">数据库全备份</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: JansonText-Roman; mso-bidi-font-size: 9.0pt;"><p></p></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Wingdings; mso-bidi-font-size: 9.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings;"><span style="mso-list: Ignore;"><font size="3">§</font><span style="FONT: 7pt "Times New Roman";"> </span></span></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 9.0pt; mso-ascii-font-family: JansonText-Roman; mso-hansi-font-family: JansonText-Roman;">数据库增量备份</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: JansonText-Roman; mso-bidi-font-size: 9.0pt;"><p></p></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Wingdings; mso-bidi-font-size: 9.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings;"><span style="mso-list: Ignore;"><font size="3">§</font><span style="FONT: 7pt "Times New Roman";"> </span></span></span><font size="3"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 9.0pt; mso-ascii-font-family: JansonText-Roman; mso-hansi-font-family: JansonText-Roman;">数据库全备份后的增量备份</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: JansonText-Roman; mso-bidi-font-size: 9.0pt;"><p></p></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Wingdings; mso-bidi-font-size: 9.0pt; mso-fareast-font-family: Wingdings; mso-bidi-font-family: Wingdings;"><span style="mso-list: Ignore;"><font size="3">§</font><span style="FONT: 7pt "Times New Roman";"> </span></span></span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 9.0pt; mso-ascii-font-family: JansonText-Roman; mso-hansi-font-family: JansonText-Roman;"><font size="3">虚拟备份</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 9.0pt; mso-ascii-font-family: JansonText-Roman; mso-hansi-font-family: JansonText-Roman;"><font size="3"></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 9.0pt; mso-ascii-font-family: JansonText-Roman; mso-hansi-font-family: JansonText-Roman;"><font size="3">词法：<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">BACKUP DATABASE<p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... [{<u>FULL</u>|INCREMENTAL|INCREMENTAL SINCE FULL}]<p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... TO 'archive_device' <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";"><span style="mso-spacerun: yes;"> </span>[ STACKER #_of_tapes_in_stack] ...<p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";"><p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";"><p> </p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: JansonText-Roman; mso-bidi-font-size: 9.0pt;"><p></p></span></p></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">BACKUP DATABASE<p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... [{<u>FULL</u>|INCREMENTAL|INCREMENTAL SINCE FULL}]<p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";">... TO 'archive_device' <p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";"><span style="mso-spacerun: yes;"> </span>[ STACKER #_of_tapes_in_stack] ...<p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";"><p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><b><span lang="EN-US" style="FONT-SIZE: 9.5pt; COLOR: #1669bc; FONT-FAMILY: "Courier New";"><p> </p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 54pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 54.0pt; mso-layout-grid-align: none;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: JansonText-Roman; mso-bidi-font-size: 9.0pt;"><p></p></span></p> <p>另外，IQ提供虚拟备份的功能。在以秒为单位的时间内，完成TB级的数据备份。</p> 装了一个IQ看了一下，好象跟ASA更像一些，跟ASE却不像的多些。 <p>IQ 在新的版本里(比如:12.6.2 or 15)版本下据说将增加和增强与ASE的紧密联系和紧密兼容性,比如,习惯使用:sp_who,sp_xxx,在ASE可以使用的命令,那么在新的IQ的版本中,将以sp_iqwho,sp_iqxxx等出现.这个将大大方便那些对ASE命令熟悉,但是又希望这些类似命令在IQ中出现和使用的FANS...</p><p></p><p></p><p></p> <p><font color="#0000ff">sp_iqdbspace; </font></p><p><font color="#0000ff">backup database to 'F:\iqdss_bak.dump'；</font></p> IQ用的就是ASA的数据引擎，大多的东西都一样。我学IQ就看了很多ASA的文档。
页:
[1]