473,809 Members | 2,722 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 3200

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

Similar topics

7
5080
by: Przemo Drochomirecki | last post by:
hi, does anyone knows how to connect to samba server (from windows) thx in adv. Przemo
3
5457
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 simply doing the following: BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INIT ...
2
13394
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 sitting on the same physical drive as the database itself, and has > 80 GB free. It is not a RAID...
2
1366
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
13054
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). If I do this, my app can access the network resource fine, but otherwise fails with permission...
0
1232
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 network printer, it takes over 5 minutes! I can see that the preview control is generating
0
1724
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
2885
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 when I do a 12:00 pm full backup of our live DB, the server slows to a crawl for about 4 or 5...
0
3634
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 only want to back up your important files and data, Backup and Restore Center gives you this option.
0
9721
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9602
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10639
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10376
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10383
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10120
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6881
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3861
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3015
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.