dts import agent

Hi group
I want to copy a DB from one Sql Server 2000 SP3 to antother Sql 2000 Sp3.
Im using the DTS Import agent in Enterprise manager. After a few minutes
Ive got an error Message telling me that the copy process failed.
The Log file of the Enterprise Manager is empty. Any Idea what happened? The
Database has a size of 900 Mb, is that a problem?
Is there another solution to copy the db?
Backup and than restore is not possible because the database I want to copy
use replication.
Any ideas?
thx for any help
BjrnBjrn,
I don't follow why backup and restore is prevented in your situation by the
presence of replication (publisher or subscriber should be fine) - can you
explain more.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hi Paul
I have tried it.
I have build a new DB on my destination Sql Server. Than I have restored the
Databse.
Now I have a dead Databse. Enterprise Manager displays the Icon in grey not
in yellow and behind the Database Name is "loading" written.
I cant delete it, I cant show any properties nothing.
regards
Bjrn
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> schrieb im Newsbeitrag
news:eTNFzlCyGHA.4912@.TK2MSFTNGP03.phx.gbl...
> Bjrn,
> I don't follow why backup and restore is prevented in your situation by
the
> presence of replication (publisher or subscriber should be fine) - can you
> explain more.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>|||I think this is not related at all to replication - I'd guess that you have
restored the database using no_recovery.
Try running "restore database yourdbname with recovery".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hey Paul
Thx for your help.
I dont know what is different but now I have a working restored DB.
regards
Bjrn
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> schrieb im Newsbeitrag
news:u0Y7eFGyGHA.4092@.TK2MSFTNGP04.phx.gbl...
> I think this is not related at all to replication - I'd guess that you
have
> restored the database using no_recovery.
> Try running "restore database yourdbname with recovery".
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>
>