have problem backup database with variable,please help..

• taufikalfarisi

  SSC Veteran

  Points: 204

  More actions

  February 1, 2013 at 4:16 pm

  #269749

  i have try this but not works, please help..

  -----------------------------------

  ALTER PROCEDURE [dbo].[SPDatabaseBackup]

  @DatabaseNamavarchar(200),

  @DatabaseAlamatvarchar(2000)

  AS

  DECLARE

  @DatabaseNama_varchar(200),

  @DatabaseAlamat_varchar(2000),

  @Backupnvarchar(MAX)

  SET @DatabaseNama_= QUOTENAME(@DatabaseNama)

  SET @DatabaseAlamat_ = @DatabaseAlamat+'\'+@DatabaseNama+'.bak'

  SET @Backup= 'BACKUP DATABASE '+ @DatabaseNama_ +

  ' TO DISK = '+ QUOTENAME(@DatabaseAlamat_, '''')

  EXEC (@Backup)

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  February 1, 2013 at 9:57 pm

  #1583637

  You shouldn't be using QUOTENAME on the disk location. Just enclose it in single quotes.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions