*RESOLVED* I am SCREWED! - SQL Server Forums

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 Development (2000)

*RESOLVED* I am SCREWED!

Author

Topic

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-03-12 : 10:20:44

OK, I am NOT on our production server, thank God!

BUT...

Our transaction log was full today so I did some research on M$ and they instructed me to backup the logfile and then to delete the ldf file. Well this wacked the sql2000 db. So, I recreated the DB and tried restoring from the transaction log's backup but it says it can not restore because it is from the BACKUP LOG.

Whaz up? Can I restore or am I reduced to rebuilding the DB from scratch?

Edited by - jesus4u on 03/12/2003 10:21:06

Edited by - jesus4u on 03/12/2003 16:21:00

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-03-12 : 10:39:09

You have to restore a full DB backup first, then the log.

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-03-12 : 10:39:56

quote:

You have to restore a full DB backup first, then the log.

thanks but I don't have the original logs. Misrosoft article told me to backup the log file then delete the original and restore from the backup, which I can not do.

chadmat
The Chadinator

1974 Posts

Posted - 2003-03-12 : 11:06:34

I highly doubt that you saw that in an MS article. As I have been saying on this forum for over a year, that is not a good idea.

It probably said truncate the log. Please post a link to the article you are referencing.

-Chad

X002548
Not Just a Number

15586 Posts

Posted - 2003-03-12 : 11:20:27

After you figure out what to do after this disaster (retype all the data?), buy ADMIN 911 for SQL Server.

http://www.bookpool.com/.x/mm3i2mh61n/sm/0072130970

You should buy this book and memorize it.

Brett

8-)

chadmat
The Chadinator

1974 Posts

Posted - 2003-03-12 : 11:35:28

Do you have a full backup?

Check your recycle bin

maybe Windows saved you.

-Chad

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-03-12 : 11:36:43

quote:

Do you have a full backup?

Check your recycle bin maybe Windows saved you.

-Chad

nope

X002548
Not Just a Number

15586 Posts

Posted - 2003-03-12 : 11:46:37

Don't you have a maintenance plan set up?

Brett

8-)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-12 : 12:38:47

You should have just run BACKUP LOG DBName WITH NO_LOG. Then immediately perform a full backup. What is your database recovery model for this database? Since it's not production, it should be set to simple, well usually set to simple at least.

Tara

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-03-12 : 16:21:36

Well all I had to do was rebuild the 3 tables that I needed.

X002548
Not Just a Number

15586 Posts

Posted - 2003-03-13 : 08:45:49

Resolved?

Did you crfeate a maint plan yet?

Brett

8-)

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-03-13 : 08:46:19