Logfile in SYSFILES(mssql7) deleted

Accidently,

I(we) deleted the Logfile.LDF in sysfiles folder on the mssql server
and now can't enter the database, which status now is set SUSPECT.

Before deleting the logfile I did a Transaction-Logfile Backup and there is maybe an older version of full database backup somewhere.

Trying to restore database with enterprise manager, restoring from the Transaction Logfile Backup, enterprise manager tells me:

'The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence specifying WITH NORECOVERY or WITH STANDBY for all but the final step.Backup or restore operation terminating abnormally.'

How to restore the database, I put two weeks of work in it...
Please help, somebody.
THX, Georg.

Jun 12 '06 #1

Subscribe Post Reply

1804

ge_orgy

OK,

i've found a solution:

http://www.spaceprogram.com/knowledg...leted_log.html

but is there any risk to follow these steps?!

Jun 12 '06 #2

ge_orgy

Thanks to spaceprogram.com,

their suggested solution worked fine.

Jun 13 '06 #3

by: Ryan Hubbard | last post by:

Could someone provide me with some code to hold an object reference in a static variable in a function. function a(&$t){ static $b; if(is_object($b)){ print "IN - $b->logfile"; } else {...

PHP

Weird Backup DB Problems in SQL Server 7

by: jwbeaty | last post by:

Here's a weird one. I'm running SQL Server 7 and when I run a backup something weird happens. When I perform the backup via Enterprise Manager by right clicking on the database I want to...

Microsoft SQL Server

loosing Databases ??? Help

by: Oldgradgreg | last post by:

HI everyone I am running SQL Server 2000 version 8.00.00 set up in client mode and am using the MSDE version 7.00.623 which i had installed of the office 2000 disk. I was going okay for a...

Microsoft SQL Server

Deleting folder "Temporary Internet Files"

by: Rosa | last post by:

Hi, I'm trying to clear the TIF on Windows XP programmatically with the below code. This code works fine on any folder but the TIF. For some reason the atEnd() statements always defaults to true...

Javascript

Executed SQL-statements in a logfile?

by: Kenneth | last post by:

Hi Is it possible to see all kinds of executed SQL-statements in a logfile? If yes, how do I do that and how much information does it log? Thanks, Kenneth

DB2 Database

PRUNE HISTORY question

by: Phil Sherman | last post by:

UDB LUW (Windows) 8.1 FP9a I issued a PRUNE HISTORY 20050819 AND DELETE and was surprised to see that the archived log files were not physically deleted. The history record of the 20050818...

DB2 Database

Logfile analysing with pyparsing

by: Andi Clemens | last post by:

Hi, we had some problems in the last weeks with our mailserver. Some messages were not delivered and we wanted to know why. But looking through the logfile is a time consuming process. So I...

Python

Logfile for my App not "rewriting"

by: Adam | last post by:

Hello, I have a small app I am creating to crawl a directory and check that if it is moved to another a location it's path will not break a character limit. Usually the Windows path limit. ...

Python

please help me correct the errors in this program.have to submit theproject tomorrow!!

by: priyajohal | last post by:

#include<fstream.h> #include<process.h> #include<stdlib.h> #include<conio.h> #include<string.h> #include<dos.h> #include<ctype.h> #include<stdio.h> void setup() void help();

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Logfile in SYSFILES(mssql7) deleted

Similar topics