469,148 Members | 1,315 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

Backup and Restore on different computer?

kai
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
Jul 11 '06 #1
2 1744
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" <ka******@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
Jul 11 '06 #2
kai
Roy,
Thanks for your help.
Kai
"Roy Harvey" <ro********@snet.netwrote in message
news:61********************************@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" <ka******@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

Jul 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
6 posts views Thread by Eric Herber | last post: by
3 posts views Thread by Wojciech Jurek | last post: by
4 posts views Thread by Hardy | last post: by
reply views Thread by raj.raghavan | last post: by
3 posts views Thread by aka | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.