Yes. If Backup Exec is backing up the same database as you are doing with native SQL Server commands, then yes you are going to have a problem.

Let's say...

I don't use the GUI to do backup/restores. Here is the example from the BOL.

RESTORE DATABASE TestDB

FROM DISK = 'c:\Northwind.bak'

WITH MOVE 'Northwind'...

I'll give you a hint.

USE GROUP BY

-SQLBill

The issue about too many qualifiers happens when you fully qualify the server you are on.

Example:

Linked servers (ServerA and ServerB)

DTS Package created on ServerA.

TRUNCATE TABLE ServerB.mydb.dbo.tableA

INSERT INTO ServerB.mydb.dbo.tableA

SELECT *...

This COULD be the issue:

From the BOL:

COUNT(*) returns the number of rows in a specified table without eliminating duplicates. It counts each row separately, including rows that contain null values.

That...

Bit of advice, when you have an issue and are getting an error, it really helps us if you post the error message. Next it helps if you tell...

Why not start with your local SAN admins? They know the 'care and feeding' of the product as they have to support it.

Make sure you know what you...

check the backup application log -actually means for you to check the Windows Event Viewer Logs. The application log and the SQL Server Error Log are 'tied' together with the...

There are two ways variables/parameters are used. Normally variables are DECLAREd and the value is supplied as the script runs. The other way is for the value to...

What do you mean by a disk backup device? Do you mean a USB device or a removable drive?

If so, one reason would be if you have to supply...

DEPENDS. We never shrink the databases, just let that happen with the backups. We only reindex heavily used databases and then only once a week. Statistics and...

Delete the maintenance plan and recreate it. If it works correctly, it was due to the bug in the service pack. I no longer have the link, but MS...

It could be an issue with contiguous memory. Run xp_memory_size from Master database. This is an undocumented proc, but you can find information about it on the web. ...

Is the database in SIMPLE or FULL Recovery Mode? If it is in FULL, then you probably won't be able to truncate the log until it has been backed up....

I left a job because of issues with a team-mate (another SQL Server DBA). Instead of telling the interviewer the problems I was having, I said that "I was...