January 12, 2008 at 4:24 am
hi,
It's possible to take backup's in the system which is in network.
January 12, 2008 at 9:44 pm
Can you clarify you question? Are you asking if you can backup to a network share?
January 12, 2008 at 9:44 pm
Not sure what you mean? Your question is not clear.
January 13, 2008 at 7:19 am
hi,
My backup schedule should take automatic database backup to the system it has been hosted and i'm asking that it's possible to take those backup's in another system automatically which is is network.
January 13, 2008 at 8:18 am
OK a few grammar items so I'm sure we're communicating.
You have a database "ON" a system. It can be set up to automatically take a backup "TO" itself, meaning copy the backup file on the same OS system that SQL Server is running on. It is also hosted "ON" a system, not "TO".
You can "COPY" the backups to another system, and you can either attempt to send the backup file directly to another system or use the WITH MIRROR option.
However, backups across the network can be flaky and are not recommended. It is recommended you back up locally to the same system, then do a copy. I don't even recommend the mirror option because if the mirror fails because of some network hiccup, the local backup isn't performed either.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply