Something you can consider for larger databases is the use of raw partitions.  Raw partitions are probably easier to manage within a SAN environment than with DAS. 

Using raw partitions would...

If both your data files are in the same filegroup, then any database object created in that file group may have extents in both files.  Even if you find which...

If you are concerned with row order when retrieving data you must use the ORDER BY clause in the SELECT statement.  The ANSI standard says that without the ORDER BY...

I did this and recovered from it. 

If anyone else is thinking of moving Model and MSBD, one important thing is to detach and attach the databases one at a...

Defragmenting at the logical level is always useful (e.g. rebuild indexes), but fragmentation at the physical level can also be important.

Due to the underlying dynamics of disk head movement, any...

I should have said 'before writing to the data file it will write ... to the transaction log'.

SQL Server will write updated pages to the data files before the transaction...

It may be worth checking th efollowing registry entry to see if it is pointing to your A: drive.  (This is unlikely to happen, but could give the same results)

Does Outlook need to be opened on your other servers.  Did this server ever send mail without Outlook opened.

If you look at forum archives you will find a lot of...

Have you looked in the Maintenance Plan report file.  This gives far more diagnostic information than found in the Job History display.

Also, have you tried manually copying a file that...

You can create Maintenance Plans for MSDE instances using Enterprise Manager, providing you have done some groundwork.

If you have MSDE 2.0 (SQL2K) installed, it helps a lot to be on...

Most defrag tools will not touch files that are in use.  This means that if SQL Server is running, no database files will get defragmented.  You will need to stop SQL...

You are looking at about 185GB just for this table.  It is worth reviewing all your space estimates to get bot ha worst-case and a realistic estimate of space required.  If...

Two points...

1) You need to be aware of the internal structure of the transaction log, and what happens when you do a backup and when you do a shrink.

See 'Shrinking...

MSDE 2000 with SP3a will by default remove all server connectivity.  Log on to the box and run the Server Network Utility to enable your favourite protocol.  Then stop/start MSDE...