Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup over domains

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-22 : 08:11:25
Timo writes "I tried to backup my SQL Server2000 over the Network to another Network-Domain in our company...but it didn't work because the specified shared folder (we created a service user for that)could not be found when i name it with the full path in the database maintenance plan. Also I mapped the shared folder om my SQL Server machine....
question : Is it possible to backup over domains...and if yes...why is it not working??
Thx for your help
greez
Timo"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-07-22 : 14:29:17
Mapping probably won't due you any good unless you create it while logged in as the account that starts the SQL Server Service, and even then I'm not sure it would work. You'll need to use the full UNC path. (ex: \\servername\sharename\foldername\) Make certin that there are no spaces in the UNC path. This could throw a wrench in the works when the maintenance plan tries to execute. The other thing to check is that the account that starts SQL Server has full control access to the share.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -