Backup and Restore on different computer?

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

KaiFirst, 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:

Quote:

Originally Posted by

>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

|||Roy,
Thanks for your help.
Kai
"Roy Harvey" <roy_harvey@.snet.netwrote in message
news:6148b29emu0679q9d41k6q27g5a05g8hgg@.4ax.com...

Quote:

Originally Posted by

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:
>

Quote:

Originally Posted by

>>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