Forum Replies Created

Viewing 15 posts - 7,891 through 7,905 (of 9,707 total)

  • RE: SP_Errorlog

    All,

    This is a duplicate thread. Responses can be found at Fatal Error.

  • RE: logshiping on cluster server.

    GilaMonster (6/3/2010)


    Log shipping to a failover node of the cluster is frankly stupid.

    Yeah, well, I tried to be nicer about that point in my first point on this thread.

  • RE: logshiping on cluster server.

    Well the OP isn't clear if the second server is on the cluster or not. I'm just assuming that's what (s)he meant.

    But it wouldn't be the first time this week...

  • RE: logshiping on cluster server.

    You can log ship to a server that has no instance?

    I thought log shipped databases were in a state of Recovery? I thought they needed an instance to reside on....

  • RE: logshiping on cluster server.

    Active / Active has a SQL instance on both nodes. Active / Passive has the instance only on one node. If you have instances on both nodes, you're running A/A...

  • RE: understanding of log seq#

    It amazes me that someone would expect you to restore backups with no alternative cataloging system to identify this information. Automated backups through the maintenance plan or a third party...

  • RE: logshiping on cluster server.

    Depends on what kind of cluster you have set up. If it's Active / Active, then yes, you shouldn't have a problem. If it's Active / Passive, you have a...

  • RE: Automating job scripts

    Job_ID is not an int. You have to use uniqueidentifier or char / varchar data types for your variable.

    EDIT: And yes, what you want to do is possible. Just adjust...

  • RE: Fatal Error

    Google that first sentence. There are tons of responses from 2008 and 2009.

    First one on the list is this one about 64 bit OS patches.

  • RE: Create Index on Replicated Tables

    Check out this link on how to read the dump log. It might help you track down your problem child.

  • RE: Create Index on Replicated Tables

    Check the dump log, and the server's event viewer. What are they saying?

    The usual "fix" in SQL 2000 for me (when it came to problems like this) was re-initializing the...

  • RE: Create Index on Replicated Tables

    It's been forever since I've used replication. I have this bizarre, vague memory that there's a setting in one of the properties windows that needs to be set in order...

  • RE: Upgrading OS Need Suggestions

    I don't know if there will be a problem if you move your databases without changing your SQL Server install from 32bit to 64bit. Have you upgraded the SQL Server...

  • RE: Fatal Error

    Check your server's Event Viewer for errors and warnings from around the time of this error.

  • RE: SP_Errorlog

    Describ the steps you're taking to read the error log, please.

    Also, is the log file hard drive full? Have you recently run a diskscan to verify all the sectors are...

Viewing 15 posts - 7,891 through 7,905 (of 9,707 total)