Can''t attach a database !!!

Question

Post reply

Can''t attach a database !!!

Nelson Arguello

SSC Rookie

Points: 45
More actions
June 12, 2006 at 12:43 pm

#115461

Server: Msg 3624, Level 20, State 1, Line 1

Location: recovery.c:2151
Expression: curr->log_length > 0
SPID: 10
Process ID: 512
Connection Broken
Anybody please help!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 1

Does the MDF or LDF have the "Read Only" attribute set?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Maria-Raluca SSC Enthusiast Points: 101 More actions · Answer 2

Hi,

What is the size of database? The database have the secondary data files?

Nelson Arguello SSC Rookie Points: 45 More actions · Answer 3

Hi Jeff, hi Maria !!!

Thanks for your support!

The answers are:

No, the files do not have the Read Only attribute.

The data files are:

posTerminal_Data.mdf 102,400 Kb

posTerminal_Log.ldf 25,600 Kb

Johan Bijnens SSC Guru Points: 135551 More actions · Answer 4

- was the database detached in a propre way ? (detatchdb ...)

- you may be better off with backup/restore

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 5

Hadn't thought about that... if the DB was NOT properly detached, the procedure for recovery is quite long. It's do-able, but ya gotta hold your mouth just right while you're going through the steps.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Nelson Arguello SSC Rookie Points: 45 More actions · Answer 6

MSSQL Recovery 2.2 at http://www.officerecovery.com is the solution !!!

What a great tool !

Thank you all for your help.