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 |
|
sam123456
Starting Member
3 Posts |
 Posted - 2006-12-06 : 14:52:57
|
| I have the scripts to set up the alert for all the backup that i need. My scripts gives the alerts if there is not full back up or transactional backup within certain period.My alert is giving me ambigious result as some of the database is in the simple recovery mode and there is no tran log backup.I need to modify my scripts that will ignore the database in simple recovery mode.what will be the best way that i can use to have my script ignore simple reocvery mode.any help is appreciatedthanks in advance |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-06 : 15:54:54
|
This will give you the current recovery mode for any databaseselect databasepropertyex('databasename', 'Recovery') |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-07 : 05:05:54
|
| You probably ought to also check:DATABASEPROPERTYEX(@loc_baks_Database, 'Status') IN ('OFFLINE', 'RESTORING', 'RECOVERING', 'SUSPECT')Kristen |
|
|
|
sam123456
Starting Member
3 Posts |
Posted - 2006-12-10 : 14:34:33
|
| Thanks guys |
|
|
|
|
|
|
script to distinguish the recovery model