f



Restore of database file and log file

Hi,

I have a Sybase Adaptive Server Anywhere 7 database running.

I have a database file that is dated june 12, 2003
I have the database log file from yesterday.

The backupsoftware have not backed up the database file since june 12
because it did not back up open files.


So, can i merge my database file frome june 12 and my logfile from yesterday
and have all the changes since june 12  committed ? If, so how do i do it ?
Can't see any tools in the Sybase Central that can help me out...

This is a library database and my librarian is not happy at the moment.....



0
Geir
8/25/2003 7:15:25 PM
comp.databases.sybase 3279 articles. 0 followers. Post Follow

1 Replies
1059 Views

Similar Articles

[PageSpeed] 7

Hiya,



If the transaction log has not been truncated since, I'd say you can
apply the log file.



Otherwise you can force the log using dbtran and translate it to SQL
and apply the SQL to the database. This is a bit risky, you may miss a
lot of transactions since the last checkpoint until the time this log
got created.



Cheers,



Willy


--
Posted via http://dbforums.com
0
willy_and_the_ci
8/26/2003 1:51:27 AM
Reply:

Similar Artilces:

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

detach database, attach database without log file
If I detach a database on a server, then attach the database with a single file only using the data file...will I lose any transactions that were in the original log file? There is a debate going on here at work where some people think that during the detach, transactions in the log file are saved to the data file. Thanks! Hi You will not loose any committed transactions. Uncommitted transactions will normally be rolled back rolled back even if you attached the log file!! If this did happen it would be indicated in the SQL Server log file. John "DBA" <kaylisse@yahoo.com> ...

Restoring a database only from MDF and Log file
Hello. Can anyone tell me if a SQL Server 2000 database can be recovered only from the MDF and log files ? I have no backups. Thanks in advance Hi You may be able to use sp_attach_db see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp?frame=true John "Dave Pylatuk" <davep@centurysystems.net> wrote in message news:Kf53b.10295$Cg2.788132@news20.bellglobal.com... > Hello. > > Can anyone tell me if a SQL Server 2000 database can be > recovered only from the MDF and log files ? > > I have no backups. > >...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV Girish (kattukuyil@hotmail.co...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV ...

mySQL DB Database to HTML files (automatically create multiple static html files from a database)
i need automatically create html files from a mysql db can be locally on in the server. any idea? thank for any help fhelik wrote: > i need automatically create html files from a mysql db can be locally > on in the server. any idea? "mysql --xml" outputs in XML format. You can then filter using an XSLT template to produce your HTML files. See http://www.zvon.org/xxl/XSLTutorial/Books/Book1/index.html for a tutorial on XSLT. Regards, Bill K. Bill Karwin wrote: > fhelik wrote: > > i need automatically create html files from a mysql db can be locally > > o...

Can we restore the Sybase database from the backup file that is coming from Unix to Windows
We have backup file from our customer that their Sybase is installed on Unix. We have Sybase installed on Windows, can we install from their Sybase backup. Rao On Tue, 26 Oct 2004 09:47:24 -0700, Rao wrote: > We have backup file from our customer that their Sybase is installed > on Unix. We have Sybase installed on Windows, can we install from > their Sybase backup. What version of ASE are we talking about? Up to 12.5.2 this wasn't officially supported at all, although it worked if both source and destination platforms had the same endian-ness (i.e. that the binary representation of integers and float values is the same on both platforms). In 12.5.2 I believe that loading a db dump from a remote system that is a different OS but the same endian-ness is supported and should work. In 12.5.3 (to be released later this year) loading from a dump generated on a different platform will be supported completely (IIRC). So to summarize - if the Unix machine is a SPARC/Solaris machine (for example) then the current versions of ASE won't be able to load the dump on your Windows machine. Michael -- Michael Peppler Data Migrations, Inc. mpeppler@peppler.org http://www.peppler.org/ Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.peppler.org/resume.html ...

Database Log-file
Hello, my db2 V8.1 stopped just without any reason. Now I am wondering where I con find a log file which explains this behaviour... I cant find anything in the instance directory. The database is running on a Linux system Any help would be appreciated. Greetings, Jan The db2diag.log should be under the instance owner's directory, in sqllib/db2dump directory. If it's not that way on your system, you may have to search the whole instance owner's directory structure. But db2diag.log will be in there somewhere! It tells you what DB2 thinks happened when it cr...

Writting to file from Database-Files are empty
Hi everyone.. I've posted message couple of weeks ago, and I am greatful to your help. However, I wrote the method, and it does produce the 4 files, however all the files it produce are empty.. can anyone help.. This is the method: public void writeToFile(String fileName, String viewId) { FileOutputStream fileOut = null; PrintStream myOutput; try{ fileOut = new FileOutputStream(fileName); }catch (FileNotFoundException IOE){} //write to file1- start of Ali Changes 31/01/2006 try{ myOutput = new PrintStream(fileOut); query = "select * f...

File format of aracle database files?
Hi, I wonder, if there is published any information about the oracle file format (where the tables and records are stored). Can someone give me a hint? Thank you! Thilo Immel Thilo Immel wrote: > Hi, > > I wonder, if there is published any information about the oracle file > format (where the tables and records are stored). > > Can someone give me a hint? > > Thank you! > > Thilo Immel > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c03block.htm#2528 Lots of other good, free documentation available there too! --Mark Bole Mark, >Thilo Immel wrote: > >> Hi, >> >> I wonder, if there is published any information about the oracle file >> format (where the tables and records are stored). >> >> Can someone give me a hint? >> >> Thank you! >> >> Thilo Immel >> > >http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c03block.htm#2528 > >Lots of other good, free documentation available there too! > Thank you Mark! Unfortunatly I have to log in. Ok, so I want to sign up. But the sign up form always says that there is a fault in postal code (I am coming from germany, and I filled the form properly). Fakt is: I can not sign up! Ok, thougth I send an email to oracle and tell them this problem (there is a link contact us at the sign up form). Bu...

how to recover/restore a database using archive logs & control files 8i
I deleted a tablespace because it was not needed, now when I start up the instance I get the following; ORA-01113: file 12 needs media recovery If i use the command select * from v$datafiles, I can see the file in online mode, now I just want to rollback to yesterday's state We had a crash last night and I think the oringal datafile locked the system we do not have a back since friday, only an export? Can I use this? E etravels wrote: > I deleted a tablespace because it was not needed, now when I start up > the instance I get the following; > > ORA-01113: file 12 needs ...

Archive logs files accumulating on my Oracle log mode Database
>From what I understand is that an Oracle log mode Database is the recommended configuration for a production database. However, the problem we have is that Archive Logs files in the ..\RDBMS\ directory are accumulating daily which has implications when you have limited disk space. How should these Archive log files be maintained? ie when should they be deleted from the system? is there an automated procedure which will remove the log files on a weekly basis? I understand that there are two ways for performing a backup of the oracle database, 1) cold backup (requires the oracle database...

Oracle database instance shutdown without logging in log file
oracle database instance shutdown without logging in log file. we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows 2003 R2 for test/simulation purpose, we found that its shutting down the database sometimes unusally without any error/warning message in the SID alert log file. we observerd that the OS service for oracle is not starting the datbase server completely. Just after hitting start icon inside the services panel it displays the status "Starting", instead of "Started" and database is not in the "Open" state. So the method adopted to start the database from services as well using the "Startup" command from server manager utility. Why does this happen? On Apr 17, 12:19 pm, 7guru <7...@naver.com> wrote: > oracle database instance shutdown without logging in log file. > > we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows > 2003 R2 for test/simulation purpose, > we found that its shutting down the database sometimes unusally > without any error/warning message in the SID alert log file. > > we observerd that the OS service for oracle is not starting the > datbase server completely. > Just after hitting start icon inside the services panel it displays > the status "Starting", instead of "Started" > and database is not in the "Open" state. > > So the method adopted to start the database from services as well > using t...

restoring a database from a file copy
Can a database system be restored just from the data under the installation directory? I backed-up my database using "rsync /var/lib/pgsql <dest_directory>" Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the server as usual and it complained about version conflict (of course). I removed the 7.4 rpms and went back to 7.3.4 and restared server. My data are gone - only the template tables are listed. I copied back from my file backup and this, much to my horror, did not restore my database - it's as if the tables are all gone, but the file sizes indi...

restoring a database from a file copy
Can a database system be restored just from the data under the installation directory? I backed-up my database using "rsync /var/lib/pgsql <dest_directory>" Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the server as usual and it complained about version conflict (of course). I removed the 7.4 rpms and went back to 7.3.4 and restared server. My data are gone - only the template tables are listed. I copied back from my file backup and this, much to my horror, did not restore my database - it's as if the tables are all gone, but the file sizes indi...

Database Database Database Database Software Cheap
Database Database Database Database Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://w...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Em...

Moving iTunes music database: the iTunes database file
Hello, iTunes on windows (sorry if I'm making you cringe) seems to keep an iTunes "database file" in the "Documents and Settings" directory. This seems to make it hard to move actual music files/directory at will; I'd like to be able to point iTunes at a new music files area whenever I 1) reload iTunes on a fresh OS install, and/or 2) Move the location of my music files. But with this seprate database-index file thing, it seems to make it difficult. Why did Apple do this? Is it also done in OS X? (I haven't checked it out on my G3 yet). Is there anyting I ...

How to load a Unicode file into the database in the same order as the file order
The data file is a simple Unicode file with lines of text. BCP apparently doesn't guarantee this ordering, and neither does the import tool. I want to be able to load the data either sequentially or add line numbering to large Unicode file (1 million lines). I don't want to deal with another programming language if possible and I wonder if there's a trick in SQL Server to get this accomplished. Thanks for any help. Mark Leary ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100...

Web resources about - Restore of database file and log file - comp.databases.sybase

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Oracle: Fear Not, ’12c’ Database Nearing Its Breakout, Says Credit Suisse
... from cloud computing applications in 2016, along with the adoption by customers of the its “ 12c ” version of its flagship relational database ...

Enterprises want to run databases in containers
More than three out of four IT decision makers are interested in running stateful applications like databases within containers, according to ...

NFL mock draft database 2016: Tracking Giants picks from around the Internet
Let's keep track of mock drafts from around the Internet as the 2016 NFL Draft approaches. Can we find a consensus for the New York Giants?

Consumer Group Sues DOT For Failure To Create Searchable Database Of Safety Defects
... about safety defects. One safety group says this hasn’t happened, and is suing DOT Secretary Anthony Foxx in an effort to make this database ...

TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers
TSA Will Finally Be Given Access To Counterterrorism Database To Screen Airport Workers

U.S. Attorney Suggests Password Cardinals Used To Access Astros Scouting Database Was “Eckstein123"
... scouting director Christopher Correa plead guilty to five counts of unauthorized access to a computer for hacking the Houston Astros database. ...

Blinkbox Music's user database was just sold to... JD Sports
Of Tesco's three ailing digital Blinkbox services, its e-book store appeared to be the only one that would go gently into that good night. Eventually, ...

8 Reasons to Consider Open-Source Databases for Your Business
Historically, costly commercial database systems dominated the data management landscape. But open-source database system adoption is growing ...

Resources last updated: 3/2/2016 3:26:00 AM