quilkin,
Try changing SQL service to log in as a Local System instead of a Local =
or Network Service
--=20
Jeff=20
Check Point Software
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.
http://tinyurl.com/75bgz =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
[quoted text, click to view] "quilkin" <quilkin@discussions.microsoft.com> wrote in message =
news:D58DA277-121E-49AE-96B1-7F91C674DD8D@microsoft.com...
Evidently permissions are not granted! I can back up to the folder =
where the=20
.mdf file is stored, so that will be fine, thanks. However it would be =
useful=20
to know how to grant SQL permission to an alternative folder.
Thanks for your help.
[quoted text, click to view] "Andrea Montanari" wrote:
> hi,
> quilkin wrote:
> > I'm migrating our app from VS2003/MSDE2000 to VS2005/SQLexpress.
> > Generally no problems, but the backup of database always fails.
> > The backup command is
> > "BACKUP DATABASE icespy5 TO DISK=3D'C:\testbackup'"
> > I get:
> > "Cannot open backup device 'C:\testbackup'. Operating system error
> > 5(error not found). BACKUP DATABASE is terminating abnormally."
> > The same command works fine with the MSDE database. I have tried =
other
> > backup destinations but with no success. I have full admin rights;
> > backup fails in both debug and release environments.
> >
> > Any ideas what's wrong?
>=20
> please verify the Windows account the SQLExpress instance is running =
on has=20
> been granted adeguate NTFS permissions on the destination path..
> --=20
> Andrea Montanari (Microsoft MVP - SQL Server)
>
http://www.asql.biz http://italy.mvps.org > DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> --------- remove DMO to reply=20
>=20
>=20
