Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 9,253 total)

  • RE: Log Shipping

    check the output of the job steps and post back details

  • RE: Question re log shipping and transaction log backups

    vmit02 (10/11/2015)


    Can the log ship backups be used for general restoration?

    Yes, they're regular log backups so don't go deleting them.

    vmit02 (10/11/2015)


    I refresh Test from Live by restoring the full backup...

  • RE: Problem with windows 2012 R2 datacenter - in virtual server mode

    MotivateMan1394 (10/13/2015)


    how much ram assigned? 64

    how many virtual cpus? 30

    how many virtual network cards? 2 virtual network card

    assigning this much resource there's an argument for making this server a...

  • RE: tempdb is full

    where are the results from the powershell query

  • RE: FCI + AAG

    gingerdazza (10/12/2015)


    The site links are pretty good (1Gbps and 1-2ms latency), but there of course times when the link can get higher saturation, and running cross link synchronous for SQL...

  • RE: Availability replica is not joined

    How many secondary replicas have already joined the group, or is this the first one?

    Please post the output of the following query

    select bs.name, bs.server_name, bs.database_name,

    bf.physical_device_name, bs.user_name, bs.backup_finish_date,

    bs.type, bs.compressed_backup_size, bs.backup_size

    from...

  • RE: apply sp3 on cluster server

    you should be patching the mirror instance first, then failover to the mirror which now becomes principal.

    Patch the instance that is now the mirror and then failback if desired

  • RE: Availability replica is not joined

    have you checked for a job running on the server that is taking log backups?

    The error is pretty descriptive

  • RE: Is Transparent Data Encryption useful ? What practical intrusion does it protect against?

    sqld-_-ba (10/12/2015)


    TDE protects data at 'rest', meaning if someone got a hold of our physical .mdf/.ldf files, or our .bak's, or tapes, they could recover the data.

    TDE protects data at...

  • RE: Cluster environment - Restart agent

    ramana3327 (10/12/2015)


    Hi,

    We are using Windows 2012 & Sql Server 2014.

    I can see only failovercluster manager but not able to find the Cluster administrator.

    Is both are same?

    Failover cluster manager replaces cluster...

  • RE: How does cluster dissolution affect SQL?

    destroying the cluster without uninstalling is not a recommended option. Evicting a node and re adding without uninstalling has not produced issues for me in the past.

    Personally, based on what...

  • RE: Problem with windows 2012 R2 datacenter - in virtual server mode

    as i said, Windows 2012 R2 actually has more stability than previous versions, check my stairway for more info why.

    That error is almost certainly nothing to do with Windows, check...

  • RE: FCI + AAG

    gingerdazza (10/12/2015)


    FYI - All VMWare.......

    For VLDBs, I'd prefer not to use pure AAG between 2 DCs, as that normally leads to 3 copies+.

    How you working that out, you have 2...

  • RE: "lock pages in memory" not enabling on 2008 R2

    Larry Leonard-399461 (10/9/2015)


    I have a domain user running the SQL Server service, and have added that user to the "lock pages in memory" user right

    have you rebooted the server

  • RE: Problem with windows 2012 R2 datacenter - in virtual server mode

    MotivateMan1394 (10/11/2015)


    Hi

    we have windows server 2012 r2 - sql server 2014

    but we have some problems :

    1- unstable clustering

    Hmmm, clustering under Windows 2012 R2 is more stable than it's...

Viewing 15 posts - 1,651 through 1,665 (of 9,253 total)