Viewing 15 posts - 26,506 through 26,520 (of 49,552 total)
With synchronous mirroring there is NO chance of losing data. Why do you think there 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
April 26, 2011 at 7:56 am
That's client tools, and it's a whole different story.
As for the database files, a higher database version cannot be restored to a lower database version. That's irrespective of CU or...
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
April 26, 2011 at 7:55 am
Syed Jahanzaib Bin hassan (4/26/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
April 26, 2011 at 4:59 am
If you're going to script the logins, don't use the 'script login as...', you also need to script the password and the SID for any SQL accounts you have. Otherwise...
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
April 26, 2011 at 4:52 am
Why do you think data will be lost?
Reboot the mirror, once it's up, fail the mirroring over, then reboot the principal.
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
April 26, 2011 at 2:03 am
Please don't post in all caps. It's like shouting at people.
Have you tried a google search? Lots of info on replication around.
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
April 26, 2011 at 2:01 am
SQLRNNR (4/25/2011)
GilaMonster (4/25/2011)
SQLRNNR (4/25/2011)
Any word on when the Email delay will be fixed?
According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. Better get...
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
April 25, 2011 at 3:30 pm
SQLRNNR (4/25/2011)
Any word on when the Email delay will be fixed?
According to a recent tweet, 'before tomorrow'. They have 37 minutes and counting before tomorrow. Better get working. 😀
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
April 25, 2011 at 3:24 pm
[Jim].[dba].[Murphy] (4/25/2011)
Course, it was Cat 5 and not fiber. How fast does cat 5 (not e) travel, 1,126 ft/s (768MPH) when it is 68 degrees F outside?
2/3 c, 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
April 25, 2011 at 2:16 pm
DB_Newbie2007 (4/25/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
April 25, 2011 at 12:23 pm
Ninja's_RGR'us (4/25/2011)
You're the 3rd one here pointing that out to him in the last few days. Maybe he'll get it THIS time.
You, me, Jeff, Lowell, Tara (from SQLTeam) 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
April 25, 2011 at 10:38 am
Brandie Tarvin (4/25/2011)
I noticed the issue last Friday too, but today it's particularly bad. I just received notification for Jeff's last post, which was several hours ago.
Today's good for me....
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
April 25, 2011 at 10:27 am
Maxer (4/25/2011)
Also, I didn't know you considered yourself a "Ranger", awesome series.(I also never noticed your tag line before... is that new as well?)
Marcus was one of my favourite characters,...
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
April 25, 2011 at 9:58 am
Maxer (4/25/2011)
1. Is there a similar way to see when a view was last executed? I am interesting in seeing what sprocs and views are seldom / never...
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
April 25, 2011 at 9:30 am
Errr... did you read any of the replies?
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
April 25, 2011 at 8:29 am
Viewing 15 posts - 26,506 through 26,520 (of 49,552 total)