I am transfering data from a production server to a test
sever. I started a transfer with the DTS wizard then I
realized that I had the name spelled wrong in the to part
so I removed that db from the drop down list. Now when I
try to do another transfer I get the following error
message.
Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
it alredy exists.
When I check the test server this file does exist.
What do I need to do to get my transfer to go?
Can I just delete the above mentioned file?
What is the purpose of the data folder?What are you talking about?
I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
Whats the to part?
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
Then dont try to re-create it.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
Of course you can. But keep in mind this is a db file. It
sounds though as you just created it so it's probably
empty. Drop the db from Enterprise Manager.
Why are you exporting to a file anyways?
>--Original Message--
>I am transfering data from a production server to a test
>sever. I started a transfer with the DTS wizard then I
>realized that I had the name spelled wrong in the to part
>so I removed that db from the drop down list. Now when I
>try to do another transfer I get the following error
>message.
>Cannot create file 'C:\MSSQL7\DATA\dbGrade.mdf' because
>it alredy exists.
>When I check the test server this file does exist.
>What do I need to do to get my transfer to go?
>Can I just delete the above mentioned file?
>What is the purpose of the data folder?
>.
>|||The to part that I was refering to is on the Chose Destination page of the DTS wizard in the database drop down list. In that list it has a new option. After selecting that I typed in the name of the database that I want to create with the data transfer. I am not trying to create the file that gives me the error I assume that this is something that is created by the DTS.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment