<div>
Was the target device and database sized as large or larger than the source? &nbsp;I haven't run transer manager as a scheduled event, but it might be the issue<br />

</div>


Was the target device and database sized as large or larger than the source?  I haven't run transer manager as a scheduled event, but it might be the issue


<div>
The size of the target database is the same as the source.<br />

</div>


The size of the target database is the same as the source.


<div>
Does the transaction log on targed Base are cutted on checkpoint?<br />
<br />
and second the SQL Executive is not a bug free app<br />

</div>


Does the transaction log on targed Base are cutted on checkpoint?

and second the SQL Executive is not a bug free app


<div>
<div class="content wysiwyg-content">
My needs are for transfering 50 tables from one server to another one. I use the transfer management interface of SQL Entreprise Manager (Database/Object Transfer). I scheduled the transfer by night under the scheduled task feature. My problem is the transfer for the first 20 tables are working but after that the transfer stopped and i have nothing on the log explaining that. We have SQL Enterprise manager 6.5 and the service pack 4.0 is installed.<br />
<br />
Do you have any idea about this problem or another technique for transferring tables or do you know a third party product?<br />
<br />
Note: The replication is not a solution for us
</div>
</div>


My needs are for transfering 50 tables from one server to another one. I use the transfer management interface of SQL Entreprise Manager (Database/Object Transfer). I scheduled the transfer by night under the scheduled task feature. My problem is the transfer for the first 20 tables are working but after that the transfer stopped and i have nothing on the log explaining that. We have SQL Enterprise manager 6.5 and the service pack 4.0 is installed.

Do you have any idea about this problem or another technique for transferring tables or do you know a third party product?

Note: The replication is not a solution for us

Database/Object Transfer stopped with no log

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.