Hi,

(1) *Backup the existing files and keep that in some safe place*

(2) Try using sp_attach_db to attach the database and log file. If that
doesn't work try using sp_attach_single_file_db. These commands normally
work with a db that was detached using sp_detach_db. But you can always
try it out.

--
EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf'


EXEC sp_attach_single_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf'

Look up Books on line for more info.

Hope this helps!!

John


-----Original Message-----
From: Rida Rose [mailto:[Email Address Removed]
Sent: Thursday, July 24, 2003 10:10 AM
To: LazyDBA.com Discussion
Subject: My SQL Server is corrupt

Hello
I am in a serious problem. My Sql Server has gone corrupt so I had to
reinstall it. The problem is that I dont have the backup with me and
very
important data was in the database. My data file and log file were on
the
other partition so database.data and database.log are intact but I dont
know
how to connect this information to the sql server. Please help me if
any
one can. I am waiting desperately.

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page