DB backups for production to DR without creating jobs in prod I had two servers(SQL 2005) A and B. B is Production server and A is DR. I want to take backups for B server databases from A server. We can not create any maintenance plans or jobs in B production server. We can create any jobs in DR server to take backups for Prod server. Is it possible? both are in different domain. If the servers are in same domain is it possible? and please send the procedure.

Please help me asap.
I suggest you use Ola Hallengren's maintenance solutions stored procedures to accomplish what you are doing.

These stored procedures will allow you to backup via simple SQL scripts. You could then create a Job from the SQL Server Agent to run those backups once or on a scheduled basis.



Simple Example from the website:

EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Verify = 'Y',
@Compress = 'Y',
@CheckSum = 'Y',
@CleanupTime = 24


This process will allow you to save your backups to a remote storage or locally. 

You could also run this same process using sqlcmd to connect remotely to the server you are trying to backup

sqlcmd -S &lt;ComputerName&gt;\&lt;InstanceName&gt; -i &lt;MyScript.sql&gt; -o &lt;MyOutput.rpt&gt;


And MyScript.sql would contain the backup script from above.

As long as the machine running the script is in same domain as the instance being backed up, there is no need to specify the user and password. This assumes that your domain login has the necessary server permissions to run a backup.  

You must install the maintenance stored procedures before using them to backup, so please be sure to carefully read all instructions at this page.