Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1438
  • Last Modified:

Error: The data portion of event 19003 from MSSQLSERVER is invalid.

Hello,

I see this error msg in the Events Viewer, I did re-search and see that it's not a big deal but I never use to get this msg. I'm using System Account to run MS SQL and permission is good... I checked the system Permission on the Disk and I even search Microsoft and got Article 283811... I followed all that... Stopped and Started MS SQL but still getting the error msg....

I started to get this msg when I did the following:

- Stop the SQL, De-attached a database, then moved data file to another folder and attached it again using another name.... this is the only thing that was done... and then started to get the error msg...I checked the permission on the new folder and Admin has full permission.

Any idea?

Thanks
0
ezzadin
Asked:
ezzadin
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Which version of sql server ? and whoch OS
0
 
ezzadinAuthor Commented:
SQL 2000 (SP4) and OS: 2k server
0
 
pai_prasadCommented:
and attached it again using another name

all u wanted is to rename the db..is it???

did u try 2 reattach with the same name and rename instead?
0
 
ezzadinAuthor Commented:
well... ok this is what I did:

I had a db called DB1, I detached DB1 and move the data file to another folder... then attached DB1 back to original state basically (same data file).. then Attached the moved data file and named it DB2...

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now