Backup From SQL server to a Backup server

Hello,
We are currently running our SQL backups to our local disk drive. Now we'd
like to change the path from local to a shared folder on another server on
another domain.
Is that possible?
Thanks,
Greg
It is very possible. We do it all the time. One tricky thing we ran into
with ours, we had have both SQL services run by the same DOMAIN account for
the job to dump directly to our network store box.
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:471BE8E4-B85F-4A77-BD97-95267B6A34E8@.microsoft.com...
> Hello,
> We are currently running our SQL backups to our local disk drive. Now we'd
> like to change the path from local to a shared folder on another server on
> another domain.
> Is that possible?
> Thanks,
> Greg
|||You can run backups to a network share - you'll have to make sure that the
SQL Server/Agent Services have access to that shared.
However, if at all possible, I would suggest against it for a couple of
reasons:
1) It will increase that amount of time the backup takes as well as
resources the backup uses to backup the database because you are doing it
over the network.
2) It will increase the possibility of the database backup getting
corrupted. Being that that backup is happening across the network you
increase the likelihood of something happening. I would suggest (if disk
space is a problems and that's why you are doing this) doing the backup
locally and then copying that backup off the machine, you decrease that
likelihood.
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:471BE8E4-B85F-4A77-BD97-95267B6A34E8@.microsoft.com...
> Hello,
> We are currently running our SQL backups to our local disk drive. Now we'd
> like to change the path from local to a shared folder on another server on
> another domain.
> Is that possible?
> Thanks,
> Greg
|||Thanks! Were could I find the SQL Server/Agent services? Is it under services?
Thanks,
Greg
"slamm" wrote:

> You can run backups to a network share - you'll have to make sure that the
> SQL Server/Agent Services have access to that shared.
>
> However, if at all possible, I would suggest against it for a couple of
> reasons:
> 1) It will increase that amount of time the backup takes as well as
> resources the backup uses to backup the database because you are doing it
> over the network.
> 2) It will increase the possibility of the database backup getting
> corrupted. Being that that backup is happening across the network you
> increase the likelihood of something happening. I would suggest (if disk
> space is a problems and that's why you are doing this) doing the backup
> locally and then copying that backup off the machine, you decrease that
> likelihood.
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:471BE8E4-B85F-4A77-BD97-95267B6A34E8@.microsoft.com...
>
>
|||Yes, you can find it under Control Panel; Services.
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:9B5E5A81-06E0-4E05-8242-DB94C89ABBA6@.microsoft.com...
> Thanks! Were could I find the SQL Server/Agent services? Is it under
services?[vbcol=seagreen]
> Thanks,
> Greg
> "slamm" wrote:
the[vbcol=seagreen]
it[vbcol=seagreen]
we'd[vbcol=seagreen]
server on[vbcol=seagreen]
|||Thanks but how can I give SQL services access to the shared drive on another
domain?
Greg
"JD" wrote:

> Yes, you can find it under Control Panel; Services.
>
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:9B5E5A81-06E0-4E05-8242-DB94C89ABBA6@.microsoft.com...
> services?
> the
> it
> we'd
> server on
>
>
|||Your network department can do that. They'll need to know what domain
account you want to use for the services and what access it needs to write
the backups to another server/drive.
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ED53BE72-5090-45D0-8FFA-C81BC16D4100@.microsoft.com...
> Thanks but how can I give SQL services access to the shared drive on
another[vbcol=seagreen]
> domain?
> Greg
> "JD" wrote:
that[vbcol=seagreen]
of[vbcol=seagreen]
well as[vbcol=seagreen]
doing[vbcol=seagreen]
getting[vbcol=seagreen]
you[vbcol=seagreen]
disk[vbcol=seagreen]
backup[vbcol=seagreen]
that[vbcol=seagreen]
Now[vbcol=seagreen]