473,556 Members | 2,506 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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\B ACKUPDB2
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\B ACKUPDB2
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\d b2diag.log

2006-09-04-19.16.14.890000 Instance:DB2 Node:000
PID:388(DB2SYSC .EXE) TID:6 Appid:*LOCAL.DB 2.060904171614
database_utilit ies 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.DB 2.060904171614
database_utilit ies 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.DB 2.060904171614
database_utilit ies 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_ser vices 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_utilit ies sqluCreateBacku pFile 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_utilit ies sqluMCInitBacku pMC 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.DB 2.060904171614
database_utilit ies 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.DB 2.060904171614
database_utilit ies 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.DB 2.060904171614
database_utilit ies sqlubcka Probe:0 Database:SAMPLE

Backup terminated.

Sep 4 '06 #1
0 3188

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

Similar topics

7
4925
by: Przemo Drochomirecki | last post by:
hi, does anyone knows how to connect to samba server (from windows) thx in adv. Przemo
3
5441
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 these the backup fails. If I backup to the C:/ drive then copy it over to the disk it works fine but when SQL Server tries to do it, it can't. I am...
2
13375
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 T-SQL is: BACKUP DATABASE GPRS_Dimensioning_Archive TO local_backup WITH RETAINDAYS=21, NAME='GDA_20040706' Note that "local_backup" is a file...
2
1358
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
13012
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 credentials with permission to access this resource on the machine where it's hosted. This is once for each desktop logon session (ie after every reboot)....
0
1214
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 Samba network printer, it slows down to a crawl. With a Windows server network printer, it takes about 10 seconds to render 100 pages. With a Samba...
0
1716
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. DB2 BACKUP DATABASE SAMPLE USER MAXI USING 110ELODE TO J:\
9
2874
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 Server 2000 sp4), is there a priority level setting so that I can put less load on the CPU? Our small office uses one server for everything and...
0
3616
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 Restore. It can be found by: Start >> All Programs >> Maintenance >> Backup and Restore Center Backing Up Your Data and PC Backup my files If you...
0
7624
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7547
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7828
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8060
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7907
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5171
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3597
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3576
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
865
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.