Why can't I backup/restore my SQL Server database to a share on another server?

Hi

I got the similar problem yesterday and checking the solution here and there. Below is the steps I followed to restore the database

1. Map the Drive Letter to this location from where you are going to restore the file
2. Stop MSSQL service from Services on relevant server
3. Run command prompt under your account by right clicking on the Command Prompt and select user name and password to this domain
4. Run MSSQL in command prompt mode as follow - this line is from SQL Server(MSSQLSERVER) PROPERTIES --> path to executable
"C:\\Program Files\\Microsoft SQL Server\\MSSQL.3\\MSSQL\\Binn\\sqlservr.exe" -sMSSQLSERVER
5. Once above service is running - Restart Ent. Manager and do the restore - you can give the Mapped Drive letter for path and give the name for file.
6. Verify the .mdf and .ldf file location for this database from Options and click OK - data base will be restored.

Many Thanks
Deepak

I had the same issue and just identified a solution. I first checked the sql service account (windows login that runs the mssqlserver service). Before reading this article, I added this account to the destination server and granted it access to the share, to no avail. That would have solved the problem for most of the people that had this issue if they hadnt already figured it out....for the people that are aggravated because they still have the issue, try this....
exec xp_cmdshell 'dir \\\\server\\share\\'

When i ran that, i receieved error:

Logon failure: the specified account password has expired.

Bingo. I wouldnt have known that unless i actually tried to log into the server as the service account. I had only created a mapped drive using the service account credentials to test it, and it did not prompt me to change the password. (the user i created on the destination to match the service account had "change password on next logon" checked. So it was still a valid user with access to the unc path, but i still had an issue.

The suggestions in the OP were cryptic and ultimately didn't work. However, the response about using xp_cmdshell to do a "net use" of the drive worked excellent! I did have to figure out how to *enable* xp_cmdshell but that was pretty easy to find. Great idea and made short work of the problem, as nothing had to be done to the "target" machine at all...

This problem can be solved if the target machine is a windows 2003 server. You can grant de source sql server "computer" rigths to the share.
Click to add a user. then click the button "Object Types" and select "Computers". Now you can select the source sql server and grant "Change" permissions to the Share and in the same way you have to grant these rights to the folder (NTFS)

I was also interested to see this problem already highlighted. I am having a problem backing up a database to a maped drive on another network server (domain controler-DC). My SQL service account is running on a network account which has permissions on the server, which is also a domain controler(DC). I can see shares and drives on the network but not within enterprise manager cant figure out why?