Viewing 15 posts - 26,926 through 26,940 (of 49,552 total)
R2 is a separate version. It is as separate as SQL 2005 and 2008 are. The two are licensed separately (you cannot upgrade a 2008 to 2008 R2 without buying...
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 30, 2011 at 3:56 pm
Stefan Krzywicki (3/30/2011)
GilaMonster (3/30/2011)
Craig Farrell (3/30/2011)
Grant Fritchey (3/30/2011)
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
And that blank spot is...
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 30, 2011 at 2:19 pm
Why are you manually implementing log shipping?
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 30, 2011 at 2:13 pm
WayneS (3/30/2011)
Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop it.
You think it hasn't been mentioned...
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 30, 2011 at 1:50 pm
Craig Farrell (3/30/2011)
Grant Fritchey (3/30/2011)
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
And that blank spot is where the miracle...
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 30, 2011 at 1:44 pm
Grant Fritchey (3/30/2011)
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 30, 2011 at 12:15 pm
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
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 30, 2011 at 12:12 pm
Jack Corbett (3/30/2011)
The whole R2 naming is what causes the confusion I think.
Way too much. It's a separate version of SQL, just like 2008 and 2005 and the same upgrade/downgrade...
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 30, 2011 at 10:54 am
Vertigo44 (3/30/2011)
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 30, 2011 at 10:43 am
Craig Farrell (3/30/2011)
Sean Pearce (3/30/2011)
GilaMonster (3/30/2011)
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 30, 2011 at 10:41 am
mkgrayson (3/30/2011)
Are there any known issues with log shipping data from SQL2008R2 to SQL2008?
Yup, just one.
It won't work.
You cannot restore a 2008 R2 database onto SQL 2008. Hence you can't...
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 30, 2011 at 10:37 am
Stale statistics perhaps? Rebuilding the index would update them.
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 30, 2011 at 8:51 am
babuvalayil (3/30/2011)
But, @12:00 AM ---inserted 1000 rows using DTS package. What about these records?
What about them? Nothing I told you to do will affect those rows at 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
March 30, 2011 at 8:35 am
chetanr.jain (3/30/2011)
But tell me one thing, how does MS will come to know that candidate has used dumps?
I doubt exam fraud is going to give away their secrets by telling...
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 30, 2011 at 8:08 am
Do you still have the full backup from before the developer deleted stuff? Do you still have log backups from that point up til when he deleted the 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
March 30, 2011 at 8:05 am
Viewing 15 posts - 26,926 through 26,940 (of 49,552 total)