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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-07-16 : 11:26:42
|
| Is it possible in SQL2K5, 1. to give a upper limit to DB files and (I know this is possible)2. raise an alert or some notification when 80% (or something similar) of file is filled. ------------------------I think, therefore I am - Rene Descartes |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-07-16 : 11:36:32
|
| 1. yes2. yesCODO ERGO SUM |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-07-16 : 12:21:51
|
| I will look BOL for point 2. Mean while if you have some quick info please let me know. I don't need the code. I just need to know what needs to be done.------------------------I think, therefore I am - Rene Descartes |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-07-16 : 12:39:45
|
| There is "percent log used" property for ALERT, but not "percent data file used".------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:08:31
|
| You may use sp_spaceused to get info you need. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-07-17 : 13:36:11
|
| Let me clarify, I have a db with size 100MB The max size for the DB is 1GB I want an alert when the DB size reaches 800MB------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:46:07
|
| Yes, sp_spaceused tells you db size and used space. |
|
|
|
|
|
|
DB size upper limit.