Forum Replies Created

Viewing 15 posts - 1 through 15 (of 528 total)

  • RE: Do You Verify Your Database Backups?

    John,

    Thank you! YES!!!! Who'd a thunk the key search phrase would be 'statistical sampling'

    Steve

  • RE: Do You Verify Your Database Backups?

    Well, in my case, I get to BE the policy wonk - I'm looking for a defensible basis (found some 'fancy' math papers talking about Markovian processes but my employer...

  • RE: Do You Verify Your Database Backups?

    OK... Three years later, and not much has changed. We are still preaching the value of testing our backups, and complaining about the scarcity of resources (time, space, [virtual]...

  • RE: Clustering with Database Mirroring Question...?

    Perry,

    I think your answer to number 2 is incomplete. Once the original principal database has caught up, you can failover and 'return' the original principal to being the principal...

  • RE: Replication not installed?

    It turns out I did not share THE critical piece of information: the connection is across a VPN. In order to support connectivity, dynamic addressing must be overridden so...

  • RE: Replication not installed?

    One other interesting bit of behavior: When I attempt to create the subscription, and am trying to add the subscriber, if I use the IP address of the subscriber...

  • RE: Replication not installed?

    Lynn Pettis (3/21/2012)


    Dumb question, is the SQL Browser service running on the server?

    Lynn, the only 'dumb' question is the one not asked. And,yes, Browser is running, even after restarting...

  • RE: Is it SQL Server or is it Windows causing the problem?

    Ultimately, what I did was blow away the SQL Server instance and start over. Once I did that, I was then able to connect remotely using <server>\<instance> in SSMS,...

  • RE: Replication not installed?

    OK... created a new instance, can successfully connect locally using SSMS, <server>\<instance and windows authentication.

    Only shared memory and IP/TCP are enabled. However, from the publisher's machine I am able...

  • RE: Replication not installed?

    Instance or Server Name? My understanding is you CANNOT rename an instance. The article referenced talks about renaming the server. And, yes, the server name matches the...

  • RE: Replication not installed?

    Since the browser is running, I've concluded that it's more appropriate to wipe everything clean and start over, even though I hate to resort to brute force like this...if I'm...

  • RE: Replication not installed?

    SQLRNNR (3/21/2012)


    When you installed SQL server, did you ensure the replication components were selected as a component to be installed?

    Jason, I did ensure the replication components were selected. ...

  • RE: Replication not installed?

    MysteryJimbo (3/21/2012)


    Its also possible to duplicate this error if the server has previously been renamed.

    Are you accessing the server through a dns alias?

    Make a connection to the server and SELECT...

  • RE: Replication not installed?

    Named instance.

  • RE: Replication not installed?

    SQLRNNR (3/21/2012)


    Sounds like an alias was created for this server or this server is clustered. Will you confirm the aliases in SQL Server configuration manager?

    When you say alias, do...

Viewing 15 posts - 1 through 15 (of 528 total)