enable sending backups to another server via UNC pathnames and restoring
from the same location? Backing up locally and copying files to the other
server doesn't make good use of the functionality of deleting backups older
than a certain number of days.
I've already created a domain admin user, shared the destination folder to
this user will full permissions, set SQL Server Agent to login under the
context of this domain admin user, but my backups still won't go to that
remote server.This is a multi-part message in MIME format.
--=_NextPart_000_0525_01C3B825.106A5290
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Have you also configured SQL Server itself to run under that domain account?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"David Morrison" <me@.nospam.com> wrote in message
news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl...
How do I configure SQL Server Agent and my Database Maintenance Plans to
enable sending backups to another server via UNC pathnames and restoring
from the same location? Backing up locally and copying files to the other
server doesn't make good use of the functionality of deleting backups older
than a certain number of days.
I've already created a domain admin user, shared the destination folder to
this user will full permissions, set SQL Server Agent to login under the
context of this domain admin user, but my backups still won't go to that
remote server.
--=_NextPart_000_0525_01C3B825.106A5290
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Have you also configured SQL Server =itself to run under that domain account?
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"David Morrison"
--=_NextPart_000_0525_01C3B825.106A5290--|||This is a multi-part message in MIME format.
--=_NextPart_000_0014_01C3B816.F2397930
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
No. Is that necessary?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:%23T3787EuDHA.2448@.TK2MSFTNGP12.phx.gbl...
Have you also configured SQL Server itself to run under that domain =account?
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"David Morrison" <me@.nospam.com> wrote in message =news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl...
How do I configure SQL Server Agent and my Database Maintenance Plans =to
enable sending backups to another server via UNC pathnames and =restoring
from the same location? Backing up locally and copying files to the =other
server doesn't make good use of the functionality of deleting backups =older
than a certain number of days.
I've already created a domain admin user, shared the destination =folder to
this user will full permissions, set SQL Server Agent to login under =the
context of this domain admin user, but my backups still won't go to =that
remote server.
--=_NextPart_000_0014_01C3B816.F2397930
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
No. Is that =necessary?
"Tom Moreau"
Have you also configured SQL Server =itself to run under that domain account?
-- Tom
=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"David Morrison"
--=_NextPart_000_0014_01C3B816.F2397930--|||This is a multi-part message in MIME format.
--=_NextPart_000_0022_01C3B81B.15455940
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
That was it! You made my day. Thanks!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message =news:%23T3787EuDHA.2448@.TK2MSFTNGP12.phx.gbl...
Have you also configured SQL Server itself to run under that domain =account?
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"David Morrison" <me@.nospam.com> wrote in message =news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl...
How do I configure SQL Server Agent and my Database Maintenance Plans =to
enable sending backups to another server via UNC pathnames and =restoring
from the same location? Backing up locally and copying files to the =other
server doesn't make good use of the functionality of deleting backups =older
than a certain number of days.
I've already created a domain admin user, shared the destination =folder to
this user will full permissions, set SQL Server Agent to login under =the
context of this domain admin user, but my backups still won't go to =that
remote server.
--=_NextPart_000_0022_01C3B81B.15455940
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
That was it! You made my =day. Thanks!
"Tom Moreau"
Have you also configured SQL Server =itself to run under that domain account?
-- Tom
=---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"David Morrison"
--=_NextPart_000_0022_01C3B81B.15455940--|||I have the same problem. SQL Server runs using an NT account, this account has permissions on the backup server and while logged into the first server using this same NT account I'm able to map a drive to the backup server. But when I go through Enterprise Manager and look for this destination via the SQL Server Backup window, I don't find it. Please advise
-- David Morrison wrote: --
No. Is that necessary
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message news:%23T3787EuDHA.2448@.TK2MSFTNGP12.phx.gbl..
Have you also configured SQL Server itself to run under that domain account
--
To
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDB
SQL Server MV
Columnist, SQL Server Professiona
Toronto, ON Canad
www.pinnaclepublishing.com/sq
"David Morrison" <me@.nospam.com> wrote in message news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl..
How do I configure SQL Server Agent and my Database Maintenance Plans t
enable sending backups to another server via UNC pathnames and restorin
from the same location? Backing up locally and copying files to the othe
server doesn't make good use of the functionality of deleting backups olde
than a certain number of days
I've already created a domain admin user, shared the destination folder t
this user will full permissions, set SQL Server Agent to login under th
context of this domain admin user, but my backups still won't go to tha
remote server|||This is a multi-part message in MIME format.
--=_NextPart_000_00AA_01C3B84F.60E51960
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
Use the full UNC name for the backup destination. You cannot map to a drive
letter.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Simi Rao" <anonymous@.discussions.microsoft.com> wrote in message
news:21C576AF-AB76-49E8-899D-8058242FE3F2@.microsoft.com...
I have the same problem. SQL Server runs using an NT account, this account
has permissions on the backup server and while logged into the first server
using this same NT account I'm able to map a drive to the backup server.
But when I go through Enterprise Manager and look for this destination via
the SQL Server Backup window, I don't find it. Please advise.
-- David Morrison wrote: --
No. Is that necessary?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23T3787EuDHA.2448@.TK2MSFTNGP12.phx.gbl...
Have you also configured SQL Server itself to run under that domain
account?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"David Morrison" <me@.nospam.com> wrote in message
news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl...
How do I configure SQL Server Agent and my Database Maintenance Plans
to
enable sending backups to another server via UNC pathnames and
restoring
from the same location? Backing up locally and copying files to the
other
server doesn't make good use of the functionality of deleting backups
older
than a certain number of days.
I've already created a domain admin user, shared the destination
folder to
this user will full permissions, set SQL Server Agent to login under
the
context of this domain admin user, but my backups still won't go to
that
remote server
--=_NextPart_000_00AA_01C3B84F.60E51960
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Use the full UNC name for the backup destination. You cannot map to a drive letter.
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
"Simi Rao" wrote in message news:21C=576AF-AB76-49E8-899D-8058242FE3F2@.microsoft.com...I have the same problem. SQL Server runs using an NT account, this =account has permissions on the backup server and while logged into the first =server using this same NT account I'm able to map a drive to the backup =server. But when I go through Enterprise Manager and look for this destination =via the SQL Server Backup window, I don't find it. Please advise. -- =David Morrison wrote: -- = No. Is that necessary? ="Tom Moreau"
--=_NextPart_000_00AA_01C3B84F.60E51960--|||I'm having a similar problem. Does SQL Server itself have
to run under the domain account? Is this the MSSQLSERVER
service? I have the permissions on the remote folder set
for the domain admin. The SQL job for the maintenance
plan is owned by the domain admin. The SQL Agent service
is started under the domain admin. Still, the backups are
failing and the log indicates that access is denied in
creating the backup and it appears that 'sa' is invoking
the job.
>--Original Message--
>No. Is that necessary?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in
message news:%23T3787EuDHA.2448@.TK2MSFTNGP12.phx.gbl...
> Have you also configured SQL Server itself to run under
that domain account?
> --
> Tom
> ---
--
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "David Morrison" <me@.nospam.com> wrote in message
news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl...
> How do I configure SQL Server Agent and my Database
Maintenance Plans to
> enable sending backups to another server via UNC
pathnames and restoring
> from the same location? Backing up locally and copying
files to the other
> server doesn't make good use of the functionality of
deleting backups older
> than a certain number of days.
> I've already created a domain admin user, shared the
destination folder to
> this user will full permissions, set SQL Server Agent
to login under the
> context of this domain admin user, but my backups still
won't go to that
> remote server.
>|||This is a multi-part message in MIME format.
--=_NextPart_000_001C_01C3C328.296D6850
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
The SQL Server service has to run under a domain account to do what you
want. That said, you should not use the domain admin account. That's way
to much authority. Create a separate account that can run as a service and
use it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
<anonymous@.discussions.microsoft.com> wrote in message
news:108a01c3c33e$5b4bd170$3101280a@.phx.gbl...
I'm having a similar problem. Does SQL Server itself have
to run under the domain account? Is this the MSSQLSERVER
service? I have the permissions on the remote folder set
for the domain admin. The SQL job for the maintenance
plan is owned by the domain admin. The SQL Agent service
is started under the domain admin. Still, the backups are
failing and the log indicates that access is denied in
creating the backup and it appears that 'sa' is invoking
the job.
>--Original Message--
>No. Is that necessary?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in
message news:%23T3787EuDHA.2448@.TK2MSFTNGP12.phx.gbl...
> Have you also configured SQL Server itself to run under
that domain account?
> --
> Tom
> ---
--
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "David Morrison" <me@.nospam.com> wrote in message
news:u$XDJ5EuDHA.424@.TK2MSFTNGP11.phx.gbl...
> How do I configure SQL Server Agent and my Database
Maintenance Plans to
> enable sending backups to another server via UNC
pathnames and restoring
> from the same location? Backing up locally and copying
files to the other
> server doesn't make good use of the functionality of
deleting backups older
> than a certain number of days.
> I've already created a domain admin user, shared the
destination folder to
> this user will full permissions, set SQL Server Agent
to login under the
> context of this domain admin user, but my backups still
won't go to that
> remote server.
>
--=_NextPart_000_001C_01C3C328.296D6850
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
The SQL Server service has to run =under a domain account to do what you want. That said, you should not use the =domain admin account. That's way to much authority. Create a =separate account that can run as a service and use it.
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
wrote in message news:108a01c3c33e$5b=4bd170$3101280a@.phx.gbl...I'm having a similar problem. Does SQL Server itself have to run =under the domain account? Is this the MSSQLSERVER service? I have the permissions on the remote folder set for the domain admin. The =SQL job for the maintenance plan is owned by the domain admin. The SQL =Agent service is started under the domain admin. Still, the backups =are failing and the log indicates that access is denied in creating =the backup and it appears that 'sa' is invoking the job.>--Original Message-->No. Is that necessary?> "Tom Moreau"
--=_NextPart_000_001C_01C3C328.296D6850--
No comments:
Post a Comment