Viewing 8 posts - 121 through 128 (of 128 total)
SkyBox (9/19/2010)
GilaMonster (9/19/2010)
May I suggest that you take a minute to look in books online for the sys.databases view to familiarise yourself with it before continuing.
Absolutely - thank you
GilaMonster,
The log_reuse_wait_desc...
September 19, 2010 at 5:37 pm
GilaMonster (9/19/2010)
May I suggest that you take a minute to look in books online for the sys.databases view to familiarise yourself with it before continuing.
Absolutely - thank you
September 19, 2010 at 12:10 pm
What's the value for this database? (The one that you did the LogInfo for)[/quote]
This is the statement I am executing:
use dataBase (same db s LogInfo)
select log_reuse_wait_desc from sys.databases
September 19, 2010 at 12:01 pm
GilaMonster (9/19/2010)
SkyBox (9/19/2010)
GilaMonster (9/19/2010)
Looks like something's keeping the log active.What's the value of log_reuse_wait_desc in sys.databases for this database?
log_reuse_wait_desc
DATABASE_SNAPSHOT_CREATION
NOTHING
LOG_BACKUP
DATABASE_SNAPSHOT_CREATION
NOTHING
LOG_BACKUP
LOG_BACKUP
What's the value for this database? (The one that you did the...
September 19, 2010 at 11:58 am
GilaMonster (9/19/2010)
SkyBox (9/19/2010)
September 19, 2010 at 11:53 am
GilaMonster (9/19/2010)
Looks like something's keeping the log active.What's the value of log_reuse_wait_desc in sys.databases for this database?
log_reuse_wait_desc
DATABASE_SNAPSHOT_CREATION
NOTHING
LOG_BACKUP
DATABASE_SNAPSHOT_CREATION
NOTHING
LOG_BACKUP
LOG_BACKUP
September 19, 2010 at 11:45 am
GilaMonster (9/19/2010)
SkyBox (9/19/2010)
September 19, 2010 at 11:39 am
Perry Whittle (9/19/2010)
what does the following return when executed against the database in question
DBCC LOGINFO
Hint: scroll down the results and check for a status of 2 near the end of...
September 19, 2010 at 11:36 am
Viewing 8 posts - 121 through 128 (of 128 total)