-- Table: dbo.SLSLogShipping -- Bill Wunder use admin GO CREATE TABLE [dbo].[SLSLogShipping] ( [DatabaseName] [sysname] NOT NULL , [StandbyServer] [sysname] NOT NULL , [StandbyLinkedServer] [sysname] NOT NULL , [PrimaryLinkedServer] [sysname] NOT NULL , [BackupLocationPath] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [JobName] [sysname] NOT NULL , [NotifyOnFail] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MinuteInterval] [tinyint] NOT NULL , [HoursToKeep] [tinyint] NOT NULL , [MinutesAcceptableLatency] [tinyint] NOT NULL , [NotifyOnLatent] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [BackupThreads] [tinyint] NOT NULL , [BackupPriority] [tinyint] NOT NULL , [InitDt] [datetime] NOT NULL CONSTRAINT [dft_SLSLogShipping__InitDt] DEFAULT (getdate()), [InitUser] [sysname] NOT NULL CONSTRAINT [dft_SLSLogShipping__InitUser] DEFAULT (suser_sname()), CONSTRAINT [pk_SLSLogShipping__DatabaseName] PRIMARY KEY CLUSTERED ( [DatabaseName] ) ON [PRIMARY] , CONSTRAINT [fk_SLSLogShipping__StandbyServer__to__SLSLogShippingConfig] FOREIGN KEY ( [StandbyServer] ) REFERENCES [dbo].[SLSLogShippingConfig] ( [StandbyServer] ) ) ON [PRIMARY] GO