July 31, 2009 at 1:10 pm
hi,
I have an sqlserver database ewith some ip no. i want to take the data backup to my local machine. please suggest me the process of doing it
July 31, 2009 at 4:07 pm
SQL Server does not allow browsing drives on other servers(for Backup and Restore) while using Management studio. You will have to copy the backup from the remote machine to your local machine.
But you have the option of specifying UNC path of another machine when using queries. But for this to work properly you need to have proper read and write to these shares.
BACKUP DATABASE [database_name] TO DISK='\\storage\Backups\db1\db1.bak' 🙂
August 3, 2009 at 8:47 am
Backing up to a network location is not recommended. If you need to move backups to another server/PC you should do so with a file copy AFTER the backup completes.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply