Nope you can go from 2000 to 2005 but 2005 to 2000 a no go.
I am not sure why you would want to go back as 2000 won't be supported
in the future.


Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886

-----Original Message-----
From: Harsh Kumar
[mailto:mssqldba-ezmlmshield-x64516520.[Email address protected]
Sent: Wednesday, May 31, 2006 3:50 AM
To: LazyDBA Discussion
Subject: >mdf nad .ldf of 2005 attached with 2000


Hi all,
My sql server 2005 has been crashed.
Right now I have no environment of sql server 2005 and don't want to
make
new sql server 2005 environment.
Is it possible to use .mdf, .ldf file of sql server 2005 to sql server
2000
with attach .
I tried but after that database become in suspected mode.
Any one help if a database in suspected mode how I can make it in normal
mode.
I follow the sp_resetstaus, and update sysdatabases, but cant make it
live.
Pls help.
Thanks in advance.

Regards,
Harsh Kumar
Database Administrator - IT Dept.
9213469176




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


************************************
This e-mail and any files transmitted with it are proprietary and intended solely
for the use of the individual or entity to whom they are addressed. If you have
received this e-mail in error please notify the sender. Please note that any views
or opinions presented in this e-mail are solely those of the author and do not
necessarily represent those of ITT Industries, Inc. The recipient should check
this e-mail and any attachments for the presence of viruses. ITT Industries accepts
no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page