If I decided to restore the databases in the other server, is there a way to erase all the data of the tables?

I mean an easy way

Is Red Gate SQLCompare expensive?

I forgot the log and the mdf are in diferent drives, and I 'm using sqlserver2005

Thanks for all your hep!!!!

This is the log information:

2007-11-28 00:00:03.68 spid53 Starting up database 'bdImpOfertas'.

2007-11-28 00:00:03.76 spid53 Error: 602, Severity: 21, State: 50

2007-11-28 00:00:03.76 spid53 ...

Thanks for all your help that gave me a clue, about what I need to considerate.

We are a chain of supermarket that sale groceries in Mexico, and each day the number of trasaction with credit or debit card is increase, so if we don't have...

The text file is create by another aplication and every day the package delete the sql table and fill it with the information in that text file.

Thanks for your help...

Thanks for the help!!

You are right I have a colum (varchar 8) that have the time

02:02:34   for 2 am

14:21:21   for 2 pm

This the query that I do but I only obtain the information...

Whe are not dealing with date & Time, just Date.

And how "Dave I" said I need the balance at certain day. One row per employee.

Thanks for all you help.

What I did was to run this instruction on the Query Analyzer:

backup log "bdValeE" with truncate_only

The database name is "bdValeE"

Then in the Enterprise manager:

Right click...

There is no backup and my database wasn't on full recovery mode

so true, I don't have excuse, it was my mistake.

Someone else drop the table but I don't have any backup.

I don't have a backup, the program that we have to make backups does have enough licenses, so I guess know they will buy more.