How to create a file backup device on non-sql server

[wvanexe]

I want to backup my databases to a non-sql server using a share.. When I try to create the device using UNC it says "Unable to verify the existance of the backup file location".. What am I missing to create a backup device on the shared drive...?

 

[tlbroadbent]

Make sure the SQL Server startup account - the account that the service runs under - is a domain account with appropriate permissions on the target server share. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[wvanexe]

Niether of my two NT servers are Domain servers...They are both set up as single servers... My MSSQLServer account starts up with the administrator account currently. The share on the non-SQL server allows administrator's to have full access... I also tried to map a drive (F:\) to the share but the SQL server does not see F: only C: and D: I assume the admin account on the non-SQL server is not the same admin account on my SQL server so what can I try next..

 

[tlbroadbent]

SQL Server runs as a service in its own workspace and doesn't see drives mapped by a Windows login on the server. No login to Windows is even required for SQL Server to run.

You'll have to look in Control Panel Services to see what account is used to start SQL Server. This account must have appropriate permissions in order for the backup to the other server to work. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[wvanexe]

Thank-you... I had the SQL service running under the administration account I changed it to the sa account and it works beautifully...