MSSQL7

I am a beginner with MSSQL7 so please bear with me. I am trying to open a
database that is approx 187KB in size. This file resides in the following
folder; C:\MSSQL7\DATA. This was restored from a backup we reterived from a
subjects computer. I obtained a copy of the MSSQL7 software. I was able to
load it on a standalone computer. This is as far as I can get. I want to be
able to copy the 187KB file in the approporiate folder of this newley
installed MSSQL7 program so I can simply open up the tables and see the data.
When I start Enterprise manager, I can't seem to connect it to this old
database.
Please help
cart34@.netzero.net
Have a look at these. You can use sp_attach_db to add it to the new server.
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
"Cart34" <Cart34@.discussions.microsoft.com> wrote in message
news:522E836E-979C-4D80-8823-949D3148A6A9@.microsoft.com...
>I am a beginner with MSSQL7 so please bear with me. I am trying to open a
> database that is approx 187KB in size. This file resides in the following
> folder; C:\MSSQL7\DATA. This was restored from a backup we reterived from
> a
> subjects computer. I obtained a copy of the MSSQL7 software. I was able
> to
> load it on a standalone computer. This is as far as I can get. I want to
> be
> able to copy the 187KB file in the approporiate folder of this newley
> installed MSSQL7 program so I can simply open up the tables and see the
> data.
> When I start Enterprise manager, I can't seem to connect it to this old
> database.
> Please help
> cart34@.netzero.net