Forum Discussion

Neil_McFadyen's avatar
18 years ago

timestamp error when moving backupexec database from sqlserver2000 to sqlserver 2005

backupexec version 10.1 Rev 5629  on windows 2003 server
 
when using trying to move backexec database using sqlserver 2005 dtswizard to move bedb database from a sqlserver 2000 database to another server with a sqlserver2005 database, an error message results due to 2 timestamp columns.
 
 
 

Operation stopped...

- Create a TransferProvider. (Success)

- Create a temporary file for destructive SQL. (Success)

- Create a temporary file for constructive SQL. (Success)

- Create a temporary XML file for table metadata. (Success)

- Configure the TransferProvider with files and Source/Destination connection info. (Success)

- Execute the transfer with the TransferProvider. (Error)

Messages

ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [BEDB].[dbo].[vwJobHistory] (
[JobHistoryID] uniqueidentifier NOT NULL,
[TaskTypeID] int NOT NULL,
[JobName] nvarchar(255) NOT NULL,
[UserName] nvarchar(36) NOT NULL,
[OriginalStartTime] nvarchar(50),
[ActualStartTime] nvarchar(50),
[EndTime] nvarchar(50),
[ElapsedTimeSeconds] int NOT NULL,
[IsJobActive] bit NOT NULL,
[FinalJobStatus] int NOT NULL,
[FinalErrorCode] int NOT NULL,
[MachineID] uniqueidentifier NOT NULL,
[MachineName] nvarchar(64) NOT NULL,
[DeviceID] uniqueidentifier NOT NULL,
[DeviceName] nvarchar(128) NOT NULL,
[TargetID] uniqueidentifier NOT NULL,
[JobID] uniqueidentifier NOT NULL,
[ExceptionFlags] int NOT NULL,
[TargetName] nvarchar(128) NOT NULL,
[MediaSetID] uniqueidentifier NOT NULL,
[MediaSetName] nvarchar(128) NOT NULL,
[MediaName] nvarchar(49) NOT NULL,
[ScriptID] uniqueidentifier NOT NULL,
[ScriptName] nvarchar(255) NOT NULL,
[JobLogFileName] nvarchar(255) NOT NULL,
[TotalDataSizeBytes] bigint NOT NULL,
[TotalRateMBMin] real NOT NULL,
[TotalNumberOfFiles] float NOT NULL,
[TotalNumberOfDirectories] float NOT NULL,
[TotalSkippedFiles] float NOT NULL,
[TotalCorruptFiles] float NOT NULL,
[TotalInUseFiles] float NOT NULL,
[UtilityTaskSubType] int NOT NULL,
[EraseType] int NOT NULL,
[SlotNumber] int NOT NULL,
[SlotCount] int NOT NULL,
[TimeStamp] timestamp NOT NULL,
[JobHistoryDetailID] uniqueidentifier,
[ADJNumDomainsProcessed] int,
[ADJNumServersProcessed] int,
[ADJNumResourcesProcessed] int,
[ADJNumResourcesNotProtected] int,
[MediaGUID] uniqueidentifier,
[MediaSide] int,
[FamilyID] int,
[FamilySeqNumber] int,
[FamilyGUID] uniqueidentifier,
[LoginAccountName] nvarchar(255),
[MediaLabel] nvarchar(255),
[Barcode] nvarchar(255),
[SetName] nvarchar(49),
[SetDescription] nvarchar(49),
[ResourceTypeID] int,
[ResourceSubType] int,
[JobType] int,
[JobStatus] int,
[ErrorCode] int,
[ErrorStatus] int,
[DataSizeBytes] bigint,
[RateMBMin] int,
[NumberOfFiles] int,
[NumberOfDirectories] int,
[NumberOfSkippedFiles] int,
[NumberOfCorruptFiles] int,
[NumberOfInUseFiles] int,
[OFOUsed] int,
[ImageUsed] int,
[JHD.EraseType] int,
[JHD.SlotNumber] int,
[JHD.SlotCount] int,
[JHD.StartTime] nvarchar(50),
[JHD.EndTime] nvarchar(50),
[ResourceID] uniqueidentifier,
[LoginAccountID] uniqueidentifier,
[TestRunSubJobStatus] int,
[TestRunSubJobID] uniqueidentifier,
[TestRunRecordType] int,
[TestRunMediaOnlineNearline] int,
[TestRunOverwriteAppend] int,
[TestRunLoginStatus] int,
[TestRunTargetID] uniqueidentifier,
[TestRunMediaSet] uniqueidentifier,
[TestRunOnlineAppendKB] real,
[TestRunTotalAppendKB] real,
[TestRunOnlineOverwriteKB] real,
[TestRunTotalOverwriteKB] real,
[TestRunEngineJobLogFilename] nvarchar(255),
[JHD.TimeStamp] timestamp,
[InfoType] int,
[InfoSubType] int,
[Data] nvarchar(255),
[DataGUID] uniqueidentifier,
[ServerName] nvarchar(255),
[DisplayName] nvarchar(511),
[FinalErrorDescription] nvarchar(255),
[CategoryDescription] nvarchar(255),
[FinalErrorDescriptionDetail] nvarchar(255),
[Description] nvarchar(255),
[TestRunTargetDeviceName] nvarchar(128),
[TestRunMediaSetName] nvarchar(128),
[AgentAccelUsed] int,
[JHD.StartTimeComp] datetime,
[RetryNumber] int,
[MaxRetries] int,
[FinalDisposition] int,
[RuleName] nvarchar(64),
[CopyJobSubType] int,
[ObjectName] nvarchar(255),
[Expr1] nvarchar(255),
[UMIOriginatorDetail] int,
[UMIOriginatorSummary] int,
[AbortUserName] nvarchar(255)
)
" failed with the following error: "A table can only have one timestamp column. Because table 'vwJobHistory' already has one, the column 'JHD.TimeStamp' cannot be added.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

- Execute the destructive SQL. (drop tables) (Success)

- Execute the constructive SQL. (create tables) (Success)

- Create a temporary table transfer package for (Stopped)

- Execute transfer package for (Stopped)

- Copying to (Stopped)

 

 

No RepliesBe the first to reply