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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: