Hi
Now I have the complete (I hope) solution for moving primary SSO server and now I'm able to delete catalogs through backup exec console interface. I get the clue from this page:
http://www.symantec.com/connect/forums/how-transwer-be-database-amp-config-new-media-server. So here is the new recipe (use it at your own risk):
- examine registry keys HKLM\Software\Symantec on all servers
- examine bedb databasess on all servers (table machineex)
- stop backup exec services on all servers
- stop bkupexec SQL servers on all servers
- copy bedb databases
- export registry keys
- copy catalog files
- start backup exec services on all media servers
- run beutility
- move primary san sso server
- stop backup exec services on all services
- run sql manager and modify table machineex on old primary and new primary
- examine table machineex on secondaries
- examine registry keys HKLM\Software\Symantec and modifiy keys and values, modify also HKLM\Software\Symantec\Backup Exec for Windows\Backup Exec\Server\DataPartitionID (swap values on old primary and new primary SSO servers)
- modify table DataPartition (swap values, columns GUID and Name)
- script (alter table ... add ...) all keyses, indexes and relationships (I'm not a sql guy) in the following tables: CatFragment, CatImage, CatMedia, CatPieceIDTable, CatResource, Report, ReportCategory, ReportCategorySet, ReportFilter, ReportFiltersUsed, ReportFilterValue, ReportJob, ReportJobFilters, ReportJobRun and save that script
- drop all keyses, indexes and relationships in the above tables (alter table ... drop ...)
- change (swap) values in column PartitionID in all tables which contain that column but not in the table Partition (it describes library partition)
- recreate all keyses, indexes and relationships (alter table .... add ...) in the following tables: CatFragment, CatImage, CatMedia, CatPieceIDTable, CatResource, Report, ReportCategory, ReportCategorySet, ReportFilter, ReportFiltersUsed, ReportFilterValue, ReportJob, ReportJobFilters, ReportJobRun
- start backup exec services on all media servers
- recatalog tapes
I tested:
- delete catalog selection - It works
- recatalog tape - It works
- restore something - It works
- backup someting - It works
Regards Milan