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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-03 : 07:59:02
|
| Chris Snyders writes "Hi Please can you guys help me!!I am at a site where someone deleted the log.ldf while in a batch job. I have managed to restore the database by rebuilding the log.ldf file.The database is up but when accessing the Navision it gives me an error "HY00, [MICROSOF][ODBC SQL SERVER DEVICE][SQL WARNING] Warning fatal error 605How can I unlock all 255 tables? I have no backups to work from so am stuck in a bit of a mix.Many Thanks Chris" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-03 : 08:51:07
|
| What state is the database in?Sounds like it may not be completely active although you should have noticed if it was suspect.Copy everything into a new database.>> I have no backups That's your main problem. Decide whether this system is important enought to take backups - if not then get rid of it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-05 : 09:35:05
|
| How did you rebuild the log file? I ask because there is a system procedure that will attach a database without the log file if there is only one data file. I think it's called sp_attach_single_db but I could be a little off. Look in BOL for details.Good luck!HTH=========================================Let X = {All sets s such that s is not an element of s}(X element of X) ==> (X not element of X)(X not element of X) ==> (X element of X) (Bertrand Russell Paradox) |
|
|
|
chetancool
Starting Member
34 Posts |
Posted - 2004-12-07 : 07:31:13
|
| This syntax can also work for system database - MSDB.cjain |
|
|
|
|
|
|
After LDF deleted database restore but not many tables are locked