Restore Database

RS8

Hi all,

I am having Navision Database in ldf & mdf. how can i restore this database through Sql.
Can anyone suggest me.

thanks
Rs

navuser1

RS8 wrote:

Hi all,

I am having Navision Database in ldf & mdf. how can i restore this database through Sql.
Can anyone suggest me.

thanks
Rs

Create the Db thru SQL and attach these two.

kine

You do not need to create the DB on SQL, just use the Attach functionality and select the DB name and the files.

navuser1

Ick !!!

Yes. Kine is right.

### In SQL Server Management Studio Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance.

### Right-click Databases and click Attach.

### In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .mdf file of the database; for example:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Data.mdf

hardik_shah

Ya...u have to just Attach file.....BUT be careful make advance copy of it........ :thumbsup:

navuser1

May be You can get more same reply from different people. :whistle: