Been there ! take a look inside the process and check if it's trying to send notification mails. If the mail server is down (or other problems...

Maybe you have the select into/bulk copy option checked in your db, and operations like bulk insert, bulk copies, truncate tables are made against it. This kind of operations are...

I will try this method, thanks for your help!!!

RonKyle: Forget about the logins, there is only one that is used by a tool that can be changed. About the 'reattach option', correct me if i´m wrong, you need...

I don't think that exists a rule for that. As others say, there are different kinds of enviroments. If you are a 'fire fighting' DBA, maybe a few instances are...

pscsvln: are you saying that i must try to recover the db in other server, recovering first the master? If this, remember that i don't have backups availables...

racosta: No, i...

Thanks for your response.

Regards

The disks configuration is the same than the old server. The OS resides on a 9 gb RAID 0, and the DB files on a 60 Gb RAID 5.

I didn't change the SQL version, the only upgraded was the operative system (NT4 -> W2K Server)

If your jobs has notifications via e-mail, and the mail server is down, they stays in the 'performing actions' state until the agent can send the notification. Because that maybe...

htrivedi_2000 (please, use a friendly nick :))), i resolved my problem, maybe you´re in the same situation. I was using Outlook 200 SR3 as a mail client. This Security...

Hey, i'm fighting with a similar situation right now...

W2k Server SP3, SQL Server St.Ed. SP4. The SQL mail start and stops fine, but when i try to execute xp_sendmail on...

Look in http://support.microsoft.com/default.aspx?scid=kb;en-us;290622

It referes to system databases, but i have the same issue on user dbs...try to uncheck the option 'Attemp to repair minor problems' and see what happens...

Steve, the restriction for SQL7 is 2 gb (see

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750).

Antares, the same article mention the /3Gb restriction on Windows 2000 Server (The version that i have)

I finally used the old fashion way...local backup - compression - transfer. All the proccess spend 75 minutes, against the 380 used in the old method.

Thanks all for the suggestions!

...