473,782 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problems in restoreing the database

3 New Member
hi everyone


When i m trying resrore the database system is throwing this error.

[b]RESTORE DATABASE NSWD FROM "C:\db2_backups " TAKEN AT 20080429211406 TO "C:" INTO NSWD WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;




SQL2542N No match for a database image file was found based on
the source database alias "NSWD" and timestamp "20080429211406 "
provided.

Explanation:

The backup image file filename consists of a database alias and a
timestamp component. A filename is constructed from the source
database alias and timestamp parameters provided in the Database
Restore call. No filename existed in the source directory that
matched based on the source database alias and timestamp
provided. If this error was received from an automatic
incremental restore then a required image was not found based on
the timestamp and location in the database history.

User Response:

Ensure that the database backup image resides on the media
source. Resubmit the operation by specifying a correct timestamp
to result in a match.

If this error was received from an automatic incremental restore,
check the database history for the corresponding backup entry
and verify that the location listed matches the actual location
of the backup image. Either update the database history and
retry the operation to result in a match or issue a RESTORE
INCREMENTAL ABORT command to cleanup any resources that may have
been created during processing.


please anyone suggest what i will have to do

Regards,
aashiss03
May 29 '08 #1
3 5978
docdiesel
297 Recognized Expert Contributor
Hi,

according to your command line there should be a file like NSWD.0.DB2INST1.NOD E0000.CATN0000.20080429211406.001 or NSWD.0.DB2.NODE0000 .CATN0000.20080429211406.001in your folder "C:\db2_backups ". Check if it's there or what files this folder offers otherwise.

Regards,

Bernd
May 29 '08 #2
aashiss03
3 New Member
There is no file named NSWD.0.DB2INST1 .NODE0000.CATN0 000.20080429211 406.001 or NSWD.0.DB2.NODE 0000.CATN0000.2 0080429211406.0 01 in the folder "C:\db2_backups ".

We have downloaded the database in that folder.
For the database there are 7 chunks of ZIP file.
This is directory structure
C:\db2_backups\ NSWD.0\DB2\NODE 0000\CATN0000\2 0080429
May 30 '08 #3
docdiesel
297 Recognized Expert Contributor
Hi,
C:\db2_backups\ NSWD.0\DB2\NODE 0000\CATN0000\2 0080429
Looks like DB2 handles backups in windows very different than in Linux, so I'm afraid I can't help you there. Anyway, if this is the directory structure, then I'm missing the time "211406" and maybe some number "001".

Regards,


Bernd
Jun 6 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1578
by: franz | last post by:
Hi developers! Are you using design pattern? And do you want to help me with my research project? Ok – you only need two minutes – I made a little survey form (8 very short questions). There are no mail address or other personal data questioned… Just point your browser to: http://baseportal.com/cgi-bin/baseportal.pl?htx=/krauth/pattern_survey/pattern_survey
1
2722
by: Harlin | last post by:
Hi, I am trying to set up the database for LMS on a Linux box. This box is running SLES 9. I am trying to run the following scripts as user: db2inst1 : ../cr_db2db_audit.sh and I receive the following error messages(snipped for brevity because they are repeating errors):
2
2335
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000 database? Why you ask! A client has a 2000 database. Currently using 2000 runtime for most employees to work with database. A couple use 2003 to use database, no problems. They have a mix of versions of other products such as Word, Excel - 97,...
3
1251
by: Bonj | last post by:
When I am in a database project in VS.NET 2003 EA, using the Run Stored Procedure option times out even though the timeout option in Tools, Options, Database Tools is not checked. Anybody else experienced this?
3
2357
by: Carl | last post by:
I'm a relative newbie to DB2. I need to move a database from a windows server to a linux server. I have already identified and resolved an issue with schema names, but I now have a vexing problem with BLOBs. The table appears to have come over well (queries show all records match between the two), but the linux box can't retrieve the data. I used the db2move DATABASE export/import commands.
0
2410
by: drawing in aspnet | last post by:
Question about putting the data layer in a separate class library. I keep reading that the data layer should be separated from the presentation layer and put in its own class library. I am trying to do this but running into a problem. I'm hoping someone can point me in the right direction. I first create a class library (all code in C#) and within this class library create a very simple Sql Server Express database (.mdb) file. It's...
3
1793
by: odeta | last post by:
hello This is my problem: I have a desktop application implemented in C#,with a database implemented in SQL Server 2000. This applicaton stands in my computer. On the other hand,i have designed and implemented an application with PHP/MySQL which is hosted in a server. My question is: how can i make the web application send changes in the database in my desktop application?? (i mean the changes made in my web application should be reflected...
3
1848
eboschi
by: eboschi | last post by:
Hi all, i'm new to .net programming and i have some problems with database connection. I have written two web application. Both of them use ADODB Connection to Sql Server 2000 database. The problem is in second one. The first application is used for order management. I have defined in Main.aspx page a variable called localSqlConnection. Every time i enter this page (only one time per session) i create connection to local database and then i...
2
2093
by: daljeet30 | last post by:
Hi i m daljeet singh. i m using Visual C#.net 2005 but i have facing problem Following code i used in app.config file <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="AddressDB" value="Data Source=.;Initial Catalog=addressdata;User ID=sa;Password=;"/> </appSettings> </configuration> and in C# code file i use
0
9639
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
9479
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
10146
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...
0
9942
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
8967
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7492
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6733
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();...
0
5378
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4043
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.