backup in remote machine

[Maii]

Hi there,
Is there any way to take backup in remote machine that the backup file will copy in remote machine?
Thanks in adv.
maii

 

[JayKusch]

Not quite sure what you are after. Can you provide us with some more details? Thanks!

Thanks

J. Kusch

 

[Maii]

thanks J. Kusch
If the database in machine A and I run the script or SQL-DMO code from machine B the backup file is copy in machine A rather then machine B. how can the backup file copy in machine B?

Thanks
maii

 

[miq]

hi,
you can. just have to provide network path and machine name and ofcourse directory where you want backup to be stored

something like: \\machine_name\directory

example:

backup database northwind
to disk = '\\acx\jhjn.dat'


B.R,
miq

 

[AndyLee100]

Dont you have to make sure though that the SQL Server connection is Windows Authentication and not SQL Authentication?

 

[miq]

HI,
you required a shared folder having read write permission for sqlserver and sqlagent services account.

It doesn't matter whether you use windows authentication or mixmode authenticatioin.

You will not run into problem if both services are using domain administrator account or with similar privileges. otherwise access to shared folder for above mentioned services accounts need to be configured.

B.R,
miq