1

Topic: almost through DB - SQL Server2008R2 Express

Greetings.
It is adjusted  letters through basis .
All was  until recently.
Now when I try to send the letter I receive :

1) Exception Information ===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.NoQueueDataException
Message: Database Mail shutting down. Mail queue has been stopped.
Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.QueueItem GetQueueItemFromCommand (System. Data. SqlClient. SqlCommand) HelpLink: NULL Source: DatabaseMailEngine
StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueItemFromCommand (SqlCommand c)
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueData (Int32 receiveTimeoutSec)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue (DataAccessAdapter da, Int32 lifetimeMinimumSec)

And when I want to look:

SELECT TOP 100 *
FROM msdb.dbo.sysmail_allitems
ORDER BY last_mod_date DESC;

I receive: Msg 605, Level 21, State 3, Line 1
Attempt to fetch logical page (1:77992) in database 4 failed. It belongs to allocation unit 72057594047102976 not to 72057594046971904.

And if here so I want to look:

SELECT *
FROM msdb.dbo.sysmail_allitems order by 1 desc

That :
An error occurred while executing batch. Error message is: SqlDateTime overflow. Must be between 1/1/1753 0:00:00 PM AM and 12/31/9999 11:59:59 AM PM.
Prompt where to dig, what not so. Can  faced the such.
Punched different , a profile, for sending almost, all early does not work.
Thanks.

2

Re: almost through DB - SQL Server2008R2 Express

MaksProdavayko;
605 unpleasant error.
is?
Here  it is described as to be recovered:
https://www.nucleustechnologies.com/blo … ql-server/