473,320 Members | 2,180 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,320 software developers and data experts.

db2 backup issue on windows

I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

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

I am giving the correct path for the restore.
Can someone please help me.

Nov 12 '05 #1
2 4347
ni************@yahoo.com wrote:
I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

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

I am giving the correct path for the restore.
Can someone please help me.

Did you create the same instance to this backup?

cu,

indika
Nov 12 '05 #2
Say your image is backed up to the following path. It HAS to be there in
that path:
X:\BACKUPS\dbname.0\instname\node0000\catn0000\YYM MDD
The filename will be HHMMSS.001
Your restore command should be:
db2 restore database dbname from X:\backups taken at YYMMDDHHMMSS

If that was the only backup taken on that day then the YYMMDD should be
sufficient

I've done this quite a few times and it works.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ni************@yahoo.com> a écrit dans le message de news:
11*********************@g14g2000cwa.googlegroups.c om...
I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

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

I am giving the correct path for the restore.
Can someone please help me.


Nov 12 '05 #3

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

Similar topics

3
by: Cristina | last post by:
Hallo i am a beginner into Oracle Technologies.I would like to make backup of my database,but i dont know how.Is there tools?Can i schedule the backup plan? thanks Cristina
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: Trent | last post by:
Hello, all. I have the following production DB2 environment. DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003 standard edition. My first question is regard with...
1
by: Najm | last post by:
Hi All, I am facing this issue very frist time. I add a logical device as following: USE master GO EXEC sp_addumpdevice 'disk', 'AdvWorksData',
0
by: prerak_v_shah | last post by:
Hi All, These days I was working on IBM DB2 database for windows with my .Net Application. Now, it was required to backup database created on one machine to the other machine. I was also able...
10
by: Konstantin Andreev | last post by:
Hello. Some time ago I asked in this conference, - How to use an ONLINE BACKUP to restore database onto another system? - but got no answers. Therefore I can conclude it is not possible. But......
2
by: maha | last post by:
Dear DB2 experts! I'm stuck with the following issue: from a customer I got a DB2 backup file, created on an AIX-32 machine that I cannot restore on my windows platform. I admit that I posses...
5
by: abelbfilho | last post by:
I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure:...
2
by: Kevin Wilcox | last post by:
I’m backing up my BE from within Access; although the filesize is relatively modest (15Mb) for this day and age it can take 3 or 4 minutes for the backup to be completed. There’s nothing I can do...
2
by: BD | last post by:
Hi there. Using 8.2 on Windows. I have a situation where I have a db backup, which I want to deploy to a group of developer workstations. The target directory for the database files will be...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.