ArcServe: Manutenzione del database di ArcServe in formato SQL

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

dbcc traceon (3604)
go
dbcc checkdb (asdb)
go
dbcc newalloc (asdb)

Per effettuare il defrag:

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

Riferimenti

• Maintaining the ARCserve Database when using SQL as the Database

• MSSQL Alternate Database for ARCserve Maintenance