Forum Replies Created

Viewing 15 posts - 12,076 through 12,090 (of 49,552 total)

  • RE: Possible Corrupted Index - Strange Issue

    Try doing an update stats for each stats object on that table, one by one.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 16, 2013 at 2:37 am

    #1642022

  • RE: Log LDF file

    OnlyOneRJ (8/16/2013)

    Gail - Will APEX SQL ttol help me to read Log files which are backed up every 3 hours..

    Probably, but it's a damn expensive app. Was over $1000 per...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 16, 2013 at 2:33 am

    #1642021

  • RE: DBCC FREEPROCCACHE to shink TEMPDB

    In case you missed it

    GilaMonster (8/15/2013)

    As for shrinking TempDB, the recommendation is to completely quiesce the system before trying, by restarting in single user mode. Shrinking TempDB while processes are...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 16, 2013 at 2:30 am

    #1642020

  • RE: How to restore from a shipped Transaction log

    Since you've recovered the database, you can drop it and reconfigure the log shipping from scratch.

    The secondary will be up to date as of the last log backup copied and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 12:41 pm

    #1641907

  • RE: How to restore from a shipped Transaction log

    If you selected standby, the database should be in the standby state. Recovering is when you select the NoRecovery status.

    Standby's only if you need to read the database for any...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 12:01 pm

    #1641888

  • RE: DBCC FREEPROCCACHE to shink TEMPDB

    Plan cache and TempDB space are unrelated. No, removing plans from cache is not going to do anything about tempDB's size or behaviour in a shrink.

    As for shrinking TempDB, the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 10:13 am

    #1641864

  • RE: Incorrect paths used when moving datafiles

    http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 6:47 am

    #1641776

  • RE: checkdb and snapshots

    Are there any relevant messages in the error log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 6:41 am

    #1641768

  • RE: Incorrect paths used when moving datafiles

    Mis-named user database files won't stop the instance from coming online. They'll only lead to the database in question being marked recovery_pending (not suspect)

    It's master, model and TempDB that can...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 5:05 am

    #1641729

  • RE: How to restore from a shipped Transaction log

    Procmeister (8/15/2013)

    - Once I've done that how does it work? Will I see new jobs setup? Is a new database created? Will I be able to get an email if...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 5:02 am

    #1641728

  • RE: How to restore from a shipped Transaction log

    May I suggest you use the built in log shipping functionality? Much easier.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 2:43 am

    #1641691

  • RE: checkdb and snapshots

    Create a snapshot manually, check any messages in the error log.

    Do you have any disk filter drivers installed?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 2:41 am

    #1641688

  • RE: sql server automatically opening a file handle for every database file

    To delete databases you would always log into SQL and do the delete from inside SQL Server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 2:40 am

    #1641687

  • RE: Clear cache after big job?

    I wouldn't suggest doing that. SQL manages the memory in cache just fine, and by clearing it you're removing any chance that pages needed by the night time work which...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 2:38 am

    #1641686

  • RE: Restoring a database and simultaneously increasing it's file size

    Jeff Moden (8/14/2013)

    If you buy the right disk defragmentation system, you can defragment SQL Server MDF, LDF, and NDF files while the system is up and running with little or...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 15, 2013 at 2:34 am

    #1641683

Viewing 15 posts - 12,076 through 12,090 (of 49,552 total)