Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup Database on remote server Expand / Collapse
Author
Message
Posted Wednesday, October 01, 2008 10:04 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 09, 2012 9:12 PM
Points: 8, Visits: 37
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 these days.

thanks in advance!





_____________________________________________
ToM™ (Possibility will come out of nothing)
Post #579473
Posted Monday, October 06, 2008 12:21 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 1:26 PM
Points: 405, Visits: 1,431
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'

Post #581304
Posted Tuesday, October 07, 2008 7:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2008 2:27 PM
Points: 7, Visits: 23
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
Post #581784
Posted Tuesday, October 07, 2008 7:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:20 PM
Points: 2,105, Visits: 3,560
cemmeke (10/7/2008)

give you any sample for 'remote folder address' ?

thanks


\\YourServerName\YourShareName\ should work.


David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #581801
Posted Tuesday, October 07, 2008 8:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2008 2:27 PM
Points: 7, Visits: 23
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
Post #581881
Posted Tuesday, October 07, 2008 1:09 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:20 PM
Points: 2,105, Visits: 3,560
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
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #582118
Posted Tuesday, October 07, 2008 3:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2008 2:27 PM
Points: 7, Visits: 23
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?
Post #582220
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse