March 29, 2016 at 5:41 pm
Hi All ,
I have just moved the databases from 1 server to another server (I performed Attach detach method for user databases )
When I checked in SQL error log , it shows up :
Error 50001, severity 11, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
Error: 18054, Severity: 16, State: 1.
Is it something that I need to be worried about ?
Any feedback is highly appreciated
Thank you
March 30, 2016 at 12:00 am
WhiteLotus (3/29/2016)
Hi All ,I have just moved the databases from 1 server to another server (I performed Attach detach method for user databases )
When I checked in SQL error log , it shows up :
Error 50001, severity 11, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
Error: 18054, Severity: 16, State: 1.
Is it something that I need to be worried about ?
Any feedback is highly appreciated
Thank you
Quick questions, are the servers running the same version of SQL Server?
😎
What is the output of this query on the originating server?
SELECT
SM.message_id
,SM.language_id
,SM.severity
,SM.is_event_logged
,SM.text
FROM sys.messages SM
WHERE SM.message_id = 50001
AND SM.language_id = 1033;
March 30, 2016 at 3:55 am
Are the databases online? Do they pass a consistency check? Those are my primary concerns.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply