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.
|
