Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 9,244 total)

  • RE: Table size and Index size

    The Gug (11/2/2015)


    Good afternoon

    I ran across an issue that I don't understand. I have a DB that is 177gb. When I dug through the DB, I found a...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: how i can grant to the database

    benyaminprogramer (11/26/2015)


    hi , i can not grand to the database ,may i help me ? please

    What permissions are you trying to grant?

    What permission level does the granting user hold?

    Please...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: 150 GB Backup (compressed) taking over 1 day

    jbrandenburg (11/16/2015)


    The backups are being taken to another virtual server on the SAN.

    across the network?

    jbrandenburg (11/16/2015)


    We have dedicated drives for backups.

    dedicated drives on a virtual server?

    jbrandenburg (11/16/2015)


    It appears we have...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Restore database with a different name on another server using NetApp-SnapProtect

    gkramer 23701 (11/26/2015)


    Guys,

    I'm looking for a solution to restore a database with a different name (on another SQL-server) using SnapProtect -- DataOntap 3v6 / SnapProtect vs 10r2.

    As a...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Issue Cluster AlwaysON SQL 2014 SP1

    go into failover cluster manager and check that the cluster role for the AO group has started.

    Post a screenshot of the failover cluster manager view if you're unsure

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Turning off TDE

    yakko_Warner (11/25/2015)


    which I'm sure is impacting performance do to storage not be the same setup as the physical box.

    storage is generally the weak link, you wont get like for...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: AAG failover to DR node

    you'll need to ensure the primary and the asynch secondary replicas are synchronised and that the network connection is stable, if you want to test the failover with an element...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Windows Cluster (SQL server 2008 R2) for BIZTALK Setup Active/Passive or Active/Active

    SQL-DBA-01 (11/20/2015)


    Hello Experts,

    I have a requirement to setup Cluster for BIZTALK 2010/2913 setup. They need BizTalkMsgBoxDb db in one server, (BizTalkDTADb, BizTalkMgmtDb and BizTalkRuleEngineDb) in another another server...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: installing multipe instances at the same time

    ebooklub (11/23/2015)


    Hi,

    is anyone tried to run multiple SQL server instances installation at the same time?

    Scenario

    We need to install 20+ instances of sql2012 + SP...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database files have NTFS permission inheritance disabled by default. Can this be changed?

    clubbavich (11/20/2015)


    Hi all,

    Is there a way to make it so that when SQL server creates a database file, it inherits permissions from the directory its in? From what I can...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Attempted to move tempdb to a different drive and now SQL won't start

    Bryan.avergonzado (11/23/2015)


    When I attempted to move the temp db I used the following statement.

    use master

    go

    Alter database tempdb modify file (name = tempdb, filename = 'E:\MSSQL\DATA\tempdb.mdf')

    go

    The logical name for the tempdb...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: AlwaysOn help

    what is the current state of data movement?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: sql server 2012 active/passive cluster with AG read only in the future

    yes whenever you need to

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: WSFC Event ID - 1069 Cluster IP Group not online

    SQL Galaxy (11/20/2015)


    Attached screen shots Cluster core resource

    can't see all the columns

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: sql server 2012 active/passive cluster with AG read only in the future

    tcronin 95651 (11/19/2015)


    Have a current 2008r2 active/passive cluster with logs shipping to a read only sometimes reporting server. I got part of what I requested that we get to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 1,546 through 1,560 (of 9,244 total)