How do I restore a database on SQL Server 7.0 using .mdf, .ldf and .ndf files? I have no backup database available, but I do have the following files: rf_ds_dat_1.mdf, rf_ds_dat_3.ndf , rf_ds_dat_4.ndf and rf_ds_log_2.ldf

    Requires Free Membership to View

    Login

Since you have these files and not a backup, you need to attach the database rather than perform a restore. 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:SQLrs_ds_dat1.mdf', 
 @filename2 = N'C:SQLrs_ds_dat3.ndf',
 @filename3 = N'C:SQLrs_ds_dat4.ndf',
 @filename4 = N'C:SQLrs_ds_dat2.ldf'

Note: SQL Server 7.0 databases can be attached to both SQL Server 7.0 and SQL Server 2000 databases.

Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in September 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top