Posted by Greg D. Moore \(Strider\) on 07/26/06 11:58

"RAM" <r_ahimsa_m@poczta.onet.pl> wrote in message
news:6lkec292thjpbhkm7b2h03unpeg045jhp2@4ax.com...
> On 25 Jul 2006 00:24:24 -0700, "NiTiN" <emailme.nitin@gmail.com>
> wrote:
>
> >The error is the double quotes! You need to use single quotes to
> >specify the filename. The statement should be rewritten as:
> >BACKUP DATABASE DemoSQLServer TO DISK = 'G:\DemoSQLServer.bak'
>
> Thanks,
> but I have another problem:
> Cannot open backup device 'G:\DemoSQLServer.bak'. Operating system
> error 5(Access denied.).
>
> (Changing drive don't help.)
> I have no problem with accessing drives from other applications. I had
> no problems with SQL Server setup.

SQL Server itself for some reason doesn't have access to this drive.

If it's local, check permissions.

If it's remote, change it to a UNC path and make sure the user has domain
priviliges.


>
> Please help.
> /RAM/
>

[Back to original message]