Comments
Sort by recent activity
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...
I do encounter the same error if I run the backup from Query Analyzer and our server is not set up with a case sensitive collation. If I run an ordinary SQL Server backup from Query Analyzer it works. / comments
I do encounter the same error if I run the backup from Query Analyzer and our server is not set up with a case sensitive collation. If I run an ordinary SQL Server backup from Query Analyzer it works.
Profiler confirms SQLBackup.exe is connecting to the correct instance. We are using SQL Server 2000 SP3 Enterprise Edition / comments
Profiler confirms SQLBackup.exe is connecting to the correct instance. We are using SQL Server 2000 SP3 Enterprise Edition