Backup into another machine.

I am trying to take the backup into another machine which is on the network
but failed to do so...
Like backup database Health to disk =
'\\nSys0120\Backup\Health\bkHealth05172005'
is the above command is okie ?
Thanks
Hi,
Command looks good, but there are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:%23bZ55ewWFHA.2520@.TK2MSFTNGP09.phx.gbl...
>I am trying to take the backup into another machine which is on the network
> but failed to do so...
> Like backup database Health to disk =
> '\\nSys0120\Backup\Health\bkHealth05172005'
> is the above command is okie ?
> Thanks
>
|||Thanks Hari.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u6p7KtwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Command looks good, but there are Few Pre requisites to do backup
remotely;
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak'
with[vbcol=seagreen]
> init
>
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
>
> Thanks
> Hari
> SQL Server MVP
>
> "Joh" <joh@.mailcity.com> wrote in message
> news:%23bZ55ewWFHA.2520@.TK2MSFTNGP09.phx.gbl...
network
>
|||Hari, I did the same which you said but it gave me the following error
I used the following command
backup database test to disk = 'e:\bktest05172005'
"e:" is basically a map drive.
Error :
Windows - Delayed Write Failed
Windows was unable to save all the data for the file
\Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
lost. This error may be caused by a failure of your computer hardware or
network connection. Please try to save this file elsewhere.
OK
Any idea ?
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u6p7KtwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Command looks good, but there are Few Pre requisites to do backup
remotely;
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak'
with[vbcol=seagreen]
> init
>
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
>
> Thanks
> Hari
> SQL Server MVP
>
> "Joh" <joh@.mailcity.com> wrote in message
> news:%23bZ55ewWFHA.2520@.TK2MSFTNGP09.phx.gbl...
network
>
|||Hi,
Please follow the same procedure. Do not use mapped drive. Just use UNC
path.
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:u1a5gxwWFHA.3540@.TK2MSFTNGP09.phx.gbl...
> Hari, I did the same which you said but it gave me the following error
> I used the following command
> backup database test to disk = 'e:\bktest05172005'
> "e:" is basically a map drive.
> Error :
> --
> Windows - Delayed Write Failed
> --
> Windows was unable to save all the data for the file
> \Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
> lost. This error may be caused by a failure of your computer hardware or
> network connection. Please try to save this file elsewhere.
> --
> OK
> --
> Any idea ?
> Thanks
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u6p7KtwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
> remotely;
> same
> with
> network
>
|||Hi Hari,
From remote machine when I am opening to take backup using browse option, path should be displayed of server in .net code. (like using enterprise manager remotely connected with other server. When you click on bacup database path from server will be displayed). In same way want to do in .net. Is it possible?
Thanks