The Sql server data drive size is about to fill only 10% is left.

Question

The SQL server is in cluster.

The Sql server data drive size is about to fill only 10% is left.

The database tables are around 4500 and the timestamp column is not added in some tables.

What should I recommend to client? for bigger chunk of drive from LUN Storage?

If I get it then how will I proceed?

---

Thanks

Answer 1

What is the problem? DB is growing up and you have no disk space? How does timestamp relate to this? What recovery model does the db have?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

1.2.3. Much space is not reserved in storage.Therefore they are searching for database partition or any other solution of above issue.

4.Full Recovery model

---

Thanks

Answer 3

>>>4.Full Recovery model

Do they perform LOG backups?

Hmmm, how does it relate to db design?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 4

Yes Log backup is scheduled for every 2 hours.

Daily Differential and Weekly Full.

---

Thanks

Answer 5

Hi,

You need to add more drive space or create a new filegroup on a different drive and move some of your tables to the new file group.

You can see sample here on how to move the tables to new file-group 

http://www.sqlservercentral.com/articles/Administration/64275/

Hope this helps

Regards
Satheesh

Answer 6

Pls take this consideration also.

Actually some tables of this cluster is in replication to another cluster also.

---

Thanks

Answer 7

Perhaps you need to talk to the SAN provider about configuration?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/