I moved a database from one server to another. After doing so, someone told
me that the data files need to be moved to a secondary disk. I'm needing to
know how to change SQL Server so that all of it's database files are located
somewhere besides the default location. How do I do this?
I went through the BOL, so don't tell me to look it up there. Couldn't find
this information. If you do refer to the BOL, please give me the steps to
find that information. I tried the index and that didn't work.

The easiest way is to detach the db, move the files and attach it again.
These should help:


[url down] Moving DBs
[url down] Moving
system DB's
[url down] Moving DB's between Servers
[url down] Moving SQL Server Databases
to a New Location with Detach/Attach
[url down] Using WITH MOVE in a Restore
[url down]
Moving Users
[url down] How To Transfer Logins and
Passwords Between SQL Servers
[url down] Mapping Logins & SIDs after
a Restore
[url down] Utility to map logins to
users
[url down] User Logon and/or Permission
Errors After Restoring Dump
[url down] How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
[url down]
Restoring a .mdf
[url down] Disaster Recovery Articles
for SQL Server
[url down] Moving a Diagram
[url down] Copy DB Wizard issues 2000