Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2006-06-30
6
1,382 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Is this spec enough for a developer or is it just blabble ? 1 36
SQL, add where clause 5 23
sql 2016 data tools breakdown.. 1 13
SQL Recursion 6 18
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

856 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