And what about the filename for the backup file?  What is it?

What exactly are you entering in the destination, and how are you entering it?

Post the SQL command you are using to backup your database.  It will help in debugging the error.  Also, be sure that the user that SQL Server runs under has...

Yes, you can using EM.  Just be sure you have the transaction log backups running, as the Full and Differential backups do not truncate the transaction log.

Mirroring was enabled with Service Pack 1 for SQL Server 2005 and is now supported by Microsoft.

Loner, I think there is a slight logic error in your SQL.  Shouldn't the where clause look like this:

WHERE t.pk_ticket = '34950' and DATEDIFF(hour, t.createdate, c.createdate) > 24

Try this in a test database first:

update dbo.table1 set

    Division = t2.Division

from

    dbo.table1 t1

    inner join dbo.table2 t2

        on (t1.[Salon #] = t2.[Salon #])

The databases you are trying to backup are probably set to SIMPLE recovery mode.  In this mode, transaction log backups can not be done, as the transaction log is truncated...

It also depends on where you are adding columns.  If you are adding columns between existing columns, then the system needs to recreate the table and move data.  If you...

Here is your select statement:

select

    (len(ivrs)-len(replace(ivrs,'7104','')))/len('7104')

where

    projectid = 2223

    and systemid = 6

    and calldatetime between '2006-10-01 00:00:00' and '2006-10-31 23:59:59'

    and attresult in (2)

Based on this, there...

Have you checked the properties of your source text file in your DTS package?  I have seen the problem you encountered, and the fix was to set the text delimiter...

Just curious, but I don't see a FROM in the SELECT, is something missing?

Googling Hyderabad it looks like it is in India:

On the csv source in you DTS package, be sure you have the Text Qualifier set to Double Quote ".  It sounds like it may be set to none.

hth

Full backups do not truncate the transaction logs, only transaction log backups do that.  During a full backup, only enough of the transaction log is backed up to ensure a...