I haven't tried but thanks.

Thanks.  I will give it a try.

I ran into this error but didn't have time to go back.

What do I need to do when upgrading to SQL 2005 is not possible at this time?  Keep using VS...

Here they are:

CREATE TABLE [Bugs] (

 [BugID] [int] IDENTITY (1, 1) NOT NULL ,

 [ProjectID] [int] NOT NULL ,

 [CreatorID] [int] NOT NULL ,

 [ReportedByID] [int] NOT NULL ,

 [AssignedToID] [int] NOT NULL ,

 [PriorityTypeID] [int]...

Scott,

You are correct, I mistyped.  It should be INT instead of NOINIT.  Each day it starts the first backup WITH INIT, next backups are appended into the first backup using NOINIT. ...

Hi Lynn,

Here it how I name the backups:

1. Monday: full backup to file Monday_Full.BAK, first log backup to file Monday_Log.BAK, next log backups appended to Monday_Log.BAK.

2. Tuesday: diff backup to file...

I appreciate your concern.  However in my scenario all of my backups are assumed valid.  My question was with the backups I have, am I able to restore to 10:14 am? ...

No, there is no activity during this time.  The reason I trucated the log is the log backups are appending into a single file for each day.  Every day the first...

thanks for the reply.  but do you know why my query didn't work?

Have you googled for this error?  Without the data I can't go further.

hth,

Try to export the excel file to a flat file then from the falt file to SQL.  It should work.

i think what he meant was no posibility to restore the database to a certain time using the log.

We don't have the need to do log backup.  Nightly full backup is enough.

The database is part of the custom app we puchased including SQL server and IIS server.  The...