Viewing 15 posts - 26,821 through 26,835 (of 49,552 total)
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 7, 2011 at 6:32 am
If you go your own route, be aware there are many ways to get it wrong and very few ways to get it right. Wrong methods will result in either...
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 7, 2011 at 2:56 am
Update as in change the value? If so a straightforward UPDATE statement will work. If not, I'm confused as to what you're asking
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 6, 2011 at 3:45 pm
[Jim].[dba].[Murphy] (4/6/2011)
You studied straight from the BOL as your primary textbook?! Ha! That's a reference, not an instruction guide.
i got the list of skills covered from 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
April 6, 2011 at 9:26 am
Lol.
Personally i studied out of Books Online, but that's not likely to suit most people. The training guides are usually adequate, if not necessarily complete.
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 6, 2011 at 8:51 am
Lynn Pettis (4/6/2011)
Star Trek (the Original)
My mother loves both that and Thunderbirds.
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 6, 2011 at 7:44 am
C.K.Shaiju (4/6/2011)
Gail/Ali, Is there any way to restore the data from Mirror to Primary if something happened to primary data?
The mirror is exactly that. A complete mirror image of 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
April 6, 2011 at 6:38 am
Rhox (4/6/2011)
Only answer I got: that was decided to be the most usefull.
And it's not my decision 🙁
I think the photo's are saved...
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 6, 2011 at 6:27 am
Sure, if you're completely happy with not being able to recover data if it is deleted.
Seriously, what happens if someone drops the table that stores those photos? Or accidentally...
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 6, 2011 at 6:14 am
Rhox (4/6/2011)
Mirroring was good for business. Backups were not necessary.
So if someone dropped the table that stores those photos, business would be happy with the complete loss of all 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
April 6, 2011 at 5:49 am
Rhox (4/6/2011)
No we are not taking any backups (our 'backup' is the mirrored db)...
Mirroring is NOT a backup. It's a high-availability solution.
http://sqlinthewild.co.za/index.php/2009/05/08/high-availability-backups/
Without backups how do you expect to fix a...
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 6, 2011 at 5:29 am
- Win. (4/6/2011)
Planning to log backup and shrink the log file.
Not going to help. You need to address the cause, which currently appears to be something in the mirroring.
Restart 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
April 6, 2011 at 5:21 am
Please read through these: http://www.sqlservercentral.com/articles/64582/, http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Shrinking the log is only for when it's grown beyond normal size due to some unusual operation. If it's normal operation, the log will just...
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 6, 2011 at 5:19 am
GilaMonster (4/5/2011)
p.s. Pre-req reading apparently not done. Relevance of reply in question. Signing off for the night.
It appears I misjudged. Pleasantly 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
April 6, 2011 at 5:14 am
Alex Webber (4/6/2011)
Thanks Gila... although you did not solve the problem directly, you pointed me down the path to finding the issue and now I feel a little stupid!
Don't worry,...
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 6, 2011 at 5:13 am
Viewing 15 posts - 26,821 through 26,835 (of 49,552 total)