Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 9,244 total)

  • RE: Cannot increase database data file initial size

    What is the file max size set to?

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

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

  • RE: 2012 AlwaysOn AG could not failover automatically when service runs as Built-in account

    Have you read the articles I supplied??

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

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

  • RE: Which firewall ports required to be open for 2008 R2 Transactional Replication?

    kyle.hanson (1/7/2014)


    The publisher and the distributor are not firewalled between each other and are currently working together when it comes to replication.

    Ok but different instances on different servers?

    Where are snapshots...

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

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

  • RE: Which firewall ports required to be open for 2008 R2 Transactional Replication?

    Firstly, a couple of questions,

    Are the servers all firewalled from each other?

    Are the instances all default instances?

    The snapshot files are delivered via means of an NTFS share. Accessing a...

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

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

  • RE: SQL Server no longer writes data rows

    Even more worrying, why are all the connections using system administrator??

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

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

  • RE: Transactional Replication Questions and Concerns

    JoshDBGuy (1/6/2014)


    My concern has to do with contact backups on the primary database, transmissions failures, etc. From what I've seen, when transmitting a large number of logs because of potential...

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

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

  • RE: WS2008 R2 in place upgrade and SQL Server 2008 R2 gotchas?

    Ginga (1/6/2014)


    Just thought I'd close this one off.

    The in place upgrade went ahead this weekend just gone and it was a simple, albeit lengthy process. I decided to shut...

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

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

  • RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

    What command did you use to check the frags?

    Can you post the before and after outputs?

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

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

  • RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

    VossSQL (1/3/2014)


    Hi.

    I understand that SHRINK data/log files should be the last option due to all problems it generates. But how can I proceed on the following situation?

    SQL Server 2008 R2....

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

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

  • RE: 2012 AlwaysOn AG could not failover automatically when service runs as Built-in account

    cherish.j.wang (1/3/2014)


    confusion

    I am confused recently weeks for SQL Server 2012 Alwayson AG HA could not failover automatically when SQL Service is running as built-in account.

    according

    From Microsoft SQL Server 2012 online...

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

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

  • RE: Ola Hallengren procs / job deployment to each of 100 SQL Servers

    when you setup the central management server you can create a group and register instances. You may then execute a t-sql script against the group affecting all the registered instances

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

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

  • RE: Account for SQL Server Agent

    JimS-Indy (1/3/2014)


    I have access to an app that lets me manage group membership for groups I "own".

    What is the app called

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

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

  • RE: Moving files while the database is online

    you can detach by all means.

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

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

  • RE: Installing a clustered SQL 2012 instance is extremely slow

    EdVassie (1/3/2014)


    running two simultaneously to the same physical disk may take 3 hours for them to complete, and running 3 simultaneously may take 6 hours to complete. If I...

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

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

  • RE: WS2008 R2 in place upgrade and SQL Server 2008 R2 gotchas?

    the only time i would be shaky would be a major platform change, for instance in place upgrade from Windows 2003 Std to Windows 2008 R2 Std, etc

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

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

Viewing 15 posts - 3,796 through 3,810 (of 9,244 total)