Most training companies are teaching SSIS now and most of those teach the Microsoft developed courses e.g. http://www.microsoft.com/learning/syllabi/en-us/2795BFinal.mspx

Greg

This caught my eye: BACKUP LOG cannot be performed because there is no current database backup.

Did a full backup fail earlier? 

Greg

None of the fixed database roles you mention grant EXECUTE permissions.

A user who is only going to execute stored procedures and the user defined functions in them only needs to...

I don't like that it can't scan DTS packages that are password protected and doesn't offer the opportunity to enter the password.  We save all of our production packages with...

Attaching the database files will upgrade but you'll still have to change the database compatability level afterward using sp_dbcmptlevel. 

You'll still want to use least privileged service accounts to install. ...

Sorry, Nate.  I can't read the entire title of your post.  Would you put some more detail in the body of your post?

Thanks,

Greg

I think both methods are safe.  The difference is that a detached database can have it's files moved to another SQL Server instance while an offline database cannot.  I've used both...

The login that SQL Server Agent runs as (look at properties for SQL Server Agent) needs to be a domain account that has access to the remote server. 

When a...

Pavan,

I'd script the jobs and run the script on the secondary server.  You can script jobs by expanding SQL Server Agent in SSMS, click on Jobs, highlight the jobs you want to script,...

Penny & Ben,

That's true if the job is created by choosing 'schedule package...' in Enterprise Manager, but not if the job was created independantly and the job step created manually. ...

Try this to decrypt the DTSRUN command:

To decrypt a DTSRUN command as used in a job step, copy the command to a cmd prompt, append /!X /!C to the end,...

Penny,

To decrypt a DTSRUN command as used in a job step, copy the command to a cmd prompt, append /!X /!C to the end, and run it.

The !X argument blocks...

Jobs run as SQL Server Agent.  That's the login that needs permissions for each server.

Greg

Was that after installing SQL 2005?  If so, then they were upgraded during the installation.  By doing that, you have no recourse if you want to go back to SQL 2000.

Greg

Please see my previous post.  You can transfer only data.  You just have to work within the limitations of the foreign key constraints.  Look up "foreign keys" in BooksOnLine for more...