|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Backup to network folder....
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Backup to network folder....
|
|
| Paul Mason 2002-11-28, 6:23 am |
|
We have been able in the past, but are unable now to backup to a remote
folder....We have a series of maintenance plans that backup to a mapped N
drive. The N drive is one of our workstations. We have even tried a manual
backup, to no avail.
The only thing that has changed is the password of the account that we
normally use when we are logged onto the server. This an NT domain
administrator account. From the operating system we can see the remote
drive and create files on it and delete files from it, but SQL doesn't want
to know.
We are using SQL7 on an NT4 box....I'm afraid I don't currently know which
patches have been applied to the operating system and SQL, but the database
properties show the NT version as NT4.0 (1381) and the SQL version as
7.00.842.
Any suggestions??....
Paul
| |
| Uri Dimant 2002-11-28, 6:23 am |
| Paul
BACKUP DATABASE EXM_IscarData TO DISK =
N'\\SERVER_NAME\backup\DATABAS
E.BAK'
RESTORE DATABASE FROM DISK=
N'\\SERVER_NAME\backup\DATABAS
E.BAK'
NOTICE: SQL SERVER SHOULD NOT RUN UNDER LOCAL ACCOUNT AND OF COUSE
PERMISSION ISSUES ON A SHARE FOLDERS
Paul Mason <masonp@trials.bham.ac.uk> wrote in message
news:OICb5WtlCHA.2224@tkmsftngp02...
>
> We have been able in the past, but are unable now to backup to a remote
> folder....We have a series of maintenance plans that backup to a mapped N
> drive. The N drive is one of our workstations. We have even tried a
manual
> backup, to no avail.
>
> The only thing that has changed is the password of the account that we
> normally use when we are logged onto the server. This an NT domain
> administrator account. From the operating system we can see the remote
> drive and create files on it and delete files from it, but SQL doesn't
want
> to know.
>
> We are using SQL7 on an NT4 box....I'm afraid I don't currently know which
> patches have been applied to the operating system and SQL, but the
database
> properties show the NT version as NT4.0 (1381) and the SQL version as
> 7.00.842.
>
> Any suggestions??....
>
> Paul
>
>
| |
| Paul Mason 2002-11-28, 7:23 am |
| Thanks for the advice, but it turned out to be one of the initialisation
parameters. The service was being started by the local administrator
account which had no direct access to the network. We changed it to use our
domain admin account and our old maintenance plans are working again...
You learn something new each day eh??
Paul
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:uSU1cbtlCHA.2036@tkmsftngp07...
> Paul
> BACKUP DATABASE EXM_IscarData TO DISK =
> N'\\SERVER_NAME\backup\DATABAS
E.BAK'
>
> RESTORE DATABASE FROM DISK=
> N'\\SERVER_NAME\backup\DATABAS
E.BAK'
>
> NOTICE: SQL SERVER SHOULD NOT RUN UNDER LOCAL ACCOUNT AND OF COUSE
> PERMISSION ISSUES ON A SHARE FOLDERS
>
>
> Paul Mason <masonp@trials.bham.ac.uk> wrote in message
> news:OICb5WtlCHA.2224@tkmsftngp02...
> >
> > We have been able in the past, but are unable now to backup to a remote
> > folder....We have a series of maintenance plans that backup to a mapped
N
> > drive. The N drive is one of our workstations. We have even tried a
> manual
> > backup, to no avail.
> >
> > The only thing that has changed is the password of the account that we
> > normally use when we are logged onto the server. This an NT domain
> > administrator account. From the operating system we can see the remote
> > drive and create files on it and delete files from it, but SQL doesn't
> want
> > to know.
> >
> > We are using SQL7 on an NT4 box....I'm afraid I don't currently know
which
> > patches have been applied to the operating system and SQL, but the
> database
> > properties show the NT version as NT4.0 (1381) and the SQL version as
> > 7.00.842.
> >
> > Any suggestions??....
> >
> > Paul
> >
> >
>
>
|
|
|
|
|