Viewing 15 posts - 36,376 through 36,390 (of 49,552 total)
I didn't ask about full backups. I asked about log backups.
Have you yet read the article that's been recommended several times?
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
October 9, 2009 at 12:18 am
rambilla4 (10/8/2009)
Change page verification to CheckSum (from Torn page)
why this step required?
A database upgraded from SQL 2000 will have page-verification set to Torn Page. SQL 2005 introduced the Checksum...
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
October 9, 2009 at 12:12 am
Add integrity checks for the system databases. Finding that master is corrupt and there's no clean backup (because it's been corrupt so long that the last good backup was 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
October 9, 2009 at 12:11 am
guptaajay1985 (10/8/2009)
I only want to shrink my log files without deleting.....
Why? The log should not be regularly shrunk. It should be set to the size it needs to be for...
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
October 8, 2009 at 11:58 pm
Something tells me this is not the documented behaviour. I call bug.
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
October 8, 2009 at 2:59 pm
Roy Ernest (10/8/2009)
Gail, that is a politically correct way to confront the DBA... 🙂 My hats off to you. 😀
I used to be a developer remember. A developer that knew...
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
October 8, 2009 at 2:56 pm
SELECT @XML = '<outer>
<inner>
value
</inner>
</outer>'
SELECT @XML = '<outer><inner>value</inner></outer>'
Edit: It's the presence/absence of line breaks. If there's a linebreak anywhere in the code block, the < and > come out correct. 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
October 8, 2009 at 2:44 pm
stricknyn (10/8/2009)
Very interesting. Now I have to figure out a way to tell the DBA he's wrong without stepping on his toes...
"Sorry to bother you, I just noticed this...
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
October 8, 2009 at 2:42 pm
This makes no sense. Why did your XML come out fine when I posted it, but nothing else I post gets the < and > correct?
select @XML = '<root>
<column_name>
<node_a>value1</node_a>
<node_b>value2</node_b>
</column_name>
</root>';
select @XML...
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
October 8, 2009 at 2:33 pm
Took your code, copied into management studio. Ran it (just to see what it did. XML is not my friend)
Copy paste back here.
declare @XML XML;
select @XML = '<root>
<column_name>
<node_a>value1</node_a>
<node_b>value2</node_b>
</column_name>
</root>';
select x.y.value('local-name(.)', 'VARCHAR(50)'),
x.y.value('.',...
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
October 8, 2009 at 2:26 pm
GSquared (10/8/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
October 8, 2009 at 2:22 pm
A checkDB on the database dbdata returned no error messages?
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
October 8, 2009 at 2:17 pm
Nope. A restore will always restore the data and log files and will restore them to the same sizes they were at the time of backup. You can elect not...
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
October 8, 2009 at 2:03 pm
Krasavita (10/8/2009)
Should run under master
Anywhere. You're specifying the name of the database in the command. It can run from any database, doesn't matter.
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
October 8, 2009 at 1:59 pm
Hmmm...
SELECT Something FROM SomeWhere WHERE Col1 <> Col2
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Forums definitely don't like me. :crying:
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
October 8, 2009 at 1:52 pm
Viewing 15 posts - 36,376 through 36,390 (of 49,552 total)