Exit Code 880 Sql Error Code 911
Contents |
Secondary Node Forum for users of Redgate's SQL Backup tool Post a reply 16 posts • Page 1 of 2 • 1, 2 Active\\Active Cluster Secondary Node by MarkJ » Tue Feb 07, 2006 4:17 pm I have installed SQL Backup on to the two servers
Sql Backup Failed With Exit Code: 880
in our cluster. Our setup consists of a default instance of SQL server running on one sql server error codes node and a named instance running on the other. The Default instance installed and is working. The named instance appears to have installed and recognised the correct instance of SQL Server. It does not, however, back anything up. I get the following error message 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 Database2 does exist in sysdatabases and the Database user has rights to back up the database. Can anybody help with this? MarkJ Posts: 14Joined: Tue Feb 07, 2006 3:49 pm Top by petey » Tue Feb 07, 2006 4:50 pm I'm not sure if the service is recognising the named instance correctly. It's probably connecting to the default instance, where Database2 does not exist. Could you pls use Profiler to confirm this? Are you using SQL Server 2005? If so, there is a bug in SQL Backup 4.0 that prevents it from working correctly with certain configurations of named instances on clusters. Version 4.1 fixes this bug. Peter YeohSQL Backup Consultant DeveloperAssociate, Yohz SoftwareBeyond compression - SQL Backup goodies under the hood, updated for version 8 petey Posts: 2339Joined: Sun Apr 24, 2005 11:34 am Top by MarkJ » Wed Feb 08, 2006 9:23 am Profiler confirms SQLBackup.exe is connecting to the correct instance. We are using SQL Server 2000 SP3 Enterprise Edition MarkJ Posts: 14Joined: Tue Feb 07, 2006 3:49 pm Top by petey » Wed Feb 08, 2006 10:30 am Do you encounter the same error if you run the backup from Query Analyzer? Also, is your server set up with a case sensitive collation? Peter YeohSQL Backup Consultant DeveloperAssociate, Yohz SoftwareBeyond compression - SQL Backup goodies under the hood, updated for version 8 petey Posts: 2339Joined: Sun Apr 24, 2005 11:34 am Top by MarkJ » Wed Feb 08, 2006 10:36 am 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 Quer
us about this channel Embed this content in your HTML Search confirm cancel Report adult content: click to rate: Account: (login) More Channels Showcase RSS Channel Showcase 5659002 RSS Channel Showcase 1360143 RSS Channel Showcase 8838263 RSS Channel Showcase 8304152 Channel Catalog Subsection Catalog Articles on this Page (showing articles 521 to 540 of 713) 02/25/14--07:28: _RE: The database fi... 03/14/14--05:31: _RE: Log shipping er... 03/14/14--21:17: _How to Perform SQL ... 03/15/14--02:42: https://forums.red-gate.com/viewtopic.php?t=1836 _RE: How to Perform ... 03/17/14--07:46: _Regarding, which tr... 03/17/14--21:11: _RE: Regarding, whic... 03/18/14--05:43: _Error 880: BACKUP D... 03/19/14--00:20: _In log shipping,do ... 03/19/14--08:49: _RE: Error 880: BACK... 03/19/14--09:52: _RE: SQL Backup 7.0 ... 03/19/14--13:21: _Correct Syntax for ... 03/19/14--13:37: _RE: Correct Syntax ... 03/19/14--15:54: _Delay between backu... 03/20/14--02:22: _RE: SQL Backup 7.0 ... 03/20/14--02:28: http://backup498.rssing.com/chan-6489034/all_p27.html _RE: Delay between b... 03/20/14--02:37: _RE: Correct Syntax ... 03/20/14--07:36: _RE: In log shipping... 03/20/14--14:57: _RE: Delay between b... 03/20/14--16:01: _Restore fails with ... 03/20/14--18:28: _RE: Delay between b... (showing articles 521 to 540 of 713) Browse the Latest Snapshot Browsing All Articles (713 Articles) Live Browser Channel Description: Product Support and Discussion older | 1 | .... | 24 | 25 | 26 | (Page 27) | 28 | 29 | 30 | .... | 36 | newer 0 0 02/25/14--07:28: RE: The database file is larger than the configured maximum size Contact us about this article Hi Manfred, It solve my one problem but still I am facing other problem. I am connect to one of our server suppose "XYZ"via "SQL authentication ". "SQL backup Agent " service run under "XYZ\administrator" user id at "XYZ" server. When I try to restore database via "Red Gate SQL Backup" , then it give me below error for all backup file. Readling Flieli