Viewing 15 posts - 40,336 through 40,350 (of 49,571 total)
Bob Hovious (3/17/2009)
March 17, 2009 at 8:09 am
eashoori (3/17/2009)
So we are OK with the flush even if auto close is set to false?
Sorry, not sure what you're asking here. Can you rephrase please?
March 17, 2009 at 8:05 am
A database restore will always flush the cache. No way to stop it from doing so.
March 17, 2009 at 7:56 am
Bob Hovious (3/17/2009)
March 17, 2009 at 7:23 am
Colin Betteley (3/17/2009)
The Transaction numbers make sense, but the full Back Up numbers do not seem to be linked.
Because they aren't. Log backups form a chain, the LSN that one...
March 17, 2009 at 7:19 am
t.walker (3/17/2009)
I'm afraid I'm with Adi Cohn, it's much more complex than your reply suggests.
Indeed. 50% fill factor is, in general, a very poor idea. It means that pages start...
March 17, 2009 at 7:12 am
srimkumarp (3/16/2009)
March 17, 2009 at 3:18 am
raj acharya (3/17/2009)
sory i should use word inactive instead of uncommited...
Indeed, because they have a completely different meaning
but if you are telling that it's not see whatever in log file...
March 17, 2009 at 3:10 am
From the entries in the log it looks like you should be able to restore the database backup with norecovery and then the two log backups, in sequence, also both...
March 17, 2009 at 2:28 am
Rohit Chitre (3/17/2009)
How to check whether replication is messing up with the log?
Replication cannot mess up Database and log backups.
Can you check the recovery model? Can you check in the...
March 17, 2009 at 1:17 am
Sounds like you're missing a log backup. Does the job that does the full also do a log backup? It's something I've seen a couple times recently.
March 17, 2009 at 1:11 am
crfenix (3/16/2009)
According the message the query it's too expensive, that's why I'm wondering if there any other (cheaper) way to rebuil the index.
Not really. You could use REORGANISE instead of...
March 17, 2009 at 1:10 am
Bob Hovious (3/16/2009)
Gail, do you have any recommendations from your part of the world?
If you're into wines, you absolutely must not miss the Stellenbosch wines (Cape Town, South Africa). They've...
March 17, 2009 at 1:06 am
raj acharya (3/17/2009)
whatever i know is that when you shrink log file it will remove all uncommited transaction from transactional log file ....
Absolutely not.
Shrink just releases unused space to the...
March 17, 2009 at 1:04 am
SQL Reddy (3/16/2009)
Since you have performed a log backup,you'll have free space in the log file.Now shrink it.You'll get space released to the disk.
Yup. However if you have not resolved...
March 17, 2009 at 1:02 am
Viewing 15 posts - 40,336 through 40,350 (of 49,571 total)