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 |
|
krishnap
Starting Member
2 Posts |
 Posted - 2009-08-18 : 14:32:12
|
| Hi, We have a database in Access and we are planning to move to SQL Server 2005. Earlier, I have SQL Programing experence, but never done like giving requirements for storage space and backup space requirements.I would like to know how to start the process and calculate the storage space requirement.Please help.ThanksKalp |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 09:27:06
|
| I'll add this: if you have an Access database, that means you are under the 2GB storage limit. When you move to SQL Server, it will be similarly-sized (yes you could get more specific as webfred did but, in general, the databases will be "similarly sized" in my experience). Backup requirements: you aren't using SQL 2008 so you can't take advantage of backup compression. There are three "main" types of backups in SQL Server:1) FULL backup - backup file will be roughly the same size as the database2) DIFFERENTIAL backup - backup file will be the size of the changes that have occurred since the last FULL backup3) LOG backup - backup file will be the size of the changes that have occurred since the last LOG backupWe cannot give you estimations on how much disk space to predict for backups since we don't know (a) what type of database this is [which would help us define how often it should be backed up], nor do we know (b) what sort of data loss is acceptable (i.e. "If you had a crash and lost 15 minutes worth of data but recovered everything else quickly, would that be okay?").If you want a full breakdown of backup types including sizing estimations and so forth, check out these videos:How to Backup a SQL 2005 Database: [url]http://www.learnitfirst.com/Course/152/Chapter/99/SQL-Server-2005-DBA-Disaster-Recovery.aspx[/url]How to Backup a SQL 2008 Database: [url]http://www.learnitfirst.com/Course/157/Chapter/252/SQL-Backup-and-Recovery.aspx[/url]One caveat - these are from LearnItFirst.com's SQL Server DBA courses and they are not free (sorry). They are very thorough and comprehensive though and explain nearly everything you asked about.========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
 |
|
|
|
|
|
|
|
Storage Space Requirements