Can I get an online service where I can upload the files on rapidshare.com and get them analysed and recovered?

The database has one filegroup.

Regards

The DB had two files a .mdf of 68MB and a .ndf of 12GB

We certainly reinstated the backup two days ago, but still, there is some very important data we need from the crashed DB. We are going to look for tools that...

Hi,

I have tried to combine the two files that look most likely. The database is surely an sql 2008 database migrated two years ago from Navision 4.0

Here is the...

Thanks, I heed your advice. OK, I had saved a version of the files on a different location.

I am not very sure if the files I'm working on are from...

Thank you GilaMonster for the patience.

When run this command:

I get this status

RECOVERY_PENDING

Then i've run this commands

I get: Configuration...

The state of the database is

RECOVERY_PENDING

Another thing,

The original files on the backups show that the files were called

UTraining_Data.mdf

Training_1_Data.ndf

Training_log.LDF

But when I peep at the .mdf file I'm relying on for...

The log file we had on the working database was only 1MB, while our database was 12GB.

How can we continue without the logfile?

I have three files

.mdf (primary database)

.ndf (secondary database)

.ldf (log)

And some different versions of the files that I'm not sure of.

-

OK, When I create a similar database and swap the files with the damaged file, then try to get the database online again, I get the error

An exception occurred while...

Here is my T-SQL code

USE [master]

GO

CREATE DATABASE [training] ON

( FILENAME = N'G:\test\UTraining_Data.mdf' ),

( FILENAME = N'G:\test\Training_log.LDF' ),

( FILENAME = N'G:\test\Training_1_Data.ndf' )

FOR ATTACH

GO

if exists (select name from master.sys.databases sd...

Thanks,

Suppose we get the .mdf and .ndf, but no log file, can we move from there?

Thank you very much GilaMonster.

After running the t-script, I get this message.

Msg 5173, Level 16, State 2, Line 1

One or more files do not match the primary file of the...