I appreceiate that comment. We have absolutely no need for point in time restores. Its a web discussion board using the same forum software used here.

Thank you very much,

Since I was not real sure what I was doing I was a little nervous about running shrinkfile, I was hesitating to run it becasue I wasn't...

Question.

I have a SQL 2000 database with no need for anything but the simple recovery mode.

I have an ldf file that is 6 times the size of my database and...

Thank You Jeffrey,

I found the source of the error message in the jobs folder and disabled it.

Once I can complete both a database and transaction log backups without any...

I have both recent database and transaction backups. The two remaining issues with the database now are;

1. The transaction log is not shrinking with a backup.

2. Errors during the transaction...

It can do this without the missing log backup that its looking for? without losing anything?

Thats what I'm wondering about?? Why didn't the transaction log shrink? Why is it still asking for the old file?

Heres where I'm at now

The back up folder I created on another drive now has these files.

1.8 Gb BAK file

11.2 Gb TRN file

77 Mb TRN file

65 Mb TRN...

Krishna Potlakayala

I thank you very much. I'll feel a lot better after I have a good backup of the database. You got me close enough to figure it out....

I gave the backup location a filename and the bak extention. Is seems to be running. At least I have no error message, yet!

That gets me here,

Server: Msg 3201, Level 16, State 1, Line 1

Cannot open backup device 'E:\SQL Backup'. Device error or device off-line. See the SQL Server error log for more...

OK I ran this

BACKUP DATABASE 'mydatabase' TO DISK='E:\SQL Backup'

and I get his response

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'mydatabase'.