Viewing 15 posts - 16,711 through 16,725 (of 49,552 total)
You have main two choices
- Restore the backup and lose all data since the backup was taken
- run repair and lose data. How much I can't tell (would really like...
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
September 10, 2012 at 1:15 pm
Not from before the errors, from before the corruption. When was your last good checkDB?
Assuming that backup is clean, do you have an unbroken chain of log backups since 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
September 10, 2012 at 11:56 am
TruncateOnly is not a valid shrink option when shrinking the log. It's ignored. It's valid for data files only.
The rest sounds fine, just note that you won't necessarily be able...
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
September 10, 2012 at 11:20 am
What are these:
@listStr
@Years
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
September 10, 2012 at 11:17 am
Probably not, because accessing corrupt portions of the table will result in errors. You can try, but that's usually a lot of hard work to narrow down the portions of...
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
September 10, 2012 at 11:16 am
Brandie Tarvin (9/10/2012)
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
September 10, 2012 at 11:14 am
No. SQL Server is not a file-based database like MS Access. To use a DB, the DB must be attached to a running SQL instance.
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
September 10, 2012 at 11:12 am
Post your code. Somewhere you're converting to VARCHAR(8000) or NVARCHAR(4000). Nvarchar(max) can store up to 2GB of data.
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
September 10, 2012 at 10:33 am
You can't attach a SQL 2000 DB to SQL 2012, you need to first upgrade the DB to SQL 2005 or SQL 2008 (by attaching it to one of those...
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
September 10, 2012 at 10:27 am
In SLQ 2005 and above, you just rebuild the indexes that need rebuilding, order does not matter.
On SQL 2000, if the clustered index was not unique, rebuilding it rebuilt all...
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
September 10, 2012 at 10:24 am
Lynn Pettis (9/10/2012)
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
September 10, 2012 at 10:13 am
jdbrown239 (9/10/2012)
Wouldn't last nights backup have the same corruption? If so I would have to use one from a few days ago.
Depends when the corruption happened. When was your...
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
September 10, 2012 at 10:06 am
Oh, and please note that the blog post you referenced is 90% copy-paste from these two pages:
http://msdn.microsoft.com/en-us/library/ms184286%28v=sql.105%29.aspx
http://support.microsoft.com/kb/323630
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
September 10, 2012 at 10:00 am
Brandie Tarvin (9/10/2012)
Is there a way to use an estimated execution plan to determine what kind of locks will be held on a table?
No. The optimiser knows nothing about locks....
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
September 10, 2012 at 9:49 am
From what you describe, no issues, normal expected behaviour.
Haven't we had several memory-related discussions already on 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
September 10, 2012 at 9:39 am
Viewing 15 posts - 16,711 through 16,725 (of 49,552 total)