880 Sql Error Code 911
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering db2 sql error code 911 » Redgate Backup Of "System" databases 13 posts,Page 1 of 212»» Redgate Backup
Sql Server Error 911
Of "System" databases Rate Topic Display Mode Topic Options Author Message Jeff ModenJeff Moden Posted Tuesday, December 16, 2008
Sql Error 911 Sqlstate 22019
9:52 AM SSC-Forever Group: General Forum Members Last Login: Monday, September 26, 2016 3:35 PM Points: 41,436, Visits: 38,770 There was a Red Gate backup job that was backing up the LOG for
Sql Backup Failed With Exit Code: 880
Model on my system. It has been running just fine for a very long time. I added the MASTER and MSDB databases to the job and now it's failing. The backups for the DATA files ofr MODEL, MASTER, and MSDB runs just fine but it doesn't seem to like backing up the LOG for MASTER or MSDB. Anyone know any tricks to do this?Here's the "step" db2 code from the SQL Server Agent that's trying to run but failing...DECLARE @exitcode intDECLARE @sqlerrorcode intexec master..sqlbackup N'-SQL "BACKUP LOG [master, model, msdb] TO DISK = ''\\bi-vault\sqlbackups\BI-DB1\Trans\ '' WITH COMPRESSION = 3, ERASEFILES = 3"', @exitcode OUTPUT, @sqlerrorcode OUTPUTIF (@exitcode <>0) OR (@sqlerrorcode <> 0)BEGIN RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)ENDThanks for the help, folks. --Jeff Moden"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column." Helpful Links:How to post code problemsHow to post performance problems Post #620559 Perry WhittlePerry Whittle Posted Tuesday, December 16, 2008 9:56 AM SSCrazy Eights Group: General Forum Members Last Login: Monday, September 26, 2016 11:57 PM Points: 8,234, Visits: 16,383 Jeffcan you post the actual error from the Redgate Backup log file on the server. It defaults to c:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\instancename -----------------------------------------------------------------------------------------------------------"Ya can't make an omelette without breaking just a few eggs" Post #620562 george sibbaldgeorge sibbald Posted Tuesday, December 16, 2008 9:59 AM
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 2581805 RSS Channel Showcase 2684899 RSS Channel Showcase 8365022 RSS Channel Showcase 7032284 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: _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: _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