Database Not Displaying

• Kailasapathi

  Newbie

  Points: 1

  More actions

  December 7, 2004 at 8:01 am

  #87116

  Hey all,

  I have a problem with MSSQL Server, due to the system crash i need to reinstall the MSSQL Server, when i did it ,it is not recognizing or showing the database that i created in the default root of EnterPrise Service. I copied to original database in the root folder of MSSQL Server ie, to the DATA folder and restarted the services, then also it is not displaying the database that created. Then i tried to create the new database assigning the same name of the original database, but MSSQL Server raises error - Database already Exist.

  Please someone help me to solve this problem. I am in trouble.

  Thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  December 7, 2004 at 8:31 am

  #532842

  You have to re-attach your dataabses to SQL Server after it is reinstalled. Check BOL sp_attach_db command.

  Do you see any databases by running sp_helpdb from Query Analyzer?

   

• hemant-168592

  SSC Rookie

  Points: 25

  More actions

  December 13, 2004 at 9:00 am

  #533569

  Just right click the database and click on attach database from the C:\Program Files\Microsoft SQL Server\MSSQL\Data\databasename.mdf. this will do