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 |
|
fasttrack
Starting Member
12 Posts |
 Posted - 2007-12-30 : 10:07:16
|
| Hello,I have been working as a SQL Server 2000/2005 db administrator (small-medium dbs), in the near future I am going to work as a DBA for large DB on SQL Server 2005 (200 - 300 GB and over) but I have not experences.Do you have any suggestions, Recommendations or useful docs, books or web links and everything else to suggest me on how to administer large databases.Thank a lot |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-30 : 13:14:19
|
| Is the database OLTP or OLAP?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-30 : 15:32:24
|
| Backup strategy maybe different from small db. |
|
|
|
fasttrack
Starting Member
12 Posts |
Posted - 2007-12-30 : 17:42:10
|
| Hello,yes I forgot ....at the moment it is an OLTP, but Data Warehouse (and later OLAOP) come soon....so both.About backup/restore...what do you suggest?Any other potential problem is welcome.Thank |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-30 : 18:50:02
|
| For backup/restore, I suggest purchasing third party software such as SQL Litespeed. We use it for all of our production databases. It reduces file size by 75% and you also get huge backup time savings. For OLTP databases, I'd suggest getting up to speed on partitioned views and also federated servers. Myspace.com runs on SQL Server 2005 and uses partitioned views across federated servers according to an article I read about a year ago.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Administering large databases