Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 9,244 total)

  • RE: Auto-Growth ISSUE - Causing outage - Please help.

    sgrimard (2/5/2016)


    Autogrow of file "DB_NAME" in database "DB_NAME" was cancelled by user or timed out after 17152 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value

    for this file...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Auto-Growth ISSUE - Causing outage - Please help.

    have you enabled the local security policy "perform volume maintenance tasks" for the sql server service account?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: "Antiquated" SQL Server Backups

    We had snapmanager at our last gig Thomas don't you remember

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Physical or VM - ODS

    VMware have a BP document on their website, google and you're sure to find it

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: "Antiquated" SQL Server Backups

    Ed Wagner (2/4/2016)


    Like many others have said, I think native backups are the way to go.

    Either native or via a tool such as Redgate SQLBackup or Dell Litespeed for SQL...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Physical or VM - ODS

    you will almost certainly be expected to justify for spending then money on physical tin, don't forget it's not just the cost of the server but the on-going maintenance costs,...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Always On and applying Service Packs and CUs.

    jcarranza 23978 (2/4/2016)


    β€’To prevent the availability group from unintended failovers during the upgrade process, remove availability failover from all synchronous-commit replicas before you begin.

    remove the automatic failover flag where it's...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Physical or VM - ODS

    ok, so space wise you have no worries, as it's SAN presented you can grow the storage at will.

    You're planning for a physical server then?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Upgrading to SQL Server 2008R2

    ramana3327 (2/4/2016)


    It worked fine but after the upgradation it is showing 64bit.

    the architecture is detected by the installer, anything else is a futile exercise

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Database Backup - Security Question

    the issue is, DB_Owner is an elevated privilege the developer does not require πŸ˜‰

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Always On and applying Service Packs and CUs.

    jcarranza 23978 (2/4/2016)


    1. Open your Windows FailOver Cluster Manager .

    2. Check which node owns the Role (A or B).

    3. Pause the Secondary node (so that the Primary knows is down)

    4....

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: backup into another server

    is this a clustered instance of SQL Server?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: "Antiquated" SQL Server Backups

    Steve Jones - SSC Editor (2/4/2016)


    If backup exec writes the backup time before it's finished, that's an issue. Certainly you might not be able to rely on this for restores...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Physical or VM - ODS

    SQL!$@w$0ME (2/4/2016)


    Hi Guys,

    Could you please give some guidance on selecting hardware for a new DB server. This will be a new Operational Data Store setup. Expecting moderate ETL load (SSIS...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Is there a way to quantify what extra overhead that TDE might be causing?

    bit late to the party here but

    • you can track read and write I\O per database file using the DMV "sys.dm_io_virtual_file_stats"
    • you can get CPU utilisation by database using "sys.dm_exec_query_stats" and "sys.dm_exec_plan_attributes"

    Check...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 1,396 through 1,410 (of 9,244 total)