Networks

General discussion

Gravatar
0 Votes
Locked

My Data Base Gone. SOS PLease

By davood_f ·
some one has deleted my database in sql server 7.0
now I only have two file ,those are in :
..\sqlserver7\Data\myDB_Data.mdf &
..\sqlserver7\Data\myDB_Log.ldf
Can I gain my database completly again?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

My Data Base Gone. SOS PLease

by m2 In reply to My Data Base Gone. SOS PL ...

try following from Query Analyzer:

sp_attach_db 'myDB', 'c:\MSSQL7\Data\myDB_data.mdf','c:\MSSQL7\Data\myDB_log.ldf'

Good luck to you!

gravatar
Collapse -

My Data Base Gone. SOS PLease

by davood_f In reply to My Data Base Gone. SOS PL ...

The question was auto-closed by TechRepublic

gravatar
Collapse -

My Data Base Gone. SOS PLease

by Ron Navon In reply to My Data Base Gone. SOS PL ...

Dear Sir,

Keep the mdf and ldf file in the side, make a data base with the same name, stop the services of SQL change the rename the new mdf and ldf, copy the old mdf and ldf.
restart the server.
I hope that is help you. Ron

gravatar
Collapse -

My Data Base Gone. SOS PLease

by davood_f In reply to My Data Base Gone. SOS PL ...

The question was auto-closed by TechRepublic

gravatar
Collapse -

My Data Base Gone. SOS PLease

by davood_f In reply to My Data Base Gone. SOS PL ...

This question was auto closed due to inactivity

Back to Networks Forum

Start or search

Related Discussions

Related Forums