Comments
Sort by recent activity
For the 8198 error message, make sure that your domain account name for the SQLBackup service exactly matches your what is in the windows domain. Ex. if the account is XXXX\sqlusr in the windows domain, make sure the account for the service mathes the exact syntax.
We discovered this issue since some of our servers use the Latin 1 General Bin collation. We had entered xxxx\SQLUSR for the sqlbackup service which due to our sql server collation was not matching the account in the windows domain. The end result was the sql error 8198.
Changing the service account to exactly match the account in the windows domain solved the issue. / comments
For the 8198 error message, make sure that your domain account name for the SQLBackup service exactly matches your what is in the windows domain. Ex. if the account is XXXX\sqlusr in the windows ...
The link for error 8198 fixed our problem. Bottom line is to make sure that your service account matches your collation. / comments
The link for error 8198 fixed our problem. Bottom line is to make sure that your service account matches your collation.
I am receiving the following errors when running a restore:
Ex.
5/10/2007 11:00:48 AM: Error 890: RESTORE DATABASE permission denied for database: (Test)
5/10/2007 11:00:48 AM: SQL error 8198: Could not obtain information about Windows NT group/user 'domain\user account'.
Have followed the instructions per this posting of granting my domain\user account access to the master database
Changed service account to user\domain
Any ideas to what can is causing and work around for the sql error 8198
and Error 890? / comments
I am receiving the following errors when running a restore:
Ex.
5/10/2007 11:00:48 AM: Error 890: RESTORE DATABASE permission denied for database: (Test)
5/10/2007 11:00:48 AM: SQL error 8198: Cou...
Search the string for carriage return which is char(13) and replace with spaces seems to work. Also, can do the same for tab key.
Ex>
SET @sqlstring = 'master..sqlbackup N' + '''-SQL '+ '"'+ 'BACKUP DATABASE ' +
' TO DISK = ' + '' + 'WITH DIFFERENTIAL,COMPRESSION=1' + '"' + ''''
SET @sqlstring = REPLACE(@sqlstring,CHAR(13),'')
EXEC @rtn = sp_executesql @sqlstring / comments
Search the string for carriage return which is char(13) and replace with spaces seems to work. Also, can do the same for tab key.
Ex>
SET @sqlstring = 'master..sqlbackup N' + '''-SQL '+ '"'+ 'BACK...
Receive the following error when code is broken into seperate lines.
SQL Backup v4.6.0.815
Syntax error: '
DISK' after ','
name value
exitcode 850
sqlerrorcode 0
Do not see error when statement is one line. Can you verify. / comments
Receive the following error when code is broken into seperate lines.
SQL Backup v4.6.0.815
Syntax error: '
DISK' after ','
name value
exitcode 850
sqlerrorcode 0
Do not see error when statement is ...
Hi,
Any plans to add a retry option to your product if the file copyto fails to copy the file to the specified directory? / comments
Hi,
Any plans to add a retry option to your product if the file copyto fails to copy the file to the specified directory?
thanks / comments
thanks
Hi Pete,
I don't this will work because Redgate will still processes all log files present in the log directory regardless of the log file timestamp.
What we have done is delay processing of individual log files by 4 hrs based on log file timestamp.
Ex.
We log backup our production database every 30 minutes and copy to standby. Our log ship job runs every hour and only processes the individual log files which are over 4 hrs. We have a custom script which looks at the individual log files in the log directory and grabs files based on filename timestamp to process.
ex. script
Declare int
Set @DelayMins = 240
create table #dir
(
[FileName] varchar(2000)
)
select @cmd = 'dir /B ' + @SourcePath + '*.sqb'
insert #dir exec master..xp_cmdshell @cmd
-- Delete anything which is not a log backup for this database
delete #dir
where [FileName] is null
or [FileName] not like '%.sqb'
or [FileName] not like '%^_log^_%' escape '^'
or [FileName] not like @DBName + '^_log^_%' escape '^'
-- Delete anything that is less than @DelayMins minutes old
delete #dir
where [FileName] > @LastFile
while exists (select * from #dir)
begin
select top 1 @filename = [FileName]
from #dir d
order by right([FileName],20)
if not exists (select 1 from #restores where [FileName] = @filename)
begin
print convert(varchar(25),getdate(),121) + ' Restoring ' + @DBName + ' from ' + @filename
set @StandByFile = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\UNDO_' + @DBName
-- Restore log
select @cmd = 'master..sqlbackup '
+ ' -SQL restore log '
+ @DBName
+ ' from disk = '''
+ @SourcePath
+ @filename
+ ''' with standby = '''
+ @StandByFile + ''''
exec(@cmd)
end / comments
Hi Pete,
I don't this will work because Redgate will still processes all log files present in the log directory regardless of the log file timestamp.
What we have done is delay processing of indivi...
Excellent idea!
Thanks! / comments
Excellent idea!
Thanks!