Posted by Roy Harvey on 07/11/06 20:59

First, the path must be specified using a UNC name, not a mapped drive
letter: \\ServerA\Sharename\foldername\filename.ext

Second, the account under which the SQL Server service is running must
have rights to access that location. Test this:

EXEC master..xp_cmdshell 'dir \\ServerA\Sharename\foldername\*.*'

If the service is running under the local system account it will NOT
have any network rights, and will not be able to access the file.

Roy Harvey
Beacon Falls, CT

On Tue, 11 Jul 2006 20:51:07 GMT, "kai" <kailiang@earthlink.net>
wrote:

>Hi,
> I use SQL Server 2005. In computer "A", I backup a database "AAA" to a
>file "AAA_Back.bak". When I try to restore on computer "B", error message
>shows up, it try to find the original backup file path in computer "A".
>
>How can I fix this problem?
>
>
>Thanks
>
>Kai

• Next in forum: Re: a newbie question on derived/computed column
• Prev in forum: Backup and Restore on different computer?
• Thread view: Re: Backup and Restore on different computer?

[Reply to this message]