April 10, 2003 at 8:28 am
I don't have time to write triggers, or anything. I need to quickly find out if a database has been update since Monday. Does anyone know of a way to do that?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
April 10, 2003 at 8:39 am
If you back up your log-files, maybe you can have a look at the size of the files.
I back up log files each hour. If nothing happens to the db these files are about 15 kb. So when they are bigger, something must have happened and you should have a close look at the db
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 10, 2003 at 8:41 am
That seems like one possible approach. Does anyone know of any others?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
April 10, 2003 at 8:53 am
You can try with Log Explorer (www.lumigent.com).
There is a free trial available on the web site.
HTH
Franco
Franco
April 10, 2003 at 9:28 am
How easy is it to use?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
April 10, 2003 at 9:31 am
Very easy to use it.Just install it on your server, server and client component, attach to the t-logs and begin to investigate.
Really great product, we buy it and we use it for about 2 years.
Franco
Franco
April 11, 2003 at 3:26 am
April 14, 2003 at 2:48 pm
*.trn sizes are good indicator. If you need to regularly do these checks, might be an idea to add a date col to the tables and have the insert/update statements populate them with the current date/time. A simple query using the date will give you the results.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply