Backup of the Base of Data

I am trying to create a routine of Backup of my base of data, the problem
hey that am not getting to send the backup file for another it conspires
connected in the net. For instance:
EXEC sp_addumpdevice 'disk', 'ArquivoBackup', '\\Estacao_1\C\Backup.dat'
/*ateh aqui tudo bem...*/
BACKUP DATABASE BaseDados TO ArquivoBackup
/ * here he shows the mistake: "Cannot open backup device
'ArquivoBackup'.Device error or device off-line. See the SQL Server error
log for more details.*/
EXEC sp_dropdevice 'ArquivoBackup'
It will be that somebody has some idea of how to solve that problem or then
an idea of how to do the backup for a remote station.
Thank youJust try this, replace the C drive with C$. Please see to that the OS user
you have logged in has sufficiant previlage in C$ of Estacao_1 server.
EXEC sp_addumpdevice 'disk', 'ArquivoBackup', '\\Estacao_1\C$\Backup.dat'
go
BACKUP DATABASE BaseDados TO ArquivoBackup
go
EXEC sp_dropdevice 'ArquivoBackup'
Thanks
Hari
MCDBA
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:uj7ts2bnDHA.2512@.TK2MSFTNGP09.phx.gbl...
> I am trying to create a routine of Backup of my base of data, the problem
> hey that am not getting to send the backup file for another it conspires
> connected in the net. For instance:
> EXEC sp_addumpdevice 'disk', 'ArquivoBackup', '\\Estacao_1\C\Backup.dat'
> /*ateh aqui tudo bem...*/
> BACKUP DATABASE BaseDados TO ArquivoBackup
> / * here he shows the mistake: "Cannot open backup device
> 'ArquivoBackup'.Device error or device off-line. See the SQL Server error
> log for more details.*/
> EXEC sp_dropdevice 'ArquivoBackup'
> It will be that somebody has some idea of how to solve that problem or
then
> an idea of how to do the backup for a remote station.
> Thank you
>|||Make sure that the SQL Server service account has permissions on the share.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Frank Dulk" <fdulk@.bol.com.br> wrote in message news:uj7ts2bnDHA.2512@.TK2MSFTNGP09.phx.gbl...
> I am trying to create a routine of Backup of my base of data, the problem
> hey that am not getting to send the backup file for another it conspires
> connected in the net. For instance:
> EXEC sp_addumpdevice 'disk', 'ArquivoBackup', '\\Estacao_1\C\Backup.dat'
> /*ateh aqui tudo bem...*/
> BACKUP DATABASE BaseDados TO ArquivoBackup
> / * here he shows the mistake: "Cannot open backup device
> 'ArquivoBackup'.Device error or device off-line. See the SQL Server error
> log for more details.*/
> EXEC sp_dropdevice 'ArquivoBackup'
> It will be that somebody has some idea of how to solve that problem or then
> an idea of how to do the backup for a remote station.
> Thank you
>