Backup to Network Resource from a Server Machine Service Account

SQL Server 2000 SP4
Trying to backup to a network resource when SQL uses the machine service
account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name'
,
'\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
work because of permissions.
Fairly new to DBA stuff so please have patience with me.
How can you do this?
Regards,
Richard.You would need to have SQL Server using a service account that has permissio
ns on that share.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_nam
e',
> '\\filer_name\share_name\path\file_name.ext' would be used but this doesn'
t
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.|||Hello,
To solve the issue you have start the SQL Server service using an Domain OS
user which got write
access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.