Restore Database

Hi,
I've two files : ora8i_Data.MDF, ora8i_Log.LDF, from a database 'ora8i' from
another PC (other SQL server).
How can i restore this database to (my PC) my SQL server ?
Thanks in advance,
Hatziyannis ApostolisCheck out RESTORE DATABASE in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"microsoft" <apostolis@.orbis.gr> wrote in message
news:%23SqcNxa%23FHA.2704@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I've two files : ora8i_Data.MDF, ora8i_Log.LDF, from a database 'ora8i'
> from another PC (other SQL server).
> How can i restore this database to (my PC) my SQL server ?
> Thanks in advance,
> Hatziyannis Apostolis
>
>|||microsoft wrote:
> Hi,
> I've two files : ora8i_Data.MDF, ora8i_Log.LDF, from a database 'ora8i' fr
om
> another PC (other SQL server).
> How can i restore this database to (my PC) my SQL server ?
> Thanks in advance,
> Hatziyannis Apostolis
Use sp_attach_db. For example:
EXEC sp_attach_db 'DATABASE_NAME',
'c:\mssql_data\ora8i_Data.MDF',
'c:\mssql_data\ora8i_Log.LDF' ;
Make sure you keep a safe copy of the original.
David Portas
SQL Server MVP
--|||See if the procedure sp_attach_db can help you:
Look in the BOL:
sp_attach_db
Attaches a database to a server.
(...)
HTH, jens Suessmeyer.