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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-05 : 23:41:31
|
| sql writes "HiI would like to know how much of space is required for a database to hold 50 million records and how much of space will the hard disk take up if each record is of around 200 bytes.Please let me know as i have a project going on and i have to submit my answer ASAP.According to analysisThe no of records multiplied by the no of record size will give you the total no size its going to take." |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-02-05 : 23:48:27
|
| Free space on page, fragmentation, indexes, ...Backups to local disk, tr log size, space for another copy of database for restores?No point in trying to be too accurate.At least double the space the data will take - that'll probably give you less space than the smallest disk you can get.A lot depends on what type of system it is.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Sql db and hard disk