<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Backups
»
Backup Database on remote server
Backup Database on remote server
Rate Topic
Display Mode
Topic Options
Author
Message
Tom.Bauto
Tom.Bauto
Posted Wednesday, October 01, 2008 10:04 PM
Forum 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
Wildcat
Wildcat
Posted Monday, October 06, 2008 12:21 PM
Old Hand
Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:10 PM
Points: 307,
Visits: 1,390
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
cemmeke
cemmeke
Posted Tuesday, October 07, 2008 7:37 AM
Forum 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
David Benoit
David Benoit
Posted Tuesday, October 07, 2008 7:50 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 6:41 AM
Points: 2,064,
Visits: 3,449
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
cemmeke
cemmeke
Posted Tuesday, October 07, 2008 8:45 AM
Forum 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
David Benoit
David Benoit
Posted Tuesday, October 07, 2008 1:09 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 6:41 AM
Points: 2,064,
Visits: 3,449
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
cemmeke
cemmeke
Posted Tuesday, October 07, 2008 3:25 PM
Forum 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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
