The domain accounts running our SQL Servers have admin rights.  I would also make sure you have another user with sys admin rights besides your own account, not just in...

It should.  However, I would recommend that you backup to a local drive and then copy the backup file to the network share and then if needed delte the local copy...

Your destination should look something like this:

\\servername\sharename$\dbbackupfile.bak

If you have a space in the file name, you may also need to surround the entire destination string in double quotes.  Personally,...

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?