Gurus,

I am still struggling with the restoration problem
some of you tried to help me with last week.

This is a last time I need your opinion on this.

I have tried the following steps in the meantime.


1] I checked and found out that the sort order and
code page on both SQL 7 servers are same.
2] I tried

exec sp_attach_db N'RFQ',N'C:\MSSQL7\Data\RFQ.mdf',
N'C:\MSSQL7\Data\RFQ_log.ldf'
and got the error below.
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'C:\MSSQL7\Data\RFQ_log.ldf' is
not a valid database file header. The PageAudit
property is incorrect.


3] I also got a .Bak file of that database.I then
tried with SQL 2000.I first created RFQ DB on SQL
2000, then took a backup and replaced the .Bak file
with the SQL 7 .Bak file.
When I restored this .Bak file the database shows as
"LOADING" for 30 minutes now after restoring.

I have 2 questions here.

1] Does anyone knows how to check if a given file eg.
.Ldf or .Bak is corrupted and can not be recovered.
2] What does this "LOADING" means and would I get the
database back.How long it should be "LOADING".


Also as some of you have suggested to check with
attach with single file DB , I tried that but it also
didnt work.

I think it has to do with the files.May be they are
corrupted or something.


Any suggestions would be helpful for me.

Thank you all very much,
Parag

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
MS Sql Server LazyDBA home page