Solved

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

Posted on 2006-06-30
6
1,380 Views
Last Modified: 2012-08-13
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
Comment
Question by:ezzadin
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17019420
Which version of sql server ? and whoch OS
0
 

Author Comment

by:ezzadin
ID: 17019551
SQL 2000 (SP4) and OS: 2k server
0
 
LVL 10

Accepted Solution

by:
pai_prasad earned 500 total points
ID: 17019649
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
 

Author Comment

by:ezzadin
ID: 17019727
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now