Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
toink
Starting Member
4 Posts |
 Posted - 2006-02-23 : 01:12:32
|
| I want to backup a database from a specific database server. But i want the destination of the backup to be in my unit/folder. Is it possible? or backups are really to be destined to the server's folder?Hope to hear from you so soon.Thank you. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-23 : 01:27:17
|
| you can specify the unc path like\\workstation\drive\folder\filename.bakbe sure to open the connection from server to workstation and that the account running the sql services have write permission on the folder you specifiedbut this is not advisable, backup might be aborted due to network failures/hiccups, a more reasonable approach is to do local backup then copy the file to your workstation, then you can delete the local backup if you like...HTH--------------------keeping it simple... |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-23 : 01:28:43
|
quote:
Originally posted by jen
you can specify the unc path like\\workstation\drive\folder\filename.bakbe sure to open the connection from server to workstation and that the account running the sql services have write permission on the folder you specifiedbut this is not advisable, backup might be aborted due to network failures/hiccups, a more reasonable approach is to do local backup then copy the file to your workstation, then you can delete the local backup if you like...--editi just realized, not all servers will be using domain accounts  just make sure the server account has write permission on your laptopbut i guess that's not advisable too  HTH--------------------keeping it simple...
--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-23 : 02:52:35
|
| without the domain this could get tricky.Without having AD or an NT domain to use, you might just have to enable the guest account on your laptop and give it write access to a share you create. THis way, any user can write to that directory. Not very secure, but it would work.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-23 : 04:30:56
|
| ... Rather than have the Server copy to your [push] Laptop have the Laptop copy from the server [pull]?Depends whether you have permissions to see [shared] folders on the Server of course ... most of our SQL boxes have very limited security permissions on the local disks, yours may be the same! We favour having the SQL box "push" to the remote, using FTP if no direct LAN link can easily be established (and then we have a whole load of b*gg*ryB*ll*cks to PGP encrypt the backups that get shunted over insecure networks in this manner ...Kristen |
|
|
|
|
|
|
|
|
backup database