Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 need script

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2007-06-27 : 06:04:08

Hi,

I need some help.

Once the bkp is done on the Database Server say C:\<db_name>.bak i need a script to transfer the backup file to my local machine.



Regards,
franky

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-27 : 09:47:30
Is your local machine on the same network as the Database Server ? Just copy to your shared folder in your local machine

copy c:\db_name.bak \\YourMachine\SharedFolder


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-27 : 10:44:59
quote:
Originally posted by khtan

Is your local machine on the same network as the Database Server ? Just copy to your shared folder in your local machine

copy c:\db_name.bak \\YourMachine\SharedFolder


KH
[spoiler]Time is always against us[/spoiler]



Using Command prompt?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-27 : 23:19:30
Or just backup db to your local disk.
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2007-06-28 : 02:33:38
Thanks
Go to Top of Page
   

- Advertisement -