December 23, 2010 at 8:10 am
I am facing major issue on one of my sql db which contain 311 Tables and some of the table zie is like 400 GB some are 300 and 250 GB etc and on daily basis users are inserting records and space is getting a major concern. SQL db is growing and now it is 1.1 Terabyte.
Anyhelp what should I do or any suggestion?
Thx,
Nita
December 23, 2010 at 9:04 am
... buy more disk?
No, seriously, what is your concern exactly?
You may take a look at Paul Randal's VLDB maintenance checklist to get started.
-- Gianluca Sartori
December 23, 2010 at 9:26 am
Nita Reddy (12/23/2010)
I am facing major issue on one of my sql db which contain 311 Tables and some of the table zie is like 400 GB some are 300 and 250 GB etc and on daily basis users are inserting records and space is getting a major concern. SQL db is growing and now it is 1.1 Terabyte.Anyhelp what should I do or any suggestion?
Thx,
Nita
Hi
Every Database must be Capacity Planned so i guess your DB must have done with Capacity Planning , have a Look on the documents on it.
Your Database size is around 1.1 TB and it is growing daily so u need to have backup (Translog--Every 30 min ,Diff--Every day ,Full--Weekly) on regular basis. If any unwanted data is not needed u can delete or move to archive DB
Thanks
Parthi
Thanks
Parthi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply