I'm working with SQL SERVER 2005 SP2.
I have a working and a steady environment of LOG SHIPPING for quite a while.
Yesterday, the Restore job of the LOG SHIPPING in the DR server failed with the locking error (the log starts from the last line and goes up):
05:02:38.34 *** Error: The log backup file 'C:\database\LogShipping\20100927021501.trn' was verified but could not be applied to secondary database '05:02:37.42 *** Error
View Complete Post
View Complete Post
I am New To Work With C#.I need To Retrieve The All Error Log In SQL Server.I Had Done All The Logs Except Database Mail Error Log. I need an An Help for How To Retrieving The Database Mail Error Log through C# Coding.
I'm having a problem in sharepoint when trying to create a new site from a custom template - I am getting the below error:
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
issues with Microsoft SharePoint Foundation.
Correlation ID: [long hex code]
However when I look in the ULS logs there is no mention of this correlation ID. I have turned the logs up to Verbose on everything, then reproduced the error, and still I can't find the error. Is it possible that this error is coming from another subsystem
like ASP or IIS? I have looked in the IIS logs and can find the HTTP requests but nothing to do with why the error occurs.
Any help would be appreciated - I feel like if I could find the correlation ID I could at least start to work out what the error is!
I'm restoring several sql 2000 user databases on a sql 2008 r2 box, but sometimes I receive the following error
Error: 928, Severity: 20, State: 1
During upgrade, database raised exception 156, severity 25, state 1, address 0000000001C05A9F. Use the exception number to determine the cause.
So the error occured after the restore and while upgrading the database schema from version: 539 to 661.
However I notice that if I try to restore it again with the same statement, sometimes it goes sometimes it doesn't.
I'm not finding any 823,824 or 825 errors on SQL log.
The database compatibility level is 80.
While running Upgrade Adivsor on the database I saw 27 objects that use the older outer join sintax *=. However being that just a warning I don't think that's the cause, moreover because if I retry sometimes the restore completes succesfully.
Does anybody knows what is this?
Is this the I/O subsystem failing?
Why is this intermitent?
How do I fix it?
Thanks in advance.
Please can you help out in this issue as this is something critical. Thanks much in advance.
when user clicks site usage reports (site actions > site settings) displays error as unknown error, and user is admin for the site.
This is on particular site. This problem is only for one user and rest of the users able to get the reports when hits on site usage reports.
I have checked with user . he is getting same problem on other browsers as well.
as pat of investigation we have migrated this site to other environment and asked user to che