July 17, 2010 at 5:43 am
we are having DBs in SQL 2000 earlier ...
now the server is upgraded to SQL 2005
I want to copy the .mdf and .ldf files from SQL 2005 server to SQL 2000
--- attach these DBs back to SQL 2000
--- All the DBs are in SQL 2000 compatibility mode (80)
-- All the DBs are in full recovery mode
---Bottom line T-Logs should not be truncated while attaching DBs
---------Any Help from Any body >>>>>>>???????????????????
July 17, 2010 at 6:33 am
Can't be done, I'm afraid. Once the database has been upgraded, the files cannot be attached to an earlier version.
If you tell us more about why you need to do this, we may be able to offer some workable alternative strategies.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
July 17, 2010 at 7:32 am
This related to your attempts to recover data from that 2005 database http://www.sqlservercentral.com/Forums/Topic953659-391-1.aspx?
If so, my advice on that thread stands. The only way you even have a chance to recover without a backup is to buy that log reader tool. There's no free log recovery tool for SQL 2005, there's no way of downgrading databases to SQL 2000 and without any backups at all, there's no way you can restore to before the delete.
Also, the longer you wait, the less chance there is of recovering anything.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 17, 2010 at 7:39 am
GilaMonster (7/17/2010)
This related to your attempts to recover data from that 2005 database http://www.sqlservercentral.com/Forums/Topic953659-391-1.aspx?
That would explain a lot. Thanks, Gail.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
July 19, 2010 at 5:31 am
Thanks to all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply