Posted by kai on 07/12/06 02:28

Roy,
Thanks for your help.
Kai
"Roy Harvey" <roy_harvey@snet.net> wrote in message
news:6148b29emu0679q9d41k6q27g5a05g8hgg@4ax.com...
> 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: 2005: calling .NET procedure
• Prev in forum: Re: Using Decimal as a Key
• Thread view: Re: Backup and Restore on different computer?

[Reply to this message]