Backup Database on remote server

Question

Backup Database on remote server

Tom.Bauto

Old Hand

Points: 370
More actions
October 1, 2008 at 10:04 pm

#127824

Good day!
Need:
I need to backup my database (data/log) from my db server to a remote backup server.
Question:
1. Is there a tool or process (GUI) on how to backup my database on a remote server? because i have tried to map my remove server but the database maintenance place does not see it.
2. Query to backup my database? because i want to create an script that will be executed by my external application and does the backup.
Please i need your urgent reply; i worried about my data because i had experience database suspect :crying: these days.
thanks in advance!
_____________________________________________
[font="Verdana"]ToM™[/font] (Possibility will come out of nothing)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Wildcat SSCarpal Tunnel Points: 4774 More actions · Answer 1

1. Make the remote folder shared, and make sure the SQL Server Agent has write-permission on that folder. (Maint plan can't see the remote shared folder. You have to input the address.)

2. Use backup command:

BACKUP DATABASE dbname

TO DISK = 'remote folder address'

cemmeke SSC Enthusiast Points: 101 More actions · Answer 2

Wildcat (10/6/2008)
1. Make the remote folder shared, and make sure the SQL Server Agent has write-permission on that folder. (Maint plan can't see the remote shared folder. You have to input the address.)
2. Use backup command:
BACKUP DATABASE dbname
TO DISK = 'remote folder address'

give you any sample for 'remote folder address' ?

thanks

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 3

cemmeke (10/7/2008)
give you any sample for 'remote folder address' ?
thanks

\\YourServerName\YourShareName\ should work.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

cemmeke SSC Enthusiast Points: 101 More actions · Answer 4

DavidB (10/7/2008)
cemmeke (10/7/2008)
give you any sample for 'remote folder address' ?
thanks
\\YourServerName\YourShareName\ should work.

like \\78.82.156.89\MyShareName\FolderName

?

thanks again

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 5

If you are able to browse to that path from windows then that will work.

Just a note, but I wouldn't leave that IP posted here if it is valid. You can use the Edit button to make that something like XXX.XX.XX.XXXX Security....

Sorry for the delayed response.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

cemmeke SSC Enthusiast Points: 101 More actions · Answer 6

DavidB (10/7/2008)
If you are able to browse to that path from windows then that will work.
Just a note, but I wouldn't leave that IP posted here if it is valid. You can use the Edit button to make that something like XXX.XX.XX.XXXX Security....
Sorry for the delayed response.

thank you for response..but i try and it doesn't work 🙁 i think i don't understand..how to set on sql server management studio to do this? should i share my any folder like local area network?