Viewing 15 posts - 39,061 through 39,075 (of 49,552 total)
GSquared (5/15/2009)
I liked the one where they thought they had backups, but actually the most recent was four days old.
I liked the one where they thought they had backups, deleted...
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
May 16, 2009 at 2:51 am
nilmov (5/15/2009)
i would suggest lets run a command likewhile(1=1)
select * from master.dbo.sysprocesses
wait for delay 00:00:15
Or run profiler that will capture everything that runs on the system while the 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
May 16, 2009 at 2:49 am
Are those procs? If so, script them, drop them and then recreate them.
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
May 15, 2009 at 4:06 pm
Florian Reischl (5/15/2009)
GilaMonster (5/15/2009)
... Is it open season on corruptions all of a sudden? None have any backups, of course....Not yet in our company.
Nor among any of my paying clients.
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
May 15, 2009 at 4:00 pm
Tom Brown (5/15/2009)
http://maps.google.com/maps?ie=UTF8&ll=52.43613,-1.798496&spn=0.044948,0.066948&t=k&z=14
I was born not far from there.
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
May 15, 2009 at 3:58 pm
Back to the subject of questions...
There must have been 8-10 questions on database corruption in the last week or two. Is it open season on corruptions all of a sudden?...
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
May 15, 2009 at 3:52 pm
Ok, in that case you have to let the checkDB finish. There is no manual steps that you can take, you're already doing them.
See the link that I posted...
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
May 15, 2009 at 3:38 pm
Use the object_name function.
So, to get all the objects involved, you would run this
SELECT Object_Name(16823222)
SELECT Object_Name(16055143)
SELECT Object_Name(32823279)
SELECT Object_Name(48823336)
The reason you weren't getting these on SQL 2000 is that CheckDB there...
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
May 15, 2009 at 3:35 pm
If that operation succeeded, there is a full backup somewhere. If there was no backup at all, the log backup would have failed with an error like "No current 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
May 15, 2009 at 3:21 pm
Roy Ernest (5/15/2009)
That would not be in the transaction log, would it?
Contrary to popular belief, TRUNCATE TABLE is a logged operation. It's minimally logged (page deallocations), but it is...
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
May 15, 2009 at 1:55 pm
splatt (5/15/2009)
So, should I stop the checkdb and try a manual fix? If so, which one?
Do you by any chance have the last full backup that was made? If 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
May 15, 2009 at 1:53 pm
Steve Jones - Editor (5/15/2009)
Well I showed Gail last year, but here I am
That shows exactly the same location as the one Wayne posted.
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
May 15, 2009 at 1:48 pm
Luke L (5/15/2009)
Nope I was referring to the link Tom Brown posted. It seemed like he was trying to post a location and ended up putting that in instead...
:-D...
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
May 15, 2009 at 1:28 pm
Roy Ernest (5/15/2009)
By any chance the Application is Purging Data using Truncate table command?
Why are you asking?
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
May 15, 2009 at 1:18 pm
An integrity check will not truncate the log. Check and make sure there's no custom script, no step added to the job.
I would suggest that you run profiler (or 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
May 15, 2009 at 1:17 pm
Viewing 15 posts - 39,061 through 39,075 (of 49,552 total)