It sounds like you don't backup your transaction log. Have you ever done a full backup? If not, DO IT NOW!!!

If you have done a full backup, backup the transaction...

Please don't double post. You also posted this in the Administration forum and that's where I saw it first. Look there for responses.

-SQLBill

1. What type of Authentication is your database server set to? Use Enterprise Manager, right click on the server, select Properties, go to the Security tab.

2. What type of Authentication...

Alvin,

Please don't submit multiple posts on the same question. It makes it difficult for those who might respond. I responded to your other post only to find this one and...

Your maintenance plan is making separate backup files. Your TSQL plan is using only one backup file. The issue is that when the backup is appended to an existing file...

Forgot one thing....is this a replicated database? If so, BOL says it must be unpublished for sp_detach_db to work.

As for privileges, you must be a member of sysadmin on the...

In Query Analyzer you could run:

sp_detach_db and sp_attach_db. Refer to the BOL for more information.

Also, do you have the appropriate privileges to detach/attach a database?

-SQLBill

I've never used CASE in a WHERE (it can be done, but I'm not sure exactly how). But taking a stab, I think the CASE is in the wrong place:

AND

CASE...

Check the obvious....is the 'write protect tab' on the tape in the protect position?

What size is the tape? Are you only backing up the user database to this tape? Or...

Are you trying to backup all your databases at once (one right after the other)? If so, the connection might be timing out.

Is this happening every time you try to...

I had a HUGE problem with Veritas BE and their Agent for SQL Server. First thing - it was a VERY specific issue.

I bought Veritas BE 8.6 with my DELL...

Or use BETWEEN:

WHERE g.GameStartDateTime BETWEEN a.startdatetime and a.enddatetime

-SQLBill

Transaction Log:

Do you backup your logs? (BACKUP LOG dbname) If not, you need to start doing that or as the previous poster said, change your Recovery Mode to SIMPLE (in...

Have you looked in the Windows Event Viewer logs (application, security, system) for any other messages? They might shed more 'light' on the error.

This is what Error 1117 means to...

1. Check the SQL Server Error Log for any error messages.

2. Check the Windows Event Viewer Logs (application, security, system) for any messages.

3. Do you know of anything (maintenance) happening...