Restore a database on SQL Server using .mdf, .ldf and .ndf files?

You need to attach the database rather than perform a restore.
Using Enterprise Manager:
Expand the registered SQL server
Right-click Databases, select All Tasks -> Attach Database…
Click the “…” button to browse for the .mdf file
Highlight the necessary .mdf file and click OK
Click OK again
The database will now show up in Enterprise Manager

To use Transact-SQL, use the Query Analyzer tool:
Here is sample command based on your files above. You will need to specify the correct directory where these files exist. The example has the files in the C:\SQL directory.
EXEC sp_attach_db @dbname = N’rs_ds’,
@filename1 = N’C:\SQL\rs_ds_dat1.mdf’,
@filename2 = N’C:\SQL\rs_ds_dat3.ndf’,
@filename3 = N’C:\SQL\rs_ds_dat4.ndf’,
@filename4 = N’C:\SQL\rs_ds_dat2.ldf’

  • Email, SSL
  • 0 Bu mövzunu faydalı görən istifadəçilər:
Bu mövzu kifayət qədər köməkçi oldu?

Related Articles

Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs ->...

Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users....

Fix nameservers not working for Linux servers

If you have your own namerservers or you are using nameservers provided by host, and these...

Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system...

How does memory overcommit affect PostgreSQL?

In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL....