Viewing 15 posts - 40,321 through 40,335 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 17, 2009 at 7:12 am
srimkumarp (3/16/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 17, 2009 at 1:02 am
Woot! :w00t: Congrats.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2009 at 2:39 pm
Can you explain more about the issues with SSIS and SSRS? I know of some problems with SSIS, hadn't run into any SSRS ones.
I agree with you on the 32...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2009 at 2:39 pm
You can restore either full backup followed by all the logs, in sequence, since that backup. Full backups do not truncate the log.
Backup A
Log backup 1
Log backup 2
Log backup 3
Backup...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2009 at 1:41 pm
callum.bundy (3/16/2009)
PS if its still making huge changes, can I drop the reorganise?
Not a good idea. You should either rebuild or reorganise indexes relatively regularly. If you don't want to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2009 at 1:34 pm
Viewing 15 posts - 40,321 through 40,335 (of 49,552 total)