Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 9,253 total)

  • RE: 2008 R2 mirroring suspended. added a new file on p, drive doesn't exist on m.

    snomadj (8/18/2016)


    Foolishly, I did the following:

    Added a new data file on current principal.

    On my mirror the drive letters don't match

    The new file could not be created on...

  • RE: LogShipping database to standby mode

    Sree Divya (10/13/2016)


    Hi,

    i have configured logshipping for my databases.

    for dr testing i have disabled the lscopy,ls restore jobs on the secondary server and after that i have ran my database...

  • RE: Edition upgrade on sql 2008 cluster

    tcronin 95651 (9/20/2016)


    Going to do a upgrade from sql 2008 standard edition to sql 2008r2 on active/passive physical cluster. WHen finished wanted to upgrade the edition from sql 2008r2...

  • RE: Help with SQL 2012 to SQL 2016 P2V considerations

    most I've seen who get it wrong move to hardware that's inferior expecting it to be super fast and it isn't.

    I've worked on projects where we've used high end kit...

  • RE: Help with SQL 2012 to SQL 2016 P2V considerations

    SQLKnowItAll (10/20/2016)


    I suppose that depends on how you measure "overhead." I still stand by my statement that "in general" a properly configured VM can boost your performance.

    :w00t: wow you stand...

  • RE: migrating sql server 2005, 2008 and 2012 to 2014 on new server new storage

    so just backup user databases from the source servers and restore them onto the new cluster

  • RE: When to user snapshot isolation level?

    suvorav (10/17/2016)


    Could you give me a good example when to use snapshot isolation?

    When I wanted to mitigate read-write workload issues then RCSI seemed enough

    When I attempted to use snapshot...

  • RE: ALTER DATABASE permission error

    Guras (10/19/2016)


    it's strange that my username is the member of the server role sysadmin if I check it in the Security section through SSMS.

    are you connected to the correct instance...

  • RE: Db Owners Nulled

    CM-249617 (10/19/2016)


    Sue_H (10/19/2016)


    CM-249617 (10/19/2016)


    We had a weird incident last night where five databases had nulled owners. In other words, if you ran sp_helpdb you would see null in these...

  • RE: How to recover AG when error is SUSPEND_FROM_CAPTURE

    SQLSalas (10/19/2016)


    Well not entirely no information. Not even tagged an Error, just an information. I would pretty much appreciate any additional information.

    For now, this IS the information:

    "Always On Availability...

  • RE: Help with SQL 2012 to SQL 2016 P2V considerations

    SQLKnowItAll (10/19/2016)


    What makes you say there will be negative performance impact of virtualization? I would say "generally" you can get a bump in performance.

    Virtualisation carries an overhead, fact. Its...

  • RE: sql backup

    Krasavita (10/18/2016)


    Do you have any idea how long it might take to sql backup for 600 gb.

    Thank you

    As stated, it depends on your hardware and configuration.

    As a rough guide, I'm...

  • RE: ALTER DATABASE permission error

    Guras (10/18/2016)


    ALTER DATABASE DB1

    SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    This is giving me the following error and I am in the sysadmin server role in the...

  • RE: log is full due to Availability Replica

    rkrpat (10/18/2016)


    Thanks for your suggestion... thought anyone could give an idea how and why AG replica goes to Not synchronising state in general.. getting consultant help is already done.. but...

  • RE: log is full due to Availability Replica

    Brandie Tarvin (10/19/2016)


    Are you taking log backups of your primary AG database? If not, then expect it to fill up and not clear.

    you can offload log backups to secondaries, they...

Viewing 15 posts - 1,126 through 1,140 (of 9,253 total)