I have restored the backups on a different server and it worked great !

I have lots of free space on the disk.

Here is similar discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181098

I use this:

select b.server , a.name, b.step_name,b.sql_message_id, b.sql_severity

from msdb.dbo.sysjobs a, msdb.dbo.sysjobhistory b

where a.job_id = b.job_id

  and (b.run_date = convert(int,convert(varchar,getdate(),112)) or

   b.run_date + 1 = convert(int,convert(varchar,getdate(),112)))

  and b.run_status in (0,3)

Take a look at this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadvnet/html/vbnet09102002.asp

Check this

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q237/6/04.ASP&NoWebContent=1

Stored procedues should be left on the development box.

All I am moving is the tables and data.

I am moving about 16G data on a 1G network. I am trying to copy the tables and data.

Backup takes about 32 minutes