June 13, 2003 at 6:41 am
Hi,
I am trying to do a backup and restore of my database to another server, and I keep on getting device not online after I created the SQLagent account on the remote server. Can somebody give me the sp_addumpdevice command to use in creating the dumpdevice in my Sql server? Thanks
June 13, 2003 at 7:34 am
Are you creating the backup device on a remote server?
To backup to a remote server, you should map from your db, the disk in wich you plan to backup. But you should do it inside SQL so the agent recognize the unit you add to the remote disk.
For example, use with xp_cmdshell the NET USE DOS command to map to a remote disk
June 13, 2003 at 7:42 am
Where inside the SQL Server? Can you send me a sample code command?
June 14, 2003 at 8:12 am
On the remote server you will need to create a share and make sure that MSSQLServer can write to the share. Imagine your server is called sql1 and the share is called remote, the syntax would be:
sp_addumpdevice 'disk','MyRemoteDevice','\\sql1\remote\mybackupfile.bak'
The UNC path must be used to backup to a remote server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply