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.
Dig Deeper on SQL Server Backup and Recovery
Related Q&A from Greg Robidoux
Back up tables from a SQL Server database to a file with these commands.continue reading
Find out how to restore data from a corrupt database.continue reading
Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.