You DO NOT want to grow on demand. You want to set a size that will be used over the next 3-6 months, as Tom mentioned. Do it during periods...

How are you adding to the DB? I don't see any place in there where you need to shut down the db file. You should be inserting into the database...

Unless the log is directly after the backup, you can't.

The way this works is (over time):

full backup 1

- log 1

- log 2

full backup 2

- log 3

- log 4

If you have...

How are the copies made as well?

sp_help_revlogin, script out logins, add them back.

Might need to script roles out on the server level, not sure where that's kept in 2005 and how easy it is to pull...

What's stable enough?

Haven't seen any news about issues with it. I know that SS2K might not be supported on W2K8, they tend to support only 2 versions backwards (the Windows...

This wasn't database mirrroring was it? I believe replication and mirroring, while similar, function differently.

Truncate not being tracked in DDL triggers is a problem. I hope this is fixed in...

I think Jack has the only good way to do this in 2000.

sp_changeobjectowner

you would not update system tables.

The DTS package will run under the credentials of SQL Agent as a job. You need to be sure that this account has rights to the database.

I think you might...

http://msdn.microsoft.com/en-us/library/ms188783.aspx

CREATE INDEX has a row and page level locking option. Someone created the index with it set to OFF.

Tools | Options | Results | SQL SErver | Results to Grid, there's a checkbox for results in a separate tab.

I love the argument a backup is needed?

I think your instructors are perhaps lacking some understanding of how SQL Server should be run.

I've done something similar to Jason in the past. having standard drive letters makes a huge difference since everyone knows backups are on "z"

Be sure that your arrays are physically...

If you detach it every time, you'll need to attach it again. It won't be in your list of databases.

What are you trying to do here? Meaning what's your process...