October 7, 2008 at 6:37 am
hi, i have a problem..i want to backup database which is on sql server at different computer to my computer or sql server on my computer.
is it possible and how?
thanks
October 9, 2008 at 11:59 pm
It is possible.
Create a database device, then backup your database to this device.
October 10, 2008 at 1:16 am
SQL ORACLE (10/9/2008)
It is possible.Create a database device, then backup your database to this device.
ok but how ?:)
October 10, 2008 at 1:25 am
You can see the BACKUP DATABASE command on SQL BOL.
October 10, 2008 at 4:34 am
Kishore.P (10/10/2008)
You can see the BACKUP DATABASE command on SQL BOL.
i've seen this before like
BACKUP DATABASE dbname
TO DISK = '\\ServerName\ShareFolderName'
but ServerName can be 88.125.xx.xx ? because it doesn't work:(
October 10, 2008 at 12:55 pm
BACKUP DATABASE dbname
TO DISK = '\\ServerName\ShareFolderName'
should work most of the time, IF SQL Server Service account has permission to the \\ServerName and \Folder
Otherwise, quickest way may be
1. Backup locally
2. Copy over the network
October 10, 2008 at 2:30 pm
Jerry Hung (10/10/2008)
BACKUP DATABASE dbnameTO DISK = '\\ServerName\ShareFolderName'
should work most of the time, IF SQL Server Service account has permission to the \\ServerName and \Folder
Otherwise, quickest way may be
1. Backup locally
2. Copy over the network
First of all thanks a lot..i guess when i do this on internet create a network between two pc at different location..ServerName must be name of the network. is not ip address, is it?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply