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  General SQL Server Forums  New to SQL Server Programming  Database Logfile in sysfiles(mssql7)deleted

Author  Topic  georgy8 Starting Member 1 Post Posted - 2006-06-12 : 04:58:09 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.