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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-07-06 : 14:35:59
|
| 1. i have DB 25 G, when i back up i get 3 G (i dont compress it)v so i make a test, i restore the 3 G and get new DB with 25 G is it sense??2. what do you make to know if someone truncate or drop DB/Table etc.? (i think of trigger, but i need to put it in each DB?)3.how can i get a message by sql when my cpu is in 100% over 3 minutes?? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-06 : 14:53:11
|
1. How much space is taken by the data in the data file? Do you have 22 GB free space?2. You can make a database trigger3. Create an alert.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-07-07 : 08:10:49
|
| 2.what do you mean "You can make a database trigger"(did i need create a new database and call it like system databse to other name)?3.what do you mean ,and how i make alert? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-07-07 : 09:12:11
|
| 2. Look up DDL triggers in Books Online3. Look up SQL Server Agent in Books Online. There should be entries on creating alerts there.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
3 questions