April 20, 2015 at 9:18 am
Probably it may help i will check update
April 20, 2015 at 9:59 am
I goggled and found that we can't move resource database.
and i gone through your link, can you give more details about "rebuild performance counters" ?
April 20, 2015 at 10:05 am
I would go the CU2 route first if I were you, I actually hadn't noticed the second page of comments when I wrote my reply.
You only need to rebuild the counters if there are no rows in:
select * from sys.dm_os_performance_counters
April 21, 2015 at 2:40 am
I got 1514 rows when ran above select query.
and we have same setup (Backup in SQL 2014 RTM with Maintenance Plan) in Development server, which is running fine daily without issue.
But same setup in Production Server (also installed RS 2014) backup is getting failed with error message that i posted and its running fine after restart the SQL service for 2 or 3 days.
May 6, 2015 at 9:28 am
I'm getting errors that are somewhat similar to the above posts... Backups are failing with the following error: Wanting to open up a case with Microsoft.. Can someone tell me how to do this... Do I call, do you have to have an account? thanks
Memory
MemoryLoad = 83%
Total Physical = 8191 MB
Available Physical = 1384 MB
Total Page File = 16381 MB
Available Page File = 7867 MB
Total Virtual = 8388607 MB
Available Virtual = 8377044 MB
***Stack Dump being sent to E:\MSSQL\SQL2014\MSSQL12.SQL2014\MSSQL\LOG\SQLDump1489.txt
SqlDumpExceptionHandler: Process 10104 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/05/15 16:25:02 spid 10104
* Private server build.
*
*
* Exception Address = 000007FEEE3E8D40 Module(sqlmin+0000000002C88D40)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address FFFFFFFFFFFFFFFF
* Input Buffer 510 bytes -
* BACKUP LOG [XXXXXXXX] TO DISK = N'K:\Ba
* ckups\XXXXXXXX\XXXXXX_backup_2015_05_05_162502_0110873.trn'
* WITH NOFORMAT, NOINIT, NAME = N'CouponRequest_backup_2015_05_05_162502_
* 0110873', SKIP, REWIND, NOUNLOAD, STATS = 10
May 7, 2015 at 3:42 am
You need to call Microsoft they will guide you and contact numbers are given in below link.
also when you call they will ask your Subscription ID. make sure to have Subscription ID.
https://msdn.microsoft.com/en-us/subscriptions/aa948875.aspx
May 8, 2015 at 7:04 am
Check if other processes are running at the same time, which could cause blocking on the drive/file. Maybe a separate backup job (nothing to do with MSSQL) is locking files, or AntiVirus, or even VSS.
May 29, 2015 at 2:31 pm
We don't have a SubscriptionID with Microsoft, we purchase Sql server licenses from a 3rd party vendor.. I'm still receiving the error however my co-worker found the following 5 files to be missing or hidden... Looks to be .Net Framework files... does anyone know if these are really causing my error (the backup failing due to: * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION ) - Process 9720 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. Is there a trace I can take to perhaps tell me more? Can someone tell me the fields I can use for the trace to capture this error?
Any help would be appreciated... (btw - if I restart the instance the errors stop for serveral days)
-- mscorlib.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\abf62e6545d2802fc60286678a67e6bf\mscorlib.ni.dll4.0.30319.18444
-- System.Configuration.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_64 \System.Configuration\13bb14bb88e6c577c79001039d678bbd\System.Configuration.ni.dll4.0.30319.18408
-- System.Security.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_64\System.Security\a6153cf4b7a0d2e5c0f4f3e02de99150\System.Security.ni.dll4.0.30319.18408
-- System.Xml.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_64\System.Xml\fa4b9cda7a89969191429507a934c352\System.Xml.ni.dll4.0.30319.18408
-- System.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_64\System\4d4a15d5d7968df7dedd4cf853848d90\System.ni.dll4.0.30319.18408
June 1, 2015 at 2:44 am
The .ni in the filenames refers to the "native image" version of the DLL. This is part of standard .NET functionality. Google for NGEN, JIT and MSIL.
Visual Studio can attach listeners to the processes, but this is getting quite involved - above my pay grade 🙂
These compiled system files *could* be doing anything on your system. However, they are not directly linked to MSSQL. I suggest you stop other processes/services on the server and see if that helps the MSSQL backup. It might even be worth re-applying the latest OS service pack (plus subsequent updates), or re-installing .NET.
June 1, 2015 at 10:25 am
Thank you Ten Centuries:
Our networking dept. applied some patched to this server 4 days prior to the backups failing. A developer had been using visual studio on this server but he may have been using the incorrect visual studio version (I think he was using VS 2012).. And we've done a repair on the .NET... Perhaps we should reinstall .Net... Thank you I will look into trying what you suggest..
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply