Backups to another server from SQL Server

I know we don't have the best server for this question but here it is. Why
can't I backup to another server? It seems SQL Server will only allow me to
backup to drives attached to the existing server. Am I missing something
simple?
--
Regards,
PatYou can use a UNC location like \\yourserver\sharedfolder.
Of course you will need to give acccess on that location to the SQL Server
service account if you want to schedule these backups as jobs.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Pat M - City of Reno" wrote:

> I know we don't have the best server for this question but here it is. Why
> can't I backup to another server? It seems SQL Server will only allow me t
o
> backup to drives attached to the existing server. Am I missing something
> simple?
> --
> Regards,
> Pat|||Ben, can you tell me how to give the service account permission to do the UN
C
drive. I think I tried this before but it failed and that must be why. Thank
s
so much for your help.
--
Regards,
Pat
"Ben Nevarez" wrote:
[vbcol=seagreen]
> You can use a UNC location like \\yourserver\sharedfolder.
> Of course you will need to give acccess on that location to the SQL Server
> service account if you want to schedule these backups as jobs.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Pat M - City of Reno" wrote:
>|||That needs to be done on the machine that holds the share you want to backup
to. Find the account that SQL Server is running under by looking at the
service properties for SQL Server. It must be a Domain account and it must
have proper read and write permissions on the server where the share
resides.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Pat M - City of Reno" <PatMCityofReno@.discussions.microsoft.com> wrote in
message news:D88CE895-B0F1-4E24-BCC2-C908B067DDF4@.microsoft.com...[vbcol=seagreen]
> Ben, can you tell me how to give the service account permission to do the
> UNC
> drive. I think I tried this before but it failed and that must be why.
> Thanks
> so much for your help.
> --
> Regards,
> Pat
>
> "Ben Nevarez" wrote:
>|||Andrew, thanks, I will give this a shot. I really appreciate the help from
the news groups!
Regards,
Pat
"Andrew J. Kelly" wrote:

> That needs to be done on the machine that holds the share you want to back
up
> to. Find the account that SQL Server is running under by looking at the
> service properties for SQL Server. It must be a Domain account and it must
> have proper read and write permissions on the server where the share
> resides.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Pat M - City of Reno" <PatMCityofReno@.discussions.microsoft.com> wrote in
> message news:D88CE895-B0F1-4E24-BCC2-C908B067DDF4@.microsoft.com...
>|||sok, SQL Server and SQL Server Agent(we are running 2005) are both in
Services running under 'Local System' account. If B is the server I want to
backup to and A is my SQL Server, and both have the same kind of Local Syste
m
account it might work right? Am I looking at the right place? Thanks. I'll
keep trying.
--
Regards,
Pat
"Andrew J. Kelly" wrote:

> That needs to be done on the machine that holds the share you want to back
up
> to. Find the account that SQL Server is running under by looking at the
> service properties for SQL Server. It must be a Domain account and it must
> have proper read and write permissions on the server where the share
> resides.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Pat M - City of Reno" <PatMCityofReno@.discussions.microsoft.com> wrote in
> message news:D88CE895-B0F1-4E24-BCC2-C908B067DDF4@.microsoft.com...
>|||A local system account can not access resources outside the server. As
Andrew mentioned you need to run SQL Server under a Windows domain account
and give this account permissions on the share where you want to save your
backups.
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Pat M - City of Reno" wrote:
[vbcol=seagreen]
> sok, SQL Server and SQL Server Agent(we are running 2005) are both in
> Services running under 'Local System' account. If B is the server I want t
o
> backup to and A is my SQL Server, and both have the same kind of Local Sys
tem
> account it might work right? Am I looking at the right place? Thanks. I'll
> keep trying.
> --
> Regards,
> Pat
>
> "Andrew J. Kelly" wrote:
>|||Alternatively, if you do not have a domain and want to backup in your
network you can use UNC path again however your SQL Server service account
must be created with the same username and password on the target (backup
server) machine as a local account. And you should assign read\write rights
to that account on the backup server.
So, you'll be able to create your backups on your backup server.
Do not forget, in this technic your two accounts should be identical on both
machines.
(You can not use Local System account as Ben has already mentioned for this
purpose)
Ekrem ?nsoy
"Pat M - City of Reno" <PatMCityofReno@.discussions.microsoft.com> wrote in
message news:93F2E07E-5592-4D9B-BA12-EDF3A608A02D@.microsoft.com...[vbcol=seagreen]
> sok, SQL Server and SQL Server Agent(we are running 2005) are both in
> Services running under 'Local System' account. If B is the server I want
> to
> backup to and A is my SQL Server, and both have the same kind of Local
> System
> account it might work right? Am I looking at the right place? Thanks. I'll
> keep trying.
> --
> Regards,
> Pat
>
> "Andrew J. Kelly" wrote:
>