Dang, How did I know that "Depends" was coming. The main reason to store on SQL is so our clients can do some data mining looking for key phases....

For Clustering you must use a SAN as DAS will not work because the drives need to be shared. Your Q: Drive is way to large. It only...

Do the Following:

-- Get the FileNames in the backup

RESTORE FILELISTONLY FROM DISK='H:\BACKUPDir\YourDataBase_20060720.Bak'

I am assuming that your databases are in FULL recovery mode.  If they are in SIMPLE recovery mode than you can not do a tlog backup, that is why you...

The easiest way to do this is to create a new "Data Maintenance Plan" under the Management tab in EM. 

Select the User databases,...

One of the biggest factors in using DRI is the nice dataflow diagrams and relationship diagrams one can give to new developers or for that matter to help in the...

This is also wrong in that since the database is already created and one can assume that there are tables in the database, altering the database will only change the...