What 'probably' happened was that you somehow lost the file that maintains the information on what instances you have registered in Enterprise Manager.

I would suggest first trying to re-register...

quote: When you say domain\myname is the same as myname, is that true if myname is a standard login type (sql login) and not a Windows User?

Yes. I found...

Look for a job that is running as you. Check both the Owner on the General tab and Run As on the Steps>Advanced tab.

If you find any, change them to...

It's not getting your credentials. Sometimes this can be resolved by installing the latest MDAC version on your workstation.

Also, I would double-check your login on SQL Server. Make sure you...

You have to look at what else is happening at the same time. Deadlocks usually mean that two transactions are trying to use the same resources at the same time.

-SQLBill

Go to Services, find the SQL Server Agent Service. Right click on it and go to Properties. Click on Dependencies tab. The agent service should depend on the MSSQLServer service....

We use the server property 'Database Settings' to set where the data and log default locations are and it always works for us. We use both 2000 and 2005.

-SQLBill

We just went through this issue. I right clicked on the distributer agent, selected the profile and made a new profile setting the skiperrors to the proper code (btw-there should...

BTW - you just use the same command as for the full backup. But change it to WITH RECOVERY.

The only difference is you have to 'point' it to the differential...

Question: On the 28th, what happened first?

Did the Diff backup happen and then the delete? Or was it the delete then the backup?

If the delete happened before the backup, then...

When you did a full backup on the 21st, that 'broke' the differential chain and restarted it. Any diffs you made before the full backup on 11/21 belong to and...

On the tab for Complete Backup, look near the bottom, there should be a place to enter the location for the backup. You have to check the 'radio button' (the...

However, if you don't care about the log file...set your recovery mode to simple. Then SQL Server checkpoints the log file and truncates it. This way you don't have to...

and what is Gupta?

-SQLBill

I would also suggest adding SET DATEFORMAT MDY to the start of your script. Otherwise, how will SQL Server know 09/01/06 is September 1st, 2006? It could be 9 January...