Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 9,244 total)

  • RE: Another VM Sertup Question With SAN

    you need to supply a little more info on the intended setup. Will the VMs be using plain virtual HDDs on the ESX datastore or do you plan to attach...

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

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

  • RE: How to detect that the SQLServer is shutting down i.e Shut down in Progress

    if the service is shutting down scripts will not be running.

    What you could do is run a SP at each service start, or capture the service state from the Windows...

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

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

  • RE: Quoram in Always on & enabiling memory optimization

    ramana3327 (12/2/2014)


    I am re-framing my question about the sensitive data.

    Currently we are using 3 production servers. In one production server we have one database has sensitive data.

    Suppose we have...

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

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

  • RE: How to free up the drive space in SQL that has data files

    High end FC disks generally arent available in TB sizes and are usually in the order of $1000s each

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

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

  • RE: I'm Stumped - Starting SQL With Domain Account

    Sean Pearce (12/1/2014)


    provided the server is still available.

    😀 what have you done with it then

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

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

  • RE: How to free up the drive space in SQL that has data files

    Jeff Moden (11/28/2014)


    A 1 TB 15k-RPM drive costs less than $300 for a SAN drive.

    High end FC disks are a lot pricier than $300!!

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

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

  • RE: AD accounts and deny backup problems

    Erland Sommarskog (12/1/2014)


    I asked you to check both place, since I was not sure whether this is a server-level or database-level permission.

    BACKUP DATABASE and BACKUP LOG are database level...

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

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

  • RE: Quoram in Always on & enabiling memory optimization

    ramana3327 (11/30/2014)


    Hi Perry thanks for your link.

    The client have some business agreement. ServerA databases never mix with ServerB database. Also we are worrying about the load also. If we keep...

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

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

  • RE: Database Inaccessible

    jacksonandrew321 (12/1/2014)


    Hi Experts

    On my SSMS I found that my database status is showing "recovery pending". WHat does it mean? My database is inaccessible right now? What should I do ?...

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

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

  • RE: I'm Stumped - Starting SQL With Domain Account

    have you checked the local SQL Server groups to see if the svc account has been added, when installing SQL Server 2008 on Windows 2003 it will use the old...

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

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

  • RE: SQL 2014 HA /DR Licensing

    seems like a typical design scenario, no FCIs too

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

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

  • RE: Is it possible to make particular users/group only go to SQL Server AlwaysOn Read only node outside Application Intent setting

    The routing configuration only details the routing preferences for replicas when in the secondary role.

    Users not only need to set the readonly application intent but also use the listener name...

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

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

  • RE: Log growth on Always on availability databases on Primary server

    How many secondary servers do you have for this AO group?

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

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

  • RE: SQL 2014 HA /DR Licensing

    WilburBud (11/28/2014)


    It is my understanding that licensing SQL server 2014 with software assurance allows only one passive server per licensed server, having a failover server in the production environment plus...

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

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

  • RE: SQL 2014 HA /DR Licensing

    MSteynberg (11/28/2014)


    Hi Guys,

    I hope you can clarify something for me.

    I have a 3 node SQL Server Failover cluster in my production environment. Each Node has 24 cores.

    I...

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

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

Viewing 15 posts - 2,671 through 2,685 (of 9,244 total)