DTS packages can also be run under a kind of 2000 emulation, 2005 puts a wrapper around them.

There are lots of little changes here and there across the board from...

Actually the MS way to do it is to use database mirroring AND snapshot databases

Mirror you live DB, use snapshots of your mirror for reporting.

I haven't tried it yet, but...

There should be two backups in your plan, one to do a daily full backup and one to periodically backup and copy the trasaction logs.

Can you check that these tasks...

First off you can do 2 node clustering with SQL Server 2005 Standard, which should make your boss happy with the budget.

Secondly, windows 2003 clustering in itself is a topic...

It depends on your preferred plan.

(Assuming a current server on SQL 7 SP4)

Option 1 (Upgrade in place):

Take a full server backup of your existing system.

Install SQL 2005 (overwrinting exisint ginstallation...

"The problem that I am having is that after my log file gets backed up it does not shrink it keeps growing"

Is this the backup part of the logshipping process,...

(Sorry lost the thread for a moment there)

In this case, your job is a maintenance task - work to be otherwise to be carried out by the responsible DBAs that...

Sure, in SQL 2000 objects were owned by the user who created them - in 2005 objects are assigned to the default schema of the user who created them.

This gives...

Could you post the entire error message (it's been truncated), and the update code?

As a random guess based on the 'conversion' part of the error, it may be a collation...

There is no change in the physical file structure of database files between SQL Server 2000 and SQL Server 2005, hence you are able to restore 2000 databases to 2005.

The...

Are you trying this under the same user account used by the ASP?

Do the tables and user all belong to the same schema?

Glad to see you got it working, I'd still encourage you to review how you define ownership on jobs - that looks like a user account, even though we have...

"By your use of the word live, this server is not used for "live reporting". It is being used for the development of reports"

Normally I wouldn't bother much with...

Ah, that's not upgrading! That's migrating!

You can upgrade your SQL 7 Server to SQL 2005, by running the setup and choosing a default...

Do you mean maintenance plans migrated from SQL 2000?