Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore a mssql 6.5 database from transaction log

Author  Topic 

sreilly
Starting Member

2 Posts

Posted - 2002-07-02 : 11:30:17
Due to a recent server crash and a failure with our sql back-up agent, we've been left with a corrupt sql server 6.5 database (it's now a 0 byte file). But we do have a complete transaction log file, is it possible to rebuild the database from the transaction log alone.

any help greatly appreiciated, as i'm not very familier with 6.5 and i'm picking this up for a collegue.

Cheers

Simon

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-07-02 : 11:43:16
check out the company mentioned below....

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16000

Go to Top of Page

sreilly
Starting Member

2 Posts

Posted - 2002-07-02 : 11:46:46
I've had a look at this but they don't support sql server 6.5.

Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2002-07-02 : 15:47:00
Just restore your latest backup that I know you must have if this is important data.

If not, I would suggest MS support, but I'm not sure they will be able to help if you have no backups.

-Chad

Go to Top of Page
   

- Advertisement -