473,403 Members | 2,338 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

BACKUP TO SAMBA NETWORK DRIVE FAILS BUT THE FIRST TIME

I am trying to backup sample database to network drive J:\ which maps
to a SAMBA share.

The first time the backup is successfull but the the next time fails.
I've to delete J:\sample.0 if I want to backup again.

Here is the log:

[C:\]NET USE J: \\LINUXSERVER\BACKUPDB2
The command completed successfully.

[C:\]DB2 BACKUP DATABASE SAMPLE TO J:

Backup successful. The timestamp for this backup image is :
20060904191614
[C:\]DB2 BACKUP DATABASE SAMPLE TO J:
SQL2036N The path for the file or device "J:\" is not valid.

[C:\]NET USE J: \\LINUXSERVER\BACKUPDB2
The command completed successfully.

[C:\]DB2 BACKUP DATABASE SAMPLE TO J:

Backup successful. The timestamp for this backup image is :
20060904191614
[C:\]DB2 BACKUP DATABASE SAMPLE TO J:
SQL2036N The path for the file or device "J:\" is not valid.

[C:\]type c:\sqllib\db2\db2diag.log

2006-09-04-19.16.14.890000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Starting a full database backup.

2006-09-04-19.16.39.420000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Backup Complete.

2006-09-04-19.18.56.100000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Starting a full database backup.

2006-09-04-19.18.56.330000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:14 Appid:none
oper_system_services sqlomkdirp Probe:37

b700 0000 ....
2006-09-04-19.18.56.540000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:14 Appid:none
database_utilities sqluCreateBackupFile Probe:20

Media controller -- dos path error. path = J:\SAMPLE.0

2006-09-04-19.18.56.610000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:14 Appid:none
database_utilities sqluMCInitBackupMC Probe:80

Media controller -- device initialization warning

2006-09-04-19.18.56.610007 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubMWResponse Probe:5 Database:SAMPLE

DiagData
0cf8 ffff 4a3a 5c00 ....J:\.
2006-09-04-19.18.56.620000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubMWResponse Probe:10 Database:SAMPLE

DiagData
0cf8 ffff ....
2006-09-04-19.18.56.680000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Backup terminated.

Sep 4 '06 #1
0 3164

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Przemo Drochomirecki | last post by:
hi, does anyone knows how to connect to samba server (from windows) thx in adv. Przemo
3
by: Ray Lavelle | last post by:
I have a utility I wrote which can backup/restore my database as well as schedule backups. This has always worked pretty well except when I try to backup to a USB Flash Disk. When I use one of...
2
by: nt | last post by:
I am having a problem with a regular backup of an SQL Server (MSDE 2000) database to a local drive. I initiate the backup once a week, by issuing the required T-SQL, via ADO. In this case, the...
2
by: Damn fool | last post by:
Hi again, I am able to schedule a backup and default it to the server. However, is there an option or a way to locate the backup somewhere else on the network? regards, gilbert
8
by: Ben Fidge | last post by:
Hi I have a small WinForms app that needs to copy files from a shared drive on a network. If I connect to the mapped drive using Explorer, a password dialog pops-up and I have to provide...
0
by: Lars | last post by:
I am using Microsoft .NET (2.0) PrintPreviewDialog and all works well when the Windows default printer is set to a local printer or a network printer on a Windows server, but if I set it to a...
0
by: Massimiliano Campagnoli | last post by:
Can you explain me what is going on here ? J:\ is a network drive located on a samba server. DB2 is V7.2 fixpak 14. net use j: \\linuxserver\backupdb2 The command completed successfully. ...
9
by: gabe101 | last post by:
I've searched enough to know that this ability probably doesn't exist in our current setup, thus the reason I'm coming to the community now. When doing a database backup in Enterprise Manager (SQL...
0
Niheel
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.