You can store the data files in different disks. This will also help to backup and restore the information faster because you do not need to restore the entire database but only the files or the ...

This came up today and I didn't know exactly how to properly do it.The situation: We were to move a database from a MS SQL 2000 server into our in house MS SQL server and run the restore to ...