how to restore database from data files 1

[Guest_imported]

Hi there,

I am new to sql server. I have a database that i have to restore but I don't have the restore file, the only files i have are the mdf and ldf files when the database was created.

Which option should i choose to restore this database?

thanks,
Pi

 

[RickCole]

Copy the mdf and ldf files to the required location on your SQL Server and then use the stored procedure sp_attach_db.

BOL will give you more details on this procedure which should achieve what you require.

Rick.

 

[Jokauw]

What version do u use ?
If u use SQL Server 2000, you can easily do this kinda problem....
Coz, SQL Server 2000 has added new feature for easy to use, named = Attach Database.

To find this new feature, kindly do a right-click on your mouse at Database and you can find a dropdown menu named = Attach Database...

Dialog box will show up, and u can follow the instructions. U can browse to the location of your MDF, nd tadaaaa.... it's done....

(Just follow the instructions at the dialog box)

Wille