Viewing 15 posts - 40,351 through 40,365 (of 49,552 total)
murthykalyani (3/14/2009)
I didn't run dbcc checkdb instead I ran DBCC checktable with options mentioned by you and gave this error
Please run a full checkDB. I want to make sure that...
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 15, 2009 at 2:08 am
JacekO (3/13/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 15, 2009 at 2:02 am
Disclaimer: Do not do this to a production database. Do not do this to any database that you care about.
Right, now that's out of the way.
Detach the database, open 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 14, 2009 at 9:29 am
GSquared (3/13/2009)
GilaMonster (3/13/2009)
Am I being too harsh here?
Nope.
I've been caught with errors like that before, and you've called me out the same sort of way. I've never taken it...
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 14, 2009 at 3:49 am
ohernandez (3/13/2009)
It exists other option to do it without this problem.
BACKUP LOG TO DISK = ....
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 14, 2009 at 3:34 am
Please run a full checkDB and post the results here
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
The 'invalid encryption key' confuses me. Are...
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 14, 2009 at 3:34 am
Lynn Pettis (3/13/2009)
Anyone else care to join the fray??
Sorry, no. I've 'engaged' that one before and the threads never end without insults getting thrown around. He takes criticism and correction...
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 14, 2009 at 3:17 am
zbakhramov (3/13/2009)
We have a windows server 2003 with sql server 2000 running in the vmware ESX server and SAN.
Disk queue length is a near-impossible to interpret properly on a SAN....
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 13, 2009 at 1:17 pm
Do you have an appropriate index?
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 13, 2009 at 9:43 am
kwilthew (3/13/2009)
The tape backup only picks up the backup files.
In that case, your admin shouldn't be complaining about wasted space. SQL's backups only contain the used space so...
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 13, 2009 at 9:20 am
Am I being too harsh here?
http://www.sqlservercentral.com/Forums/FindPost675279.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
March 13, 2009 at 9:04 am
Dugi (3/13/2009)
WHEN CHARINDEX('-',ClientID) <> 0 THEN
(CASE WHEN ISNUMERIC(SUBSTRING(ClientID,CHARINDEX('-',ClientID) + 1, 5)) = 1
THEN...
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 13, 2009 at 9:01 am
kwilthew (3/13/2009)
If you're referring to the tape backups, those are...
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 13, 2009 at 8:57 am
On the SQL 2000 database, please run the following and post the full output
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
DBCC CHECKCATALOG (< Database Name > ) WITH...
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 13, 2009 at 8:52 am
CASE has two syntaxes
CASE < column or variable > WHEN < value > THEN ...
or
CASE WHEN < Boolean expression > THEN ....
They are not mixable. Change it to
CASE WHEN CHARINDEX('-',ClientID)...
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 13, 2009 at 8:48 am
Viewing 15 posts - 40,351 through 40,365 (of 49,552 total)