Forum Replies Created

Viewing 15 posts - 1 through 15 (of 36 total)

  • RE: Linked Server Login Error NT AUTHORITY\ANONYMOUS LOGIN, Kerberos

    Hi,

    Have you set the Computer Account to be Trusted for delegation? This can be done in AD with the User and Computers console by opening the properties of the Computer...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Breaking the backup-chain or backup sequence in SQL Server?

    Yes, they can (and it's trivial to test and prove). Full backups DO NOT and never have had any effect at all, whatsoever on the log backup sequence.

    I just tested...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Breaking the backup-chain or backup sequence in SQL Server?

    NO!

    Full backups do not and never have broken the log chain. The reset the differential base, that is all. Copy_Only allows for a full backup to not reset the...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Breaking the backup-chain or backup sequence in SQL Server?

    GilaMonster (8/4/2014)


    To break the backup chain:

    - Switch to simple recovery and back to full

    - Delete a log backup file (the .trn)

    - Delete the transaction log

    - Revert to a snapshot

    My additions...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: How to decide How much memory is required by the Instance

    Hi,

    If your SQL Server is configured to use 16GB of memory by setting the Max Server Memory configuration option to 16000 (or by leaving it to default value), it's very...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Memory Dump

    Hi,

    If you want to know what query caused the memory dump, you need to look into the memory dump. You need to use a debugger, such as WinDBG, for that...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: OS cache in Sql Server

    Hi,

    OS System Cache is a subset of a Standby List. Standby List is used for pages that have not been touched for awhile and Windows performed memory trimming on them....

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: SQL Alias between client and server

    Hi,

    I think there might be something wrong with the alias you're creating. In the Add Network Library Configuration page check the following:

    Server alias: This is the alias name to the...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: SQL Alias between client and server

    Hi,

    Error code 53 means: "The network path could not be found". The most common reasons I've seen this occur are:

    A) Name resolution failure. This can be tested by adding the...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: SQL Alias between client and server

    Hi,

    If your client OS is 64-bit you have two cliconfg.exes, one is the 64-bit residing in \Windows\System32 folder and the other one is the 32-bit one in the \Windows\SysWOW64 folder.

    If...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Good script for index maintenance

    Ola also provides a excellent documentation for all his maintenance solutions, just click the link on the left side under "Menu"-title. The documentation has all the parameters explained as well...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: SQL Alias between client and server

    Hi,

    Have you been able to connect from the client computer without using the alias? If your client software doesn't support that for some reason, you can use regular telnet with...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: SQL 2012 Multi Instance Cluster - DTC

    Hi,

    You should start out by mapping what instances require DTC as it's not something you automatically need (after SQL Server 2005, which did require it for cluster installation). SQL Server...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Add additional SQL instance to existing SQL Server 2012/2014 Cluster

    logicinside22 (7/12/2014)


    HI

    I just created SQL Server 2012 active/passive two node cluster. Have F:\ Data G:\ Log for this cluster

    Now I want to add sql 2014 with names instance...

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • RE: Problems installing updates to SQL2012 Enterprise Edition

    Hello,

    Have you looked at Summary.txt and Details.txt files? These should be in the timestamp folders under \Setup Bootstrap\Log folder and have more details about any errors occurring during the update.

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

Viewing 15 posts - 1 through 15 (of 36 total)