View source for ArcServe: Manutenzione del database di ArcServe in formato SQL

Aprire MS SQL Query analizer ed incollare lo script per il check:

<pre>
dbcc traceon (3604)
go
dbcc checkdb (asdb)
go
dbcc newalloc (asdb)
</pre>

Per effettuare il defrag:

<pre>
use asdb
go
dbcc dbreindex (asfilename)
dbcc dbreindex (ashost)
dbcc dbreindex (asjob)
dbcc dbreindex (aslocation)
dbcc dbreindex (asownername)
dbcc dbreindex (aspathname)
dbcc dbreindex (aspool)
dbcc dbreindex (asref)
dbcc dbreindex (astape)
dbcc dbreindex (astpdat)
dbcc dbreindex (astpdrv)
dbcc dbreindex (astperr)
dbcc dbreindex (astpses)
go
</pre>

== Riferimenti ==

*[http://supportconnect.ca.com/sc/kb/techdetail.jsp?searchID=TEC353603&docid=353603&bypass=yes&fromscreen=kbresults Maintaining the ARCserve Database when using SQL as the Database]

*[http://supportconnect.ca.com/sc/kb/techdetail.jsp?searchID=TEC266852&docid=266852&bypass=yes&fromscreen=kbresults MSSQL Alternate Database for ARCserve Maintenance]