My Data Base Gone. SOS PLease

General discussion

Creator

Topic
June 17, 2000 at 9:14 pm #2073961

My Data Base Gone. SOS PLease

Locked

by davood_f · about 22 years, 11 months ago

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.
Creator

Topic

All Comments

Author

Replies
- June 18, 2000 at 9:11 pm #3778114
  
  My Data Base Gone. SOS PLease
  
  by m2 · about 22 years, 11 months ago
  
  In reply to My Data Base Gone. SOS PLease
  
  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!
  - September 20, 2000 at 7:04 pm #3754879
    
    My Data Base Gone. SOS PLease
    
    by davood_f · about 22 years, 8 months ago
    
    In reply to My Data Base Gone. SOS PLease
    
    The question was auto-closed by TechRepublic
- June 18, 2000 at 10:05 pm #3778107
  
  My Data Base Gone. SOS PLease
  
  by ron navon · about 22 years, 11 months ago
  
  In reply to My Data Base Gone. SOS PLease
  
  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
  - September 20, 2000 at 7:04 pm #3754880
    
    My Data Base Gone. SOS PLease
    
    by davood_f · about 22 years, 8 months ago
    
    In reply to My Data Base Gone. SOS PLease
    
    The question was auto-closed by TechRepublic
- September 20, 2000 at 7:04 pm #3754878
  
  My Data Base Gone. SOS PLease
  
  by davood_f · about 22 years, 8 months ago
  
  In reply to My Data Base Gone. SOS PLease
  
  This question was auto closed due to inactivity
Author

Replies

Viewing 2 reply threads

Start or Search

Start New Discussion

Cybersecurity demands and the stakes of failing to properly secure systems and networks are high. While every organization’s specific security needs form a unique and complex blend of interconnected requirements, numerous security fundamentals almost always apply to each of these groups. It stands to reason that cybersecurity pros who effectively identify network and systems risks ...

In this guide from TechRepublic Premium we’re going to explore the various things you can do with a Linux server. We won’t leave out any steps, so you won’t have to refer to another tutorial to complete the process. The only step we will leave out is the installation of Linux, as we’ll assume you ...

If you want to deploy applications into a Kubernetes cluster, be warned — it’s not the easiest task. There are a lot of moving pieces that go into these scalable containers. Don’t you wish you had a complete roadmap, from start to finish, to walk you through the process of deploying the Kubernetes cluster, deploying ...

Networks

General discussion