July 22, 2003 at 7:42 am
I have 2 server name TDA and PDA. I would like to do a backup of my databases on PDA to TDA. Using sp_addumpdevice, how do I create the remote backup on TDA? Please send me the actual command syntax.
July 22, 2003 at 8:16 am
1. Create a share directory in TDA and allow SQL Server service account in PDA to be able to write to it.
2. Backup database pubs to disk = '\\TDAMachinename\ShareName\pubs_20030722.bak'. For details about Backup command, See BOL.
July 23, 2003 at 10:54 pm
1. Create a shared folder on TDB.
2. Map to the folder from PDB.
3. Create a backup device say dev1 on PDB with physical location the map folder.
4. On PDB, run backup with device name dev1.
July 23, 2003 at 11:11 pm
-- Should do the job
Backup Database MYDATABASE to disk = '\\TDAMachinename\ShareName\pubs_20030722.bak'
-- Actual sp_addumpdevice
USE master
EXEC sp_addumpdevice 'disk', 'networkdevice','\\TDAMachinename\ShareName\pubs_20030722.bak'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply