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 |
|
iwenc01
Starting Member
4 Posts |
 Posted - 2008-04-01 : 13:21:47
|
| Hello. I setup a new maintenance plan for my SQL2005 SP2 server to do a full backup and transaction log backup on all databases (System and 3 User defined).Every time I execute the maintenance plan, I get the following error in the job history, and no backups are made:MessageExecuted as user: AD-ENT\MKTSQLService. ...00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:13:35 PM Error: 2008-04-01 12:13:45.09 Code: 0xC00291EC Source: {AE791AB6-1317-4803-9C53-444B45DAD533} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2008-04-01 12:13:45.09 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2008-04-01 12:13:45.14 Code: 0xC0024104 Source: Back Up Database (Full) ... The package execution fa... The step failed._____________________________________________________The MKTSQLSERVICE account is the account setup for the SQL Server Agent Service to use, is in the Administrators group of the server OS, and has been granted SA in SQL2005.What am I missing???Thanks! |
|
|
iwenc01
Starting Member
4 Posts |
Posted - 2008-04-01 : 13:33:13
|
| Actually, I am running SQL2005 SP1.Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-01 : 14:18:09
|
| Are you Sysadmin ? Try running with your account with 1 database |
|
|
|
iwenc01
Starting Member
4 Posts |
Posted - 2008-04-01 : 16:23:35
|
| I can run an individual backup of each database manually. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-01 : 23:12:12
|
| >> transaction log backup on all databases (System and 3 User defined).System dbs have simple recovery model by default, so you can't backup log for system dbs. |
|
|
|
|
|
|
Maintenance Plan Keeps Failing