CREATE TABLE [Collector].[LastBackup](
       [SourceServer] [varchar](16) NULL,
       [TestServer] [varchar](16) NULL,
       [Database] [varchar](40) NULL,
       [FileExists] [bit] NULL,
       [RestoreResult] [varchar](400) NULL,
       [DbccResult] [varchar](max) NULL,
       [RestoreStart] [datetime2](7) NULL,
       [RestoreEnd] [datetime2](7) NULL,
       [DbccStart] [datetime2](7) NULL,
       [DbccEnd] [datetime2](7) NULL,
       [BackupDates] [datetime2](7) NULL,
       [BackupFiles] [varchar](max) NULL,
       [CollectionTime] [datetime2](7) NULL

) 

GO