Forum Replies Created

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

  • RE: Tracking a change to the notifications on an Agent job

    I am afraid that you will be able to find the culprit

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: Attempt to fetch logical page (1:440) in database 2 failed. It belongs to allocation unit 422212869292032 not to 6269010747738816512.

    Please check if your tempDB is being shrunk too regularly? You may have to check auto shrink property of tempdb as well....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: Jobs not running in cluster

    first you need to check the error message... kindly let us know what error you are getting....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: Adding 2nd Node to SQL 2008 Enterprise Failover Clustering

    Have you checked if your cluster services are running or not? worth checking that...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: How to stop SQL services on both cluster node without failover

    you need to freeze the cluster to do this task

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: Current SQL Server servicepack on passivenode

    Go to SQL Server Configuration Manager --> SQL Server Service --> Right click --> properties --> Advanced tab --> scroll down to version...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: Log Shipping Looking for Backups in wrong location

    Just to add one point -->

    You were seeing path as "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ C:\SQLLogs_LS\dbname.trn" .....

    The path C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ would have been the default backup path for your...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: how read from mirror server ?

    if you plan to make use of snapshot, do remember its static and will have data upto point in time when snapshot is created....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: Installation Error: Volume does not belong to the cluster group

    are you using Veritas cluster or Windows cluster? Make sure your R drive is a part of cluster and is available with the node you are trying to install...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: SAN to SAN hardware level (Block Level) replication solution for MSSQL 2008 R2 databases synchronization between DR and Production

    In our environment we are not preferring this scenario and would rather request to opt out the mdf. ndf and ldf files as it have caused issues during DR exercise....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: how does sql read tempdb multiple .ldf files

    As a best practice and even you will find in almost all the SQL Server books, use the following naming convention:-

    .mdf -> for primary data file

    .ndf -> for subsequent secondary,...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: How to change the named instance name to default instance name on SQL Server 2008 R2?

    Once installed you cannot change the instance name without doing uninstall and reinstall...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: MsxEncryptChannelOptions and Multi-server administration

    don't mess with registry.....

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: How to change the data retention period from 5 yr to 20yrs in SQL 2005

    Possibly you have some custom job/script running on the server that you may have to look into...;-)

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • RE: a tricky query

    Well explained Lynn..... That is what exactly happening in these two queries...

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

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