How can we help you today? How can we help you today?
pamozer
Activity overview Badges (0) Posts (3) Comments (10)

Comments

Sort by recent activity
Now I get this error Syntax error: '\\kprod-nas03\sqlbackups\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb''' after '' -SQL "RESTORE DATABASE superbill_2039_prod FROM DISK = ''\\kprod-nas03\sqlbackups\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb'' WITH PASSWORD=''fjfelejl'' SOURCE = '' + @DatabaseName + '', MOVE DATAFILES TO ''D:\SQLData'' , MOVE LOGFILES TO ''D:\SQLLogs'' , MAILTO = ''pam.ozer@kareo.com'', RECOVERY, CHECKDB = 'ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS' Thanks for helping me with this. I'm at my wits end with this :? :? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Need to restore Multiple Databases on the same SQL Instance
Now I get this error Syntax error: '\\kprod-nas03\sqlbackups\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb''' after '' -SQL "RESTORE DATABASE superbill_2039_prod FROM DISK = ''\\kprod-nas...
0 votes
Nope. That didn't work either. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Need to restore Multiple Databases on the same SQL Instance
Nope. That didn't work either.
0 votes
This is the result of the dynameic sql -SQL "RESTORE DATABASE superbill_2039_prod FROM DISK = '\\kprod-nas03\serverupdates\sqlrestore\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb WITH PASSWORD='fjfelej!' ,SOURCE = 'superbill_2039_prod' WITH MOVE DATAFILES TO 'D:\SQLData' , MOVE LOGFILES TO 'D:\SQLLogs' , MAILTO = 'pam.ozer@kareo.com', RECOVERY, CHECKDB = 'ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS' I am still getting the same error Syntax error: 'fjfelej!'' after '\\kprod-nas03\serverupdates\sqlrestore\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb WITH PASSWORD=' --Syntax error: 'fjfelej!'' after '\\kprod-nas03\sqlbackups\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb WITH PASSWORD=' / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Need to restore Multiple Databases on the same SQL Instance
This is the result of the dynameic sql -SQL "RESTORE DATABASE superbill_2039_prod FROM DISK = '\\kprod-nas03\serverupdates\sqlrestore\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb WITH PA...
0 votes
I am having some issues with the syntax. Can you point out where I am going wrong? I am getting the following error Syntax error: 'fjfelej!'' after '\\kprod-nas03\sqlbackups\FULL_DB009_superbill_2039_prod_20140321_112322_encr.sqb WITH PASSWORD=' Create Table #backupFiles(ID Int Identity(1,1),FileName Varchar(128), depth int, isfile int, databasename varchar(64)) Insert into #backupfiles(FileName, depth, isfile) EXEC master.sys.xp_dirtree '\\kprod-nas03\ServerUpdates\SQLRestore\',0,1; Update #backupfiles set databasename= substring(FileName,12,len(filename)-charindex('2014',filename)-case when len(filename)=55 then 4 else 3 end) Create TAble #Restore(ID Int Identity(1,1),FileName Varchar(128), DatabaseName varchar(64)) Insert into #Restore(FileName, DatabaseName) select FileName,Databasename from #backupfiles where filename like '%superbill%' Declare @DbCount int Declare @Counter Int DECLARE @exitcode int DECLARE @sqlerrorcode int DECLARE @sitename nvarchar(128) DECLARE @sql nvarchar(1024) Declare @DatabaseName varchar(64) Set @DBCount=(Select Max(ID) from #Restore) SET @counter=(Select Min(ID) From #Restore) While @Counter<=@DBCount Begin SET @sitename = (Select FileName from #Restore where ID =@Counter) Set @DatabaseName= (Select DatabaseName from #Restore where ID =@Counter) SET @sql = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''\\kprod-nas03\sqlbackups\' + @sitename + ' WITH PASSWORD=''fjfelejl'' SOURCE = ''' + @DatabaseName + ''' WITH MOVE DATAFILES TO ''D:\SQLData'' , MOVE LOGFILES TO ''D:\SQLLogs'' , MAILTO = [url=''pam.ozer@kareo.com]''pam.ozer@kareo.com[/url]'', RECOVERY, CHECKDB = ''ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS''' EXEC master..sqlbackup @sql, @exitcode OUT, @sqlerrorcode OUT Set @Counter=@Counter+1 END ---- drop table #backupFiles, #Restore / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Need to restore Multiple Databases on the same SQL Instance
I am having some issues with the syntax. Can you point out where I am going wrong? I am getting the following error Syntax error: 'fjfelej!'' after '\\kprod-nas03\sqlbackups\FULL_DB009_superbill_...
0 votes
Syntax error: 'teest''' after 'c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb WITH PASSWORD =' / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Correct Syntax for Restoring sQBHeaderOnly with Password
Syntax error: 'teest''' after 'c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb WITH PASSWORD ='
0 votes
Yes. It is the right path and the service account has permissions. What about the syntax error message? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Using a Password file with sqb2mtf command line
Yes. It is the right path and the service account has permissions. What about the syntax error message?
0 votes
I figured out the problem. Stupid mistake on my part. Thanks for all your help / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Using a Password file with sqb2mtf command line
I figured out the problem. Stupid mistake on my part. Thanks for all your help
0 votes
Thank you for all your help. Can you tell my why I am getting a syntax error with this? EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [10163] TO DISK = ''\\pd-cifs-1\sql_backups\db001\<AUTO>_encr.sqb'' WITH PASSWORD = ''FILE:C:\redgate\dcr.txt'', KEYSIZE=256,CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4" ' SQL Backup v7.6.0.29 Syntax error: 'FILE:C:\redgate\dcr.txt' after '=' Password file does not exist: C:\redgate\dcr.txt (2 row(s) affected) name value exitcode 850 sqlerrorcode 0 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Using a Password file with sqb2mtf command line
Thank you for all your help. Can you tell my why I am getting a syntax error with this?EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [10163] TO DISK = ''\\pd-cifs-1\sql_backups\db001\<AUTO&...
0 votes
Do you know if I can ecrypt witht a password file and decrypt with just the password using the converter? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Using a Password file with sqb2mtf command line
Do you know if I can ecrypt witht a password file and decrypt with just the password using the converter?
0 votes
My question isn't clear. I want to use a password file instead of a hard coded password,. Can I use that with the sqb2mtf? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Using a Password file with sqb2mtf command line
My question isn't clear. I want to use a password file instead of a hard coded password,. Can I use that with the sqb2mtf?
0 votes
Total activity
16
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3