SQL user -- sql server (alternate)

bolero92 NO[at]SPAM yahoo.com
4/29/2004 10:09:45 PM

I perform full backup on MSSQL2000
However, the directory of backup files is only writable by Administrator

But I find that I can't backup (I think it is due to permission)
In which role MSSQL2000 is running?

In Service->MSSQLSERVER
It is set to Local System Account,

Allan Mitchell
4/30/2004 6:44:37 AM

The local System account is a "can do anything locally" account. It cannot
however see past its own disk drives.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server (alternate) : SQL user