How do I restore the DB

Aug 24, 2009 at 9:05 PM

I tried to restore a database using the backup, and it fails on SQL Server 2005.

Is this only for the express version?


Aug 24, 2009 at 9:30 PM

I found the problem.

You have to set the restore to overwrite the database since the log is not backed up.

HOWEVER, be sure you don't need the log fiel.  It contains transations that are useful for the recovery of transations.  Generally, these backups are used to recover from dire conditions, and the log files are not generally going to help.