Re: Backup into another machine.

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\bktest05172005. 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@xxxxxxxxxxx> wrote in message
news:u6p7KtwWFHA.2700@xxxxxxxxxxxxxxxxxxxxxxx
> 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\sharename­\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@xxxxxxxxxxxx> wrote in message
> news:%23bZ55ewWFHA.2520@xxxxxxxxxxxxxxxxxxxxxxx
> >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
> >
> >
>
>


.

Relevant Pages

  • Re: Restart Services
    ... How to restart SQL Server at regular intervals? ... > After that schedule this batch using the Windows scheduler or use the AT ... > See the help of AT command by executing the below from command prompt:- ... >> Do you want to stop the services so that you can backup your databases? ...
    (microsoft.public.sqlserver.clients)
  • Re: Windows could not start because the following file is missing or corrupt: System32DriversNtfs.sy
    ... Backup a bad filesystem and the Backup maybe worthless, ... Using the F10 option, once you get to the C: prompt, put the floppy in ... and see if ntfs.sys file is on the floppy ... Alt and D keys at the same time to go to a command prompt. ...
    (microsoft.public.windowsxp.general)
  • [SUMMARY] Using tar to restore files backup up using Veritas Netbackup
    ... Once you import the catalog data, you can select the files with Netbackup client softwre. ... Step 1 is performed with the first form of the command shown above and recreates catalog entries for the backups that are on the specified media. ... For example, if a backup is imported on 11/14/98 and its retention level is one week, its new expiration date is 11/21/98. ...
    (SunManagers)
  • Re: Automated Backup Help
    ... OK...I placed that entry before the ntbackup command as instructed but got exactly the same results I have previously described except for the command being echoed to the command prompt. ... It is very frustrating....obviously something is wrong and causing the backup to fail or terminate early but there is no indication of an error message at all. ... REM These are the "ntbackup" parameters and switches used; ...
    (microsoft.public.windows.server.scripting)
  • Re: Backup into another machine.
    ... but there are Few Pre requisites to do backup ... You Should start SQL server using Domain user who got access to remote ... > Backup to remote machine will not work if you start SQL server using Local ...
    (microsoft.public.sqlserver.clients)