Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restore VLDB data into Sql database

Status
Not open for further replies.

trex2

IS-IT--Management
Jul 9, 2002
12
SE
Is it possible to merge old data that was backed up on VLDB into a new SQL database?

Trex2
 
Restore the VLDB, apply SP4 and all post-SP4 patches. Then run setupsql to create the 'asdb' database in SQL. Then run DBTOSQL.EXE in the arcserve directory. It will take several hours to complete. Use the DBTOSQL.LOG to monitor progress.
 

I got this error message then I try to do this:

"Invalid file header signature"
"Invalid file trailer signature"

Then I scan the tapes (running a raidset)arcserve doesent find any session.
But then I force arcserve to skip session (a regedit hack)it finds data on tape but is not able to merge it into Sql database.

Trex2
 
If you are trying to merge a single session, then try deleting any records for that backup tape in the database, inventory it, then in merge, only choose the session that you need to restore from.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top