Restore cold backup of database files

I have some questions.
A customer had a drive crash on their win2003 server running mssql
2000. I have a full backup to tape but it's a day old. I was able to
get a copy of the database files off the server before it crashed all
the way. I will be reinstalling win2003 and sqlserver.
My question is can I copy the database files back into the dirctory and
have the new install of mssql 'see' my database?
Thanks,
David
Yes, you can use the stored procedure, sp_attach_db, to attach the database
files.
You may also need to fix any orphaned users in the database. See the topic
"Troubleshooting Orphaned Users" in Books Online.
David Portas
SQL Server MVP
|||In addition to David's comments you may find these useful:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
<daviddnv@.yahoo.com> wrote in message
news:1103406101.650789.272580@.c13g2000cwb.googlegr oups.com...
>I have some questions.
> A customer had a drive crash on their win2003 server running mssql
> 2000. I have a full backup to tape but it's a day old. I was able to
> get a copy of the database files off the server before it crashed all
> the way. I will be reinstalling win2003 and sqlserver.
> My question is can I copy the database files back into the dirctory and
> have the new install of mssql 'see' my database?
> Thanks,
> David
>