Viewing 15 posts - 44,611 through 44,625 (of 49,552 total)
Dunno if the upgrade will automatically change the compat mode, but you can change that freely from 90 to 80 or even 70 if you wish.
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 9, 2008 at 1:11 pm
GSquared (9/9/2008)
I have this horrible thought about SQL in spandex stuck in my head now.
Could be worse. Could be a SQL consultant in spandex....
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 9, 2008 at 1:08 pm
I'd recommend full daily and log on the hour.
If you switch to simple and the DB crashes just before the diff, you've lost an hour's worth of data. If you're...
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 9, 2008 at 7:06 am
And make sure that you check on microsoft's learning site for the material covered by the exam. (http://www.microsoft.com/learning/mcp/mcts/bi/)
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 9, 2008 at 7:03 am
You need to schedule regular log backups. If you do, the log won't grow to huge sizes. The frequency of the log backup depends on the activity in the DB,...
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 9, 2008 at 6:53 am
Log backups should be more frequent than that. Every hour, every 30 min, every 15 min. The question to ask here is, should the drives of that server fail 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
September 9, 2008 at 6:43 am
SQL Agent is a job scheduler. You can access SQL agent through management studio's object explorer.
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 9, 2008 at 6:32 am
Before you send any data to the vendor, make sure you're familiar with any legal requirements in that area. I don't know what kind of data's in that table, but...
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 9, 2008 at 6:32 am
Not that one, but I did write 71-450 a few weeks back. (2008 administration)
It took me about an hour and a half. I was seriously worn out by the end,...
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 9, 2008 at 6:28 am
The term dump (brain dump) means a set of questions from the actual exams that people have posted on sites (in violation of the exam NDA) with the answers 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
September 9, 2008 at 6:21 am
The first 5 there shouldn't be run as is.
Shrink database should not be a regular task ever.
If the indexes are rebuilt, then reorganise is redundant, as is update statistics. 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
September 9, 2008 at 6:19 am
Well, if the log reader's missing/deleted that would explain the problem with the log. It's definitely a transactional replication, not snapshot.
Can see that from the Replication Type column in...
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 9, 2008 at 6:17 am
That's not what I'm talking about. I'm asking if getting your hands on the answer sheet for the upcoming exam that contains the questions that you know will be asked...
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 9, 2008 at 2:45 am
You have transactional replication there, not snapshot. Check that the log reader agent is running.
It should be a job, you should also be able to see it from enterprise...
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 9, 2008 at 2:31 am
Do you have regular log backups running?
See - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
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 9, 2008 at 2:24 am
Viewing 15 posts - 44,611 through 44,625 (of 49,552 total)