DTS Problems

I just tried to DTS my database from my local machine to my new database here, and I get an error that says, "[SQL-DMO]Unexpected parameter value or other condition"

Does anyone know what is causing this, and how do I get around it so that I can upload my database?

 

[xx(] I found that the dts didnt work either - what I had to do was script the tables and sprocs, and use Query Analyser to rebuild the DB on the remote server, and then use dts to export the data.

Humanitad.org

 

Not the same error - mostly just timing out, but thankfully its a task done only once!

Humanitad.org

 

I don't remember what I finally had to do, but I wa able to get it working back when I needed to get my database uploaded. Of course, now I am trying to create a DTS package to DL my database back to my local machine so that I have a copy of it, and now I am getting that very same error.

Boy would it be nice if a simple BACKUP worked. This is BY FAR the easiest way to go, and would work if a drive would just be mapped so that I could dump the copy into my web folder somewhere.

As it is, the only copy I have of my current database is on the server, and I have been unsuccessful in gettting a copy back to my local machine. [V]

 

Just a note that I regularly receive timeout errors also when trying to transfer my db via dts from my local machine to discountASP.NET. Frustrating!


...Super Mica
___________ [^] www.supermica.net

 

quote:Originally posted by bruce

SQL database backup is rather complex because SQL backup also backup the database permission information. This means that restoration can be complex on a seperate machine.
</blockquote id="quote"></font id="quote">

If you know what you are doing, it can actually be quite easy to do. It means going into the sysusers table and doing some cleanup. However, as it stands, I would rather have that type of backup than what I have now, which is nothing. []