Category: SQL Server

  • Step By Step Log-Shipping Configuration for SQL Server

    Setting up Log Shipping for SQL Server is not that difficult, but having a step by step process is helpful if this is the first time you have setup Log Shipping. In this tip we walk through the steps to setup Log Shipping.

    To read the step by step Log-Shipping steps CLICK ME to read it.

    Or Open http://mssqltips.com/tip.asp?tip=2301 link

  • SSMS Startup Options

    You can configure SSMS to startup with the below options. Default one is Open Object Explorer.

    Go Tools –> Options –>Environment(page)–>General.

    Options are self explanatory.

  • SQLWB.exe (SQL2k5) and SSMS.exe(SQL2K8)

    SQLWB (sqlwb.exe) /SSMS(SSMS.exe) is the executable file that launches SQL Server Management Studio. I am usually using it to launch the SQL Server management studio instead of navigating through Start -> All Programs -> SQL Server 2005 -> SQL Server Management Studio.

    Above command will launch the SQL Server 2005 Management Studio. You can launch the SQL2k8 management studio using SSMS.exe

    You can also pass below list of argument with it, I am executing below command to see the list of parameters.

    c:\sqlwb.exe -?

  • Steps to Check SQL Server Services Status

    Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Services

  • DMVs for SQL Server Cluster

    sys.dm_os_cluster_nodes
    This view returns a row for each node in the failover cluster instance configuration. If the current instance is a failover clustered instance, it returns a list of nodes on which this failover cluster instance has been defined.

    sys.dm_io_cluster_shared_drives
    This view returns the drive name of each of the shared drives if the current server instance is a clustered server. If the current server instance is not a clustered instance it returns an empty rowset.

    Permission
    You must have VIEW SERVER STATE permission for the SQL Server instance.


    SELECT *
    FROM   sys.dm_os_cluster_nodes
    –OR
    SELECT *
    FROM   Fn_virtualservernodes()

    –Shared Drives
    SELECT *
    FROM   sys.dm_io_cluster_shared_drives