DTS for backups, intermittent user related failure.

F

fischermx

Perch
Note this is a strange problem. It happens some times, it does not happen all the time.
I have a DTS to make copies from my database to my development machine. It had worked most of the times. However, some times I get the error "Server user "myusername" is not valid user in database "rwterps_dbEMIS".
Note, that my database name IS NOT rwterps_dbEMIS. I have no idea who this rwterps_dbEMIS database belongs to, it is not mine.
So, the error message is correct, "myusername" is not valid user there, of course, it is not mine, but I'm not trying to connect there.
I have the DTS saved in my local computer and it had worked, it just not work all time. It works after trying and trying and trying, then suddenly it works. Please, don't come with orphan users related advise. It is not related to orphan users due it works some times.
Have you received this kind of error report from other users ?
What can I do to don't have it ?
 
I have a feeling it is related to the edit of the master DB that MS recommends to speed up MSSQL EM, I will see if anyone else has this issue in the hosting community.
 
Thanks.

I researched on the microsoft groups and found a some posts about it. Some unanswered and some advising on orphan users, so none of them a solving solution.
A post in a forum told about a possible corruption on the returning data on slow connections, but I have a 1Mbps DSL connection from home, very fast for most things. I'd discard this, but who knows.
 
actually when talking mssql, less than 10mb upstream is "slow" (sql 2000 that is), but still, I have not heard of this and it should not be an issue, so I will have to research it, I have already put in a very long day, it will go on tomorrow's todo along with another secret that will be revealed tomorrow :D
 
I know this doesn't help but just FYI, I haven't had much luck using DTS to backup MSSQL for a DotNetNuke site. Sometimes it works but it usually comes up with weird messages about key violations and suggestions that my local db is corrupt which I know its not because I've created it moments before trying the transfer. I take the precaution of shutting down the web service while I'm doing it so that the db is not changing but that doesn't seem to help.

I got Jodo support to make a backup for me and that restored on my local machine no problem at all.

There has been talk from time to time of Jodo providing some sort of automated means for a user to get a SQL backup. I know Stephen has thought about it :) That's definitely still my number one (and really only) item for the wishlist.

Ross
 
I am still trying to find a way to do it AND integrate to hsphere, I am trying to help someone (third party) develop this with some of my ideas.
 
You must log in or register to reply here.
Back
Top