Comments
Sort by recent activity
The SQL Backup Agent service user has Full Control rights on the folder and file / comments
The SQL Backup Agent service user has Full Control rights on the folder and file
I get this message
Reading SQB file header of "C:\Data\Backup\abackup.sqb" Error 560: File does not exist: C:\Data\Backup\abackup.sqb
There are seven database files within this backup / comments
I get this message
Reading SQB file header of "C:\Data\Backup\abackup.sqb" Error 560: File does not exist: C:\Data\Backup\abackup.sqb
There are seven database files within this backup
oops I installed it to the wrong instance - sorry / comments
oops I installed it to the wrong instance - sorry
I used the -I parameter to install thanks. However when I run the script I get the error message
Syntax error: 'MAXDATABLOCK' after ',' / comments
I used the -I parameter to install thanks. However when I run the script I get the error message
Syntax error: 'MAXDATABLOCK' after ','
Hi
I'm helping Brian with the install. When running the setup Brian was sent, it will not let me input the correct SQL Server instance name, it just lets me select local (which we cannot use due to our configuration) and another instance I do not want to install onto.
Can you send me a new setup please.
Thanks
Mark / comments
Hi
I'm helping Brian with the install. When running the setup Brian was sent, it will not let me input the correct SQL Server instance name, it just lets me select local (which we cannot use due to...
Yes / comments
Yes
I can now see this query running on the wrong instance - how do I fix that? / comments
I can now see this query running on the wrong instance - how do I fix that?
Can you tell me the name of the query that checks for rights so I can specifically filter profiler for that. What I haven't told you is these are all busy production servers and I am filtering profiler output. / comments
Can you tell me the name of the query that checks for rights so I can specifically filter profiler for that. What I haven't told you is these are all busy production servers and I am filtering prof...
I just see a very similar query to the one I just posted / comments
I just see a very similar query to the one I just posted
The names have been changed to protect the innocent but the following is the only query I see is:
exec sp_executesql N'exec sp_executesql @P1', N'@P1 nvarchar(223)', N'exec master..sqlbackup N''-SQL "BACKUP DATABASE [Database2] TO DISK = ''''\\sql\BackUps\FULL_(local)_Database2_20060207_153832.sqb'''' WITH NAME = ''''<AUTO>'''', DESCRIPTION = ''''<AUTO>'''', COMPRESSION = 3"'''
The response to this is:
Backing up Database2 (full database) to:
\\sql\BackUps\FULL_(local)_Database2_20060207_153832.sqb
Error 880: BACKUP DATABASE permission denied in database: (Database2)
SQL error 911: Could not locate entry in sysdatabases for database 'Database2'. No entry found with that name. Make sure
that the name is entered correctly.
SQL Backup exit code: 880
SQL error code: 911
exitcode 880
sqlerrorcode 911
filename01 \\sql\BackUps\FULL_(local)_Database2_20060207_153832.sqb / comments
The names have been changed to protect the innocent but the following is the only query I see is:
exec sp_executesql N'exec sp_executesql @P1', N'@P1 nvarchar(223)', N'exec master..sqlbackup N''-SQ...