Good question about the MEDIANAME option, you can assign MEDIANAME to a disk backup device (not sure why I did at the time). I since recreated 3 disk backup devices...

Peter thanks for the suggestions. I don't mean to take up all your time. I double checked all permisions for the SQL Agent and Server and have run xp_cmdshell dir...  that works fine...

Thanks! I have  downloaded that FTP task dll and will be implementing it soon. Thanks again!

How do you break up a media set (don't want to delete the devices if I don't have to)??? Can I just delete it from the backupmediaset table or do I...

This is from the logs. I have delved into permissions issues but I run all instances of SQL on all servers with the same account- an enterprise admin account.

BackupDiskFile:

Thanks for the responses. I have created an SP that will restore the database on Server B when there isn't a media set involved but the sample I provided you...

Thanks Peter.  I will have to look into your product.Mirrored backups would be pretty nice.  Any words on my restore SP though???? 

Vladan thanks also for the help. I have an issue with my second step:

EXEC AVB1\AVB1.msdb..sp_start_job 'UpdateMTS_AVB1'                   

This errors cause of incorrect syntax near '\'   

 AVB1\AVB1 is another instance of SQL on...

In EM when you create a backup device and then use and that device to backup a database it creates a job in SQL Agent. You can open those jobs and add multiple...

Jonathan that works well, I created a package that ran an SP that backed up the DB to the remote server and on success it executed the package task that...

Thanks Brian,

I assumed that the programmer just coded multiple case strings to cover all name variations of one server, he has the IPs,NETBIOS Name,URL all from that web/e-mail server, it's got...

All the login credentials are the same.

  The web server/e-mail server has dual nics, NIC A- 192.168.2.42(internal) connected to the switch for communcation with the rest of the network. NIC B 192.168.1.43 directly into Firewall that...

Everything went great! I got my database's moved accorrding to Steve's instructions within 15 mins.  I made a few typo errors at first so I edited the Registry to reflect...

Thanks for the advice, I will start over (thank God it doesn't take long to reinstall SQL) haven't had a chance to fiddle with this the past few days.  I have had...

Thank you Steve. I can't query the sysdatabases (tried numerous times) I get erros within QA.

Server: MSG:17, Level:16, State:1, Line:0

[Microsoft] [ODBC SQL Server Drive] [Shared Memory]Sql Server does not...