Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 'Execute SQL Server Agent Job' Error

Author  Topic 

mbehring
Starting Member

4 Posts

Posted - 2012-01-04 : 22:38:28
Hi all,

I am getting errors at the "Execute SQL Server Agent Job" step. When checking the log I can notice messages like:

"There is already an open DataReader associated with this Command which must be closed first."

I am trying to copy 5 Databases and this message happens on all 5 in the log file.

The source server is Windows 2008 Standard R2 32bits running SQL Server 32bits. The target server is Windows 2008 Datacenter 64bits running SQL Server 64bits. Could this OS difference (32 and 64) be a problem?

There is nothing in the destination server, I mean, no database. I am keeping the original database names. My intention is to create a copy of these databases to setup a Replication scenario.

Any help is appreciated.

Mario

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-04 : 22:40:48
Don't use the copy database wizard. Use backup/restore instead. Here is how I do it via a job: http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -