Error using SQL Safe to back-up DB

• Chrisb-529708

  SSC Enthusiast

  Points: 177

  More actions

  September 22, 2008 at 6:45 am

  #124738

  Error:

  BACKUP Eureka_DEU...FAILED.

  Server instance: GB2DS060DIA27, Database: Eureka_DEU [SQL Native Client]Encryption not supported on the client.

  [SQL Native Client]Client unable to establish connection [SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

  Script:

  DECLARE @DatabaseName nvarchar(255)

  DECLARE @DatabaseName2 nvarchar(255)

  DECLARE @BackupPathAndFilename varchar(255)

  DECLARE @TruncateOnly int

  DECLARE @Debug int

  DECLARE @Description nvarchar(1024)

  DECLARE @BackupName nvarchar(255)

  DECLARE @BackupType nvarchar(255)

  DECLARE @File nvarchar(255)

  DECLARE @FileGroup nvarchar(255)

  DECLARE @Overwrite int

  DECLARE @Exclude nvarchar(1024)

  DECLARE @NoTruncate int

  DECLARE @NoSkip int

  DECLARE @verify int

  DECLARE @WindowsUsername nvarchar(255)

  DECLARE @EncryptedWindowsPassword nvarchar(255)

  DECLARE @Delete nvarchar(20)

  DECLARE @FailOnMirrorError int

  DECLARE @MirrorFile nvarchar(255)

  DECLARE @CopyOnly int

  DECLARE @checksum int

  DECLARE @ContinueAfterError int

  DECLARE @ReadWriteFileGroups int

  DECLARE @Returncode int

  DECLARE @Verbose int

  SET @DatabaseName = 'Eureka_DEU'

  SET @BackupPathAndFilename = 'H:\MSSQL\BACKUP\Eureka_DEU.safe'

  SET @Debug = 1

  SET @Description = 'This is a backup of pubs'

  SET @BackupName = 'Eureka_DEU_backup'

  SET @BackupType = 'Full'

  EXEC @Returncode = [master].[dbo].[xp_ss_backup]

  @database = @DatabaseName,

  @filename = @BackupPathAndFilename,

  @desc = @Description,

  @backupname = @BackupName,

  @backuptype = @BackupType,

  @exclude = @Exclude,

  @notruncate = @NoTruncate,

  @overwrite = @Overwrite,

  @verify = @verify,

  @database = @DatabaseName2,

  @checksum = @checksum,

  @continueaftererror = @ContinueAfterError,

  @copyonly = @CopyOnly,

  @file = @File,

  @debug = @Debug,

  @delete = @Delete,

  @filegroup = @FileGroup,

  @failonmirrorerror = @FailOnMirrorError,

  @mirrorfile = @MirrorFile,

  @noskip = @NoSkip,

  @readwritefilegroups = @ReadWriteFileGroups,

  @verbose = @Verbose,

  @truncateonly = @TruncateOnly

  IF @Returncode != 0

  BEGIN

  RAISERROR

  ('Backup failure of database %s.', 16, 1, @DatabaseName)

  END

• homebrew01

  SSC Guru

  Points: 55544

  More actions

  October 7, 2008 at 12:28 pm

  #881885

  Did you contact Idera support ?