I am not able to access the tables in MS-SQL server,after my OS crashed,though i have all the files?

Question

Hello guys;I created a database in MS-Sql Server 2000 and entered data into the tables and after some days my OS crashed and i am not able to access those data and tables.But i have all the files and not able to get them back in a newly installed SQL(same version).Is there any way to get them back.Thank you.

Answer 1

If you have backup of your database? If you have reinstalled the OS obviously you must have reinstalled SQL Server also. In that case you need to create the database again and restore the data from Backup File. If you don't have backup files but if you have DBName.ldf and DBName.mdf files from previous installation then also you can retrive your data by creating the the database with same name and coping (Replacing) those files in your new installation folder.

Answer 2

Use attach command to connect database files to server.