Viewing 15 posts - 29,461 through 29,475 (of 49,552 total)
paul.knibbs (11/9/2010)
and make sure you have regular backups so they don't keep growing out of control.
Log backups are not necessary (and won't run) in simple recovery, which George indicated his...
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
November 9, 2010 at 5:07 am
Have you done anything silly with the transaction log recently? (switching files around or similar?)
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
November 9, 2010 at 4:32 am
muthukkumaran (11/9/2010)
Another one method -->Check the Schema change histroy.
That report queries the default trace
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
November 9, 2010 at 4:31 am
DBCC UPDATEUSAGE
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
November 9, 2010 at 3:05 am
Is there a DBA there that you can speak with? Recovering a suspect database is not something for a novice.
Management studio. Object explorer. Management -> SQL Server logs
Without seeing what's...
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
November 9, 2010 at 2:40 am
paul.knibbs (11/9/2010)
He didn't use TRUNCATE_ONLY as part of a BACKUP command, he used it in a DBCC SHRINKFILE--I can't find any mention that using it in that way is deprecated.
It's...
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
November 9, 2010 at 1:51 am
Joshua T. Lewis-378876 (11/9/2010)
Just as an FYI, Microsoft has depreciated the TRUNCATE_ONLY option in SQL 2008, and you have to use a different option in the BACKUP LOG command:
BACKUP LOG...
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
November 9, 2010 at 1:50 am
What jobs run between that 12:30 log backup and the previous log 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
November 9, 2010 at 1:42 am
First things first. Do not, for any reason, no matter what anyone else tells you, detach that database. You will not be able to reattach it.
To offer any useful advice...
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
November 9, 2010 at 1:40 am
Unlikely to be the result of the full backup. My guess, between 12.30 and the log backup before it you're doing something like an index rebuild over all indexes.
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
November 9, 2010 at 1:14 am
WayneS (11/8/2010)
Forget the online text editor... put it into a word document. Steve will convert it.
Yeah, it's only the uninitiated (and those have far too much spare time) who use...
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
November 9, 2010 at 12:32 am
gmamata7 (11/8/2010)
We are analyzing Blocking and MS recommended to enable Verbose logging and I did NOT find any option for that?
Ask whoever recommended it what he's talking about and where...
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
November 8, 2010 at 2:30 pm
What do you mean by 'verbose logging' Logging of what to where?
SQL itself has no logging levels. Most of the replication agents do, but I can't think of much else.
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
November 8, 2010 at 2:16 pm
Craig Farrell (11/8/2010)
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
November 8, 2010 at 1:33 pm
goodguy (11/8/2010)
I believe that programmers, especially freelancers like me, need to embrace basic sql admin skills in order to leverage their output.
Admin, no mostly not (unless they're in a...
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
November 8, 2010 at 1:15 pm
Viewing 15 posts - 29,461 through 29,475 (of 49,552 total)