Hi,
Made some sql-code as I had problems regarding the move server whitepaper.
Maybe this can help you out.
*** Start Copy ***
/*
Script is to be used when moving a Library/Drive from one server
to another without having to catalog all tapes
Before using the script:
Copy the Media table from the previous backupserver to a
new table OldMedia on the new backupserver.
Run Inventory on Library
In Media, move the tapes to the correct mediasets
Shutdown all BE Services (BEMCMD -v -0503)
Copy all files from
\ c$\program files\veritas\BackupExec\NT\Catalogs to
\ c$\program files\veritas\BackupExec\NT\Catalogs
Then Run the script on the new server.
After running the script:
Start all BE Services (BEMCMD -v -0502)
Start BackupExec GUI and test restore
*/
UPDATEMedia
SETmedia.CreationDateTime = oldmedia.CreationDateTime,
media.AllocatedDateTime = oldmedia.AllocatedDateTime,
media.ModifiedDateTime = oldmedia.ModifiedDateTime,
media.RecycleDateTime = oldmedia.RecycleDateTime,
media.NonAppendDateTime = oldmedia.NonAppendDateTime,
media.MediaType = oldmedia.MediaType,
media.MediaGUID = oldmedia.MediaGUID,
media.MediaSubType = oldmedia.MediaSubType,
media.CompoundMediaID = oldmedia.CompoundMediaID,
media.CompoundMediaSequence = oldmedia.CompoundMediaSequence,
media.CompoundMediaCount = oldmedia.CompoundMediaCount,
media.LocationID = oldmedia.LocationID,
media.LocationIndex = oldmedia.LocationIndex,
media.CurrentBlockSize = oldmedia.CurrentBlockSize,
media.EndOfDataBlockAddress = oldmedia.EndOfDataBlockAddress,
media.EndOfDataCapacityBytes = oldmedia.EndOfDataCapacityBytes,
media.RemainingCapacityBytes = oldmedia.RemainingCapacityBytes,
media.TotalCapacityBytes = oldmedia.TotalCapacityBytes,
media.EndOfMediaSide = oldmedia.EndOfMediaSide,
media.TotalInUseHours = oldmedia.TotalInUseHours,
media.TotalMounts = oldmedia.TotalMounts,
media.TotalSeeks = oldmedia.TotalSeeks,
media.TotalSeekErrors = oldmedia.TotalSeekErrors,
media.TotalWriteBytes = oldmedia.TotalWriteBytes,
media.TotalWriteSoftErrors = oldmedia.TotalWriteSoftErrors,
media.TotalWriteHardErrors = oldmedia.TotalWriteHardErrors,
media.TotalReadBytes = oldmedia.TotalReadBytes,
media.TotalReadSoftErrors = oldmedia.TotalReadSoftErrors,
media.TotalReadHardErrors = oldmedia.TotalReadHardErrors,
media.MaxCleaningCount = oldmedia.MaxCleaningCount,
media.MediaDescription = oldmedia.MediaDescription,
media.MediaLabel = oldmedia.MediaLabel,
media.MediaFlags = oldmedia.MediaFlags,
media.MediaState = oldmedia.MediaState
From Media INNER JOIN OLDMedia
ON media.medialabel=oldmedia.medialabel
*** End Copy ***
/Haugstrup