Very good discription of files and filegroups Adrian. Often multiple files and filegroups are used to gain maximum performance from hardware and SQL server.

Wes

from article 224071

_________________________________________

NOTE: You will not be able to access any user databases at this time. You should not perform any operations other than the steps below while using this...

have you moved the model logs back to their original location and try a restart? Did you detatch the model database before moving the files? I'm not even sure you...

I assume you have a connection of some sort to actually run a tsql step or a data transform. I would check to see if that connection has (local) in...

Thats a fact call Microsoft. I would run the dbcc checkdb with the repair_fast that is a non distructive repair and should not cause data loss. Any time you have...

Collation will be what the collation of the database is if you restore or detatch and reattach collation shouldn't change.

Wes

The most bullet proof way is to restore the databases. If you can though. I would detatch your user databases from the current system copy the files over to the...

Hrum, memory usage per database is a task that may not be obtainable. SQL brings pages in and out of memory as needed and doesn't generally allocate any fixed memory...

Don't shrink! Shrinking before the bulk insert causes two things, One your DB has to grow back out again to handle the new data, Two disk fragmentation of the datafiles...

I've had problems with Symantec in the past and have since moved to mcafee corp addition with the same exclusions. I have yet to have a crash that I can...

Or, you may need to spread your backups across diffrent times i.e. backup the largest db's alone on a diffrent maint plan and schedule that an hour or two away...

On a side note... One thing you may want to do is make sure you have some type of index rebuild or defrag scheduled as regular maint on the db....

Sql Server 2000 Performance Tuning Technical Reference is a good start on how to size your hardware to support the speed you are trying to attain. HP did several test...

Check a couple of things. One the account that sql server and the agent are set two run under have enough permissions to start i.e. usually a domain acount with...

I have used in the past uptime and availability excluding and documented down times or tasks that cause databases or data to be unavailable like index rebuilds. Anything else more...