Viewing 15 posts - 42,706 through 42,720 (of 49,552 total)
hemanth.damecharla (12/1/2008)
And, I should have mentioned this earlier; the corruption happened while doing a database shrink.
Not overly likely. More likely the shrink picked up corruption that was already there.
When...
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
December 2, 2008 at 1:16 am
What's the max size required by your tran log through the day?
How often are the log backups?
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
December 2, 2008 at 12:55 am
rnunez (12/1/2008)
Heres all the information from Help..aboutMicrosoft SQL Server Management Studio9.00.1399.00
That's RTM. You've got 2005 SP2 on the server and 2005 RTM on the client. I would suggest you run...
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
December 1, 2008 at 1:56 pm
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic611653-338-1.aspx
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
December 1, 2008 at 1:49 pm
When you can, run a full checkDB with no_infomsgs, all_errormsgs and see if it gives any errors back.
What build/patch level for 2005?
Do you have page checksums on for that DB?
If...
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
December 1, 2008 at 1:41 pm
Steve Jones - Editor (12/1/2008)
I'd go look at what's offered by SQL Skills, Solid Quality mentors, Scalability Experts and see if something fits.
Agreed. Where in the world are you...
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
December 1, 2008 at 1:35 pm
Chris Morris (12/1/2008)
Where not exists (Select 1
instead of Where not exists (Select *
in Query...
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
December 1, 2008 at 1:19 pm
If you click help - about in management studio, it'll show you the version of the client tools. What version do you have for management studio?
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
December 1, 2008 at 1:03 pm
What version and service pack?
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
December 1, 2008 at 9:34 am
As part of the create snapshot, you need to specify all data files, not just one of them
So, it'll be something like this
CREATE DATABASE AdventureWorks_snap042007 ON
(NAME = AdventureWorks_Data, FILENAME...
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
December 1, 2008 at 9:33 am
In this case (and I tested out in adventureworks) the exists is better because by using that you're telling SQL that it doesn't actually need to get the rows from...
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
December 1, 2008 at 9:26 am
No. When a database is restored it is restored to exactly the same state it was when it was backed up. Including size of files.
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
December 1, 2008 at 9:15 am
When you create a snapshot, you must specify all of the files. The error indicated that you haven't specified all of the files that the DB has (excluding the 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
December 1, 2008 at 9:15 am
Roger Abram (12/1/2008)
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
December 1, 2008 at 9:08 am
daniel.cloutier (12/1/2008)
Thank you Gail and SSCarpal Tunnel,
p.s. that's the person's forum level (affected by no of posts), not the person's user name.
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
December 1, 2008 at 9:06 am
Viewing 15 posts - 42,706 through 42,720 (of 49,552 total)