October 11, 2010 at 12:14 am
Hi,
how to take backup of database from local system to public ip system?
Database on local system..
that backup file should be on that public ip system..
Please help me ASAP
Thanks in advance.
October 11, 2010 at 1:47 am
The description of your problem is not very detailed, so that my answer cannot be detailed either:
take a backup, upload it to the target machine.
-- Gianluca Sartori
October 11, 2010 at 2:05 am
Backup to a local drive, once completed copy the file whereever you want it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 11, 2010 at 3:47 am
my local system is connected in a network. i want to take backup of one database. that backup file should be on other public ip system.without copying or moving from my system,that should be directly on that public ip system.
October 11, 2010 at 3:51 am
You could create a backup device that points to the UNC path of the public server and then backup to that device.
-- Gianluca Sartori
October 11, 2010 at 4:02 am
Generally it's not that good an idea to back up over the network. It's far slower than disks and a network glitch will cause the backup to fail.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply