Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script Generates Audit Triggers Expand / Collapse
Author
Message
Posted Saturday, May 10, 2008 12:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:57 PM
Points: 21, Visits: 125
Comments posted to this topic are about the item Script Generates Audit Triggers
Post #498392
Posted Thursday, June 12, 2008 4:25 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
Article is good, only thing is caution must be exercised when deleteing DB's. I usually take them offline for a while first and see if anyone complains, even if everyone is sure it's not used and there is no activity.

I've used profiler to monitor DB's for that same purpose, let it run for a while filtered by DB. That way if the DB is being used for reads you'll catch that too.

Mark
Post #515761
Posted Thursday, July 17, 2008 6:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 14, 2009 4:05 AM
Points: 2,320, Visits: 31
I agree with Mr or Mrs 500....I am currently in the process of upgrading 2 of my SQL Server 2000 to 2005 and do now which to move over obsolete databases onto the new environment. Therefore I've put all the databases which I think are not in use into Single User mode and I have been awaiting for someone to scream...3 weeks now no one is screaming. I will wait for a further 2 - 3 months and then archive those databases in Single user mode....simple but effective......and other views are welcome of course.
Post #535890
Posted Thursday, July 17, 2008 7:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:57 PM
Points: 21, Visits: 125
Before I actually delete the database files, I detach them for a few weeks and then save the files to a backup location before deleting the database files.

The triggers help to determine if the database is being used or not,
but you are right, care must be taken before actually deleting the database files.

Post #535991
Posted Wednesday, November 23, 2011 10:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 29, 2013 5:29 PM
Points: 11, Visits: 577
Interesting, does this script affect performance much?
Post #1211226
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse