Hello,

I am trying to import a database from another box using the EM gui. When
I run the command I get the following error. Errors: [SQL-DMO]The Bulk Copy
execution failed. I am having problems with the 1st database and need to
remove the instance. The databases are having problems trying to restore I
have copied all databases(copying by objects) but this one database. Any
suggestions would be greatly appreciated.

Jake

Can you not simply use BACKUP and RESTORE?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jake" <rondican (AT) hotmail (DOT) com> wrote

Allan,

No each time we try to do a restore the restore fails. So I am trying to
somehow get the PK,FK etc out another way

Jake
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

The RESTORE Fails with what error?

I love DTS in the main but never use the Transfer Objects or Move database
tasks.

If you tell us what the error with the restore is then maybe we can get you
moving.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jake" <rondican (AT) hotmail (DOT) com> wrote

Allan,

Take a look at the post under ms.public.sqlserver.server "How to restore
from file". There errors are below.

Jake



errors-
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote