cancel
Showing results for 
Search instead for 
Did you mean: 

timestamp error when moving backupexec database from sqlserver2000 to sqlserver 2005

Neil_McFadyen
Level 2
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)

 

 

0 REPLIES 0