Database disconnected from server

SQL Server 2000
Our server froze up and forced a reboot.
When the server came back online, the database was
no longer listed in EM as a database but the datafiles
themselves still exist. In addition, it appears that SQL
Server may still be "holding on" to the data files since when
I try to delete them, the operating system tells me they
can't be deleted.
I'd like to just reattach the datafiles to the server
and have the database reappear. How can I do this?Try to stop SQL Server service move the .MDF and .LDF to
other folder and then start SQL Server again. Move back
SQL Server files to their original folders and then
reattach the database.
Cesar Kubo
>--Original Message--
>SQL Server 2000
>Our server froze up and forced a reboot.
>When the server came back online, the database was
>no longer listed in EM as a database but the datafiles
>themselves still exist. In addition, it appears that
SQL
>Server may still be "holding on" to the data files since
when
>I try to delete them, the operating system tells me they
>can't be deleted.
>I'd like to just reattach the datafiles to the server
>and have the database reappear. How can I do this?
>
>.
>|||Hi Simon,
Happy New Year and thank you for using MSDN Newsgroup! It's my pleasure to
assist you with your issue.
From the information you provided, your SQL Enterprise Manager cannot get
the information of the database, but its MDF and LDF is still in you disk.
You cannot delete them because the system informed you that them are still
in use. You wonder if you can reattatch this files so that the SQL Server
Enterprise Manager could show the database and manage the database, right.
From my experience, in most cases, it is SQL Service that is still using
this file. You can stop the SQL Server Service.
Then, restart you SQL Service, and in you Query Analyzer, run the following
batches:
exec sp_attach_db @.dbname='your_database_name'
@.filename1='MDF_file' --for example: 'c:\test.mdf'
@.filename2='LDF_file' --for example: 'c:\test_log.ldf'
If you do not want to use the former log file, run the following:
exec sp_attatch_single_file_db @.dbname='your_database_name'
@.physname='MDF_file' --for example: 'c:\test.mdf'
Note: The system will create a new log file, but all the information in the
old log file will be lost.
Hoping this information will be helpful in solving your problem. If you
still have questions, please feel free to post new message here and I am
ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Database corrupted since windows reboot

Hi,
My librarian has a problem with is computer. He uses it to store all of
his client's asks, his inventory, etc... on a SQL server's database,
with the help of a third part program, and he never restart his computer.
He few weeks ago, some problems on our city (in France), make his
computer turn off, then restart. And while windows was restarting, it
install to him the latest version of some software - but he didn't
notice which one. And when he turns on the program, the sql server's
database where corrupted, and he wasn't able to use it again:
unfortunately, the program was using it when the computer turn off.
Nonetheless, he didn't made any daily save, so he lost all the
information about his business since a month...
He would like to know if there a way to repair the database, in order to
use it again, instead of restart from 0. He write to the program's
maker, but he wasn't able to restore the data, and a google search
didn't help: none of the answer where about this problem... So is there
any special keywords that I could use, or a known way to repair the base?
Thanks a lot for answer,
Aramiil
Hi,
Could you please answer to below queries:-
1. Are you able to start your SQL Server Service?
2. Did you gone thru the SQL Server Error logs and Event viewer?
3. What is the exact error you ere getting or you have pointed out?
4. How did you come to the conclusion that your database is crached?
Thanks
Hari
SQL Server MVP
"Yann PIQUET" <aramiil@.neobelari.com> wrote in message
news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
> Hi,
> My librarian has a problem with is computer. He uses it to store all of
> his client's asks, his inventory, etc... on a SQL server's database, with
> the help of a third part program, and he never restart his computer.
> He few weeks ago, some problems on our city (in France), make his computer
> turn off, then restart. And while windows was restarting, it install to
> him the latest version of some software - but he didn't notice which one.
> And when he turns on the program, the sql server's database where
> corrupted, and he wasn't able to use it again: unfortunately, the program
> was using it when the computer turn off. Nonetheless, he didn't made any
> daily save, so he lost all the information about his business since a
> month...
> He would like to know if there a way to repair the database, in order to
> use it again, instead of restart from 0. He write to the program's maker,
> but he wasn't able to restore the data, and a google search didn't help:
> none of the answer where about this problem... So is there any special
> keywords that I could use, or a known way to repair the base?
> Thanks a lot for answer,
> Aramiil
|||Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1=2E Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2=2E Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3=2E The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder =E0 la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4=2E idem
Thanks a lot for answer.
Hari Prasad a =E9crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
th[vbcol=seagreen]
ter[vbcol=seagreen]
e=2E[vbcol=seagreen]
am[vbcol=seagreen]
r,[vbcol=seagreen]
|||Hi,
The error logs attached are in French.. Sorry , I am not able to understand.
Thanks
Hari
<apislibrairie@.wanadoo.fr> wrote in message
news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1. Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3. The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4. idem
Thanks a lot for answer.
Hari Prasad a crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
|||Hi,
Sorry, I've forgot to translate them... Here are two of them translated
in english (I hope I didn't do too many errors in translation :-/), I'll
post a link to the others one when I'll have finish them.
http://www.neobelari.com/SQLAGENT_eng_part1.zip
Thanks,
Aramiil
Hari Prasad a crit :
> Hi,
> The error logs attached are in French.. Sorry , I am not able to understand.
> Thanks
> Hari
> <apislibrairie@.wanadoo.fr> wrote in message
> news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
> Hi,
> Well, I don't really know about SQL server, so I just can answer a few
> of your questions:
> 1. Yes, I'm able to start my SQL Server Service, and to use an older
> save of the databse, aged of near a month.
> 2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
> 3. The program (called Octave) display a message with this: "Base
> corrompue, impossible d'acceder la base". I'm not used to work with
> SQL server, so I don't have any other informations by the sql server
> 4. idem
> Thanks a lot for answer.
> Hari Prasad a crit :
>
>