Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bharath63
Starting Member
14 Posts |
 Posted - 2008-12-30 : 07:41:11
|
| Hi All,I have a Backup Job scheduled through the maintenance plan 2000.The Backup job is failing with no clue in the sql server logs.under the maintenance plan in reporting tab, i have a log which display the below error:[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 701: [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.The Sql Agent log shows the below error:Unable to read local eventlog (reason: Not enough storage is available to process this command)SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'abc\xyz'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)i am unable to run the backup job.i have enough space on the drive where the backup files are stored.Any help would be really appreciated.BHARATH |
|
|
ghemant
Starting Member
22 Posts |
Posted - 2008-12-30 : 08:54:22
|
| HI Bharath,Refer below thread if it would be of any help to you http://sql-server-performance.com/Community/forums/p/9407/52129.aspx#52129RegardsHemantgiri S. Goswamihttp://hemantgirisgoswami.blogspot.com/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-31 : 22:26:38
|
| How many databases are involved in Maint plan? Any other jobs running at same time? |
|
|
|
bharath63
Starting Member
14 Posts |
Posted - 2009-01-08 : 18:02:15
|
| The above problem was fixed for me by restarting the sql server agent.BHARATH |
|
|
|
|
|
|
Backup Job Failure