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 Exams Passed: 70-152, 70-175, 70-176, 70-100
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 Exams Passed: 70-152, 70-175, 70-176, 70-100