February 9, 2015 at 4:08 am
Hi to all. I have moved our ERP system to a new platform (from Windows 2003/sql 2005 to Windows 2012/SQL 2014). The new server resides in a different domain. I created from scratch identical maintenance plans. Both the database and transaction log jobs are failing. Transaction log example below.
Date09/02/2015 10:31:11
LogJob History (Database Plan.Transaction Logs)
Step ID1
ServerMYSERVERNAME
Job NameDatabase Plan.Transaction Logs
Step NameTransaction Logs
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: DOMAIN\AccountName. Started: 10:31:11 Finished: 10:31:12 Elapsed: 1.547 seconds. The package execution failed. The step failed.
Server application logs record events 3041, 12291 and 208.
Has anyone else come across this?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 9, 2015 at 9:20 am
Manual backups also fail. A crash dump is created. I stumbled across this thread http://www.sqlservercentral.com/Forums/Topic1588898-3411-2.aspx. My issue appears similar. I am running 2014 RTM (no CU). I have reviewed the CU's and none of them provide a fix for the issue I am facing.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 9, 2015 at 9:29 am
What does a manual backup fail with?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 9:32 am
Hi.
Backup failed for Server 'SERVER-NAME'. (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError: BACKUP DATABASE is terminating abnormally. (Microsoft.SqlServer.Smo)
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 9, 2015 at 9:34 am
Err, I meant manual backups, as in BACKUP DATABASE ... TO DISK = ....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 9:39 am
🙂
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 9, 2015 at 10:19 am
A server re-boot appears to have resolved the issue. I am now able to execute backups and maintenance plans appear to run OK.
Prior to the reboot I noted when running the maintenance plan the directory's would be created in the disk backup target. If I tried to access the directory Windows displayed message stating I needed admin permissions (I am an admin). I ran gpedit.msc on local machine and disabled 'User Account Control: Run all administrators in Admin Approval Mode'. I am not sure if this fixed the issue or the reboot. I will reverse and test.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 10, 2015 at 2:13 am
Weird.
That's one of the more useless error messages I've seen SQL return too. Nothing more useful in the error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2015 at 4:08 am
Hi. I have checked the logs and found the entry below for one of the failures:
2015-02-09 16:59:17.18 spid69 * BEGIN STACK DUMP:
2015-02-09 16:59:17.18 spid69 * 02/09/15 16:59:17 spid 15036
2015-02-09 16:59:17.18 spid69 * Private server build.
2015-02-09 16:59:17.18 spid69 *
2015-02-09 16:59:17.18 spid69 *
2015-02-09 16:59:17.18 spid69 * Exception Address = 00007FF8FCC72D45 Module(sqlmin+00000000009D2D45)
2015-02-09 16:59:17.18 spid69 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2015-02-09 16:59:17.18 spid69 * Access Violation occurred reading address 00007FF94B2DCAA0
2015-02-09 16:59:17.18 spid69 * Input Buffer 134 bytes -
2015-02-09 16:59:17.18 spid69 * BACKUP DATABASE DB TO DISK = 'C:\temp\DB.Bak'
There is then a load of stack dump information.
Thanks for your time, very much appreciated.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply