Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonnysingh
Starting Member
42 Posts |
 Posted - 2005-08-09 : 08:52:09
|
| Hi AllI have situation where I need to optimize disks space in order to install database. Space should be include for regular database backup and log file..assume that database and backup (log file) on the same disk.. There could be more than 1 disk on the server and we need to analyse all the disks available on the serverHow and what method i should be take to optimize it??? Please helpregardsSqlIndia |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-09 : 10:59:40
|
| Database and their backups should never be on the same disk. What happens when that disk fails? You totally los your ability to recover your database. Please go to Start-->Programs-->Microsoft SQL Server-->Administering SQL Server--> BAcking up and Restoring Databases and read everything there.====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
|
|
|
Optimizing disk space for install Database