User profile for pamozer

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

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

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

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

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

Need to restore Multiple Databases on the same SQL Instance

For Disaster Recovery purposes I have a directory of full backup files that need to be restored to a single sql instance. Is there any way to either script or use the gui to say restore each of th...

2 followers 9 comments 0 votes

Syntax error: 'teest''' after 'c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb WITH PASSWORD =' / comments

Syntax error: 'teest''' after 'c:\backups\FULL_DB001_superbill_24305_prod_20140219_200928_encr.sqb WITH PASSWORD ='

0 votes

Correct Syntax for Restoring sQBHeaderOnly with Password

I am having issues with the syntax for sqbheaderonly in SQL SERVER Managment Studio EXECUTE master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = ''c:\backups\FULL_DB001_superbill_24305_prod_2...

2 followers 2 comments 0 votes

I figured out the problem. Stupid mistake on my part. Thanks for all your help / comments

I figured out the problem. Stupid mistake on my part. Thanks for all your help

0 votes

Yes. It is the right path and the service account has permissions. What about the syntax error message? / comments

Yes. It is the right path and the service account has permissions. What about the syntax error message?

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

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

How can we help you today?

pamozer

Activity overview