You can move all your system databases in a single SQL session. 

1) Stop SQL Server.

2) Start SQL with a NET START /T3608 command.

3) Run the ALTER statements to re-configure...

One thing to factor into your tests...  An update of 50,000 rows may take place entirely in the buffer pool.  An update of 100,000 rows may require some updates to...

Happycat59's answer is a good one.  Remember when you move to SQL 2005 that the format of Agent Tokens changes.  The SQL 2005 BOL has the details, and also look...

If you have no systems already using SQL 2005, then I reccommend you go to SQL 2005 SP2 + Hotfix rollup.  Do your QA on that and resolve any issues...

Lynn is giving very good advice about transaction log backups, recovery mode, etc.

You also said you had the databases set to 'auto shrink'.  This is bad.  You should never shrink...

I completely agree with Joe's advice.  If you do not have good in-house skills in choosing SANs, big servers, etc, then you WILL waste lots of time and money trying...

We recently had a departmental training day, with one particular exercise showing how damaging micro-management can be.

We were split into teams, with each team nominating...

That is right.

The SQL 2005 install media comes on 2 CDs.  CD1 contains the server components, CD2 contains only the client components.  If you have DVD media, you will find the components...

We have trialled running DTS on a 64-bit SQL 2005 machine.  The only problem I found is that some custom DTS components that need to be in \system32 on 32-bit...

Is this the first time you have tried to start SQL after moving the system databases or changing the service account?  Can you log on using the service account and...

If you run SQL Server using a domain service account, try asking for mail capability to be added to that account.  As everything is not totally new, this may be...

When all is said and done, you have hit a limit on what SQL Server can do. 

We had a similar problem with our data warehouse.  We had to examine...

Very good editorial!  We all need to look out for the safety of each other, otherwise no-one is safe.  I would rather be embarrassed by asking someone if they are...

Running SETUP via a command line or via the GUI does exactly the same thing.  The only reason to run via a command line is you prefer to do it...