how to restore FULL MSSQL server using veritas??

[77013103154]

Hi

i am testing some restore procedures of windows + mssql and i have found that it is very problematic to restore windows server with mssql 2000 server

how it looks:
i am restoring remotely (name and ip of target is the same as source was) Windows 2003 server.
All system files are restored after all (also all system files for sql instances), but no databases are restored.
Primary problem is that the veritas is not backuping/restoring system databases (master, model etc.) during the system restoration. Because of that, instances of mssql are unable to start and veritas cannot restore the rest of databases. Also renaming the "copies" of databases (like they wrote in the book) do not helps, because instances do not starts with them.

Does anybody got similar problem ??
How to restore/backup server like that with or with sql addon for veritas?? (databases i can backup using sql and then write them to tape, but after restore i need to have working sql).
Whole operating system is working good except sql, that have missing system databases.

If anybody knows the solutions and can share thanks in advance.

 

[Zelandakh]

Don't use the SQL addon.
Have a maintenance plan in SQL that drops all databases to disk. Back up that folder.
Restore files to that folder then restore using SQL to bring back from disk.

Faster backup, faster restore and a whole lot simpler.

 

[77013103154]

i am not using sql addon
to use sql addon i need to have working sql instances but in this case the instances do not want to start because they do not have system databases, because veritas do not restore/backup them during file backup

also using automate master .... is not working, because that also needs working instance

and funny thing is: ntbackup is backing and restoring all instances system databases

question is: how to restore system to get instances working and then restore production databases from backups made by sql ??

 

[77013103154]

ofcourse without reainstalling instances