Viewing 15 posts - 34,156 through 34,170 (of 49,552 total)
Note to self: Once my university stuff's out of the way, write a followup to my "Help my database is corrupt" article, covering the causes and fixes for suspect and...
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
February 8, 2010 at 7:15 am
Possibility 1: Some one deleted/misplaced a data/log file when SQL Server was offline and the database can not start because of missing file. The solution is to place the missing...
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
February 8, 2010 at 7:08 am
Alvin Ramard (2/8/2010)
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
February 8, 2010 at 7:04 am
Krishna Potlakayala (2/8/2010)
It is better and recommended to have atleast one differential backup during the mid-day.
Why?
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
February 8, 2010 at 6:36 am
I don't know what LiveState Recovery is, but if it's a file mirroring app, those generally don't play nice with SQL Server and often the mirrored copies aren't usable.
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
February 8, 2010 at 12:56 am
What kind of backup and disk imaging?
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
February 8, 2010 at 12:07 am
There's no one single way to coy the DB. I'd say anything that gets the data into a new DB is perfectly acceptable.
Have you had a chance to look at...
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
February 7, 2010 at 11:50 pm
The system DB ids are fixed (at least in the current versions of SQL)
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
February 7, 2010 at 11:49 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic861431-17-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
February 7, 2010 at 11:47 pm
Steve Jones - Editor (2/7/2010)
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
February 7, 2010 at 2:12 pm
Steve Jones - Editor (2/7/2010)
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
February 7, 2010 at 1:24 pm
Steve Jones - Editor (2/7/2010)
I'd put Streaminsight in the ugly since it's just in Data Center edition.
It's in the other editions too, though no word of what limitations there'll be...
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
February 7, 2010 at 11:34 am
2008 R2 is predominantly a set of BI focused addons for SQL Server. There are virtually no changes to the database engine (I've counted 3, maybe 4). It's mostly scale...
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
February 7, 2010 at 10:39 am
There's no scale-out options for a single SQL Server database. If you have a datawarehouse (star/snowflake schema) check out "SQL Server 2008 R2 Parallel datawarehouse edition" formerly known as Project...
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
February 7, 2010 at 10:37 am
eslam.amgad (2/7/2010)
Yes, I have to check every column :-D, because all the record may vary in only single column.
So you've actually got no unique column or set of columns 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
February 7, 2010 at 8:18 am
Viewing 15 posts - 34,156 through 34,170 (of 49,552 total)