That must be a typo? Please tell me you don't really have a 25 TERABYTE log file for a 1 GB database?

Just a longshot, but do you have unlimited growth for the files, or a fixed size?

You haven't given us a lot to work with, but this might be what you are after:

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

You need to run the upgrade wizard on the 6.5 databases, or export the data in some other manner (e.g. BCP or DTS).

SQL Server 6.x database dumps (backups) cannot be...

Can you put an index on the relevant field? That will speed up the MAX() function.

If you are doing MAX(non-indexed-field) I'd EXPECT it to be slow

I haven't been able to try this, but see if it helps.

On the server registration in EM, right-mouse-click and select properties.

Then click on the Network Configuration bar at the bottom....

Sree,

It's actually quite easy, but you won't run the agent jobs as such.

Set up a CMD file to run under controlM. Within that batch file, you can use osql to...

Agree with dbamark - it's much the same reason we use an Enterprise Scheduling system - we can schedule job dependencies, precedents, start times, "can't start after x time", overrun...

I'm just wondering why you think the only way to run a backup is using maintenance plans? What is your DBA doing in their script that suggests it is...

I don't recall where I found this, but I think it will do what you need:

sp_grantlogin 'NT AUTHORITY\SYSTEM'

go

sp_addsrvrolemember N'NT AUTHORITY\SYSTEM' , 'sysadmin'

go