Viewing 15 posts - 38,311 through 38,325 (of 49,571 total)
ps (6/21/2009)
Gail, I think he is running Transaction replication coz i asked him to make a transaction and it replicated to subscriber in almost no time.
Check the output of syspublications...
June 21, 2009 at 4:43 am
Have you looked through SQL Books Online for information on cluster installation?
June 21, 2009 at 3:06 am
ps (6/20/2009)
he can also connect his named instance on local machine by typing.\instance_name
OR
127.0.0.1\instance_name
Assuming he knows what the instance name is.
June 21, 2009 at 3:02 am
If I'm understanding you correctly, this is not completely fixed. You're running only snapshot replication. Snapshot replication DOES NOT use transaction log. Hence the reference to replication in log_reuse and...
June 21, 2009 at 3:01 am
If you type in the local machine name can you connect?
June 20, 2009 at 3:46 pm
Jeffrey Williams (6/20/2009)
The maintenance plan plug-in uses UPDATE STATISTICS.
So if you're using the default maint plans, updating stats after rebuilding indexes will (I think) lead to a sampled...
June 20, 2009 at 3:45 pm
jeet_personal (6/20/2009)
But Is there any automated way or a stored procedure(scripts) to resolve this issue?
Regular scheduled log backups.
If you don't need point in time recovery (ie, if you're sure...
June 20, 2009 at 3:11 pm
Do you know offhand if maint plans use sp_updatestats or UPDATE STATISTICS?
June 20, 2009 at 3:10 pm
Can you maybe explain the problem in more detail? I'm not sure I understand what's wrong.
June 20, 2009 at 2:57 pm
Updating stats after an index rebuild is a poor idea. A rebuild of an index automatically updates stats on that index with full scan. If you then do a sampled...
June 20, 2009 at 2:16 pm
Are these interview questions or homework questions. They sound like the former.
May I suggest that you start by reading through books online? You'll probably find quite a few of...
June 20, 2009 at 2:06 pm
SO, if I'm understanding correctly, you have no transactional replication configured? Please can you run the following?
select * from syspublications -- run in the database in question
Is log_reuse_wait_descr still...
June 20, 2009 at 1:52 pm
Check that the log reader's running. Either the log reader's failed or it's slow in getting the transactions out of the log. Either way, the log cannot be truncated by...
June 20, 2009 at 3:46 am
JamesNZ (6/20/2009)
The value is 6 for log_reuse_wait. What does that mean?
Check the column log_reuse_wait_descr. It give the text description. log_reuse_wait just gives the numeric code.
June 20, 2009 at 3:37 am
What's the value of log_reuse_wait_descr in sys.databases? That'll tell you what's preventing log truncation (ie keeping the log records active)
June 20, 2009 at 3:27 am
Viewing 15 posts - 38,311 through 38,325 (of 49,571 total)