My application run at my own machine which access the SQL Server 2000 which is in another machine. I take backup of that database and the backup file(.bak file) created at c drive of that machine.
Now i want to copy that bak file from that machine to my machine.
I know IP Address of both the machines.
Can any one can help on this topic?

Thanks

Hi,

Could you please elaborate your problem a lit bit...

You want to copy the .bak file from client application or you want to write a SP to handle the copy.

Lalit

Run this on your machine
XCopy \\192.168.10.23\c$\YourSQL.bak c:\SQLDestinationDirectory

or run this on the server in a job step just after the backup step

XCopy \\192.168.10.23\c$\YourSQL.bak \\192.168.10.54\c$\SQLDestinationDirectory

If you want to restore it on your new server then you will need to execute sql statements against the SQL Server instance on your machine. This could be done by blind timing i.e. job 1 on the server runs at 10:25 AM and finishes by 10:35 AM Job 2 on your PC runs at 10:45 AM.

Or you could use another job step on the Server to execute the restore command against your pc by using osql


David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com