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

Subscribe Post Reply

1846

Roy Harvey

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

Similar topics

MYSQL Backup & Restore using PHP ?

by: James | last post by:

HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that...

PHP

db2 backup, StorageManager

by: Eric Herber | last post by:

I've a question regarding db2 (V8.1) and database backups going to a storage manager like TSM for example. As I can see in the storage manager if I backup the complete database over the TSM API...

DB2 Database

Backup and Restore DB

by: Wojciech Jurek | last post by:

Hi! I need to backup database and then restore it from file on other computer. I'm using DB2 on Windows XP. Please give me two simple SQL statements which I could use in Command Centre. Thanks...

DB2 Database

backup/restore nTs data

by: Hardy | last post by:

hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...

DB2 Database

FILEGROUP BACKUP/RESTORE

by: raj.raghavan | last post by:

Hi, I have a database were all the indexes are in a seperate filegroup a few large tables are in a seperate filegroup. We take backup at different times and I have backup of primary, two filegroup...

Microsoft SQL Server

backup/restore of Tables ONLY (please)

by: javelin | last post by:

I'm having difficulty searching for an answer to this challenge. Can someone give me a clue on the right keywords to use to find a discussion on this subject? All of the ones I saw appear to touch...

Microsoft SQL Server

SQL Server 2000 Backup and Restore, Need help!

by: smoi | last post by:

Hi all, My manager ask me to do backup for 3 database and restore them in a new server. I did the backup for the 3 database into BAK file. Then in the new server, when I did the restore in SQL...

Microsoft SQL Server

regarding BACKUP/RESTORE

by: aka | last post by:

Hi, I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit, Big-endian) server located in US. The...

DB2 Database

How to do a Complete Backup in Vista Ultimate

by: Niheel | last post by:

The importance of backups can never be emphasized enough. In Vista Ultimate and Windows Server 2008, there is a built in feature to take care of backups called Windows Complete PC Backup and...

Microsoft Windows

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Report value list

by: Teri B | last post by:

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA