Forum Replies Created

Viewing 15 posts - 31 through 45 (of 113 total)

  • RE: Resources consumed per database

    Check out the Performance Tuning with SQL Server Dynamic Management Views book by Louis Davidson and Tim Ford. I've just finished chapter 6 which is titled - PHYSICAL DISK...

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Restore Database

    Sounds like a client error, are you using the Restore Database Wizard? If you are using the GUI dont. Restore the database using TSQL, search 'RESTORE DATABASE' in...

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Difference between SSIS 2005 , SSIS 2008 and SSIS 2008 R2

    I would start here.

    http://www.microsoft.com/sqlserver/en/us/product-info/previous-versions.aspx

    THanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Cluster group cannot be empty

    If the errors is "The cluster group name cannot be null or empty" then the below may help?

    http://www.sqlerror.sqlserver-training.com/no-shared-disk-cluster-resources-could-be-found-for-the-sql-server-failover-cluster-instance-name-1/-

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Memory Utilised by SQL Server

    You can use DBCC MEMORYSTATUS

    http://support.microsoft.com/kb/907877

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Best approach

    I would go down the mirroring route.

    However since Database Mirroring is 'per database' I would be cautious about using automatic failover. You don't want some databases principals...

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: installation of system databases to another location

    Drop the Version drop box down at the top of the page and choose either SQL Server 2005 or SQL Server 2008.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: SQL Verioning or Alerts.

    Lets assume you are using SQL Server, I would start by securing your servers. That way you know only certain priviledged people can make changes. Introduce a release...

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: installation of system databases to another location

    Microsoft instructions below;

    http://msdn.microsoft.com/en-us/library/ms345408.aspx

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: How to start sql server?

    Or Buy the developer edition for around $50. This would be my choice as you are licensed and not restricted to a 180 day trial or limited features.

    http://www.amazon.com/Developer-Edtn-2008-32-bit-English/dp/B003KWQBQ2/ref=sr_1_1?ie=UTF8&qid=1316786283&sr=8-1

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Transactional Replication - Data Validation

    In a word yes.

    Check out the below link;

    http://www.informit.com/articles/article.aspx?p=603637&seqNum=3

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Back Up details

    Fabrizio Faleni's last option SSIS would be my prefered solution, the options are endless but using a procedure, powershell or SSIS you could;

    Automate it in a job

    Email the excel file

    Export...

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Does anyone using snapshot isolation for Sharepoint 2007 databases?

    It isn't something I would do lightly or without appropriate testing as you may invalidate licensing??? I would check with the Sharepoint Team maybe post something on their forums.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Database Mirroring State

    anthony.green (9/21/2011)


    Good question Chris

    Ant

    Thanks Ant, appreciate it.

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • RE: Database Mirroring State

    mohammed moinudheen (9/21/2011)


    L' Eomot Inversé (9/21/2011)


    (which I believe is that replication continues as normal but with reduced replication latency - but I can't find a reference to back that up).

    I...

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

Viewing 15 posts - 31 through 45 (of 113 total)