Forum Replies Created

Viewing 15 posts - 20,791 through 20,805 (of 49,552 total)

  • RE: Restore Database Failed

    If the backup names are the same (and not just obfuscated out), then yes.

    That said, if they were appended and the restore as simple as the code shows, it would...

    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

    January 24, 2012 at 10:02 am

    #1437788

  • RE: Restore Database Failed

    jarid.lawson (1/24/2012)

    I ran the restore again, but still nothing. The database name reappears, the tables are back, but no data has been repopulated, and the Stored Procedure is also missing.

    That...

    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

    January 24, 2012 at 9:36 am

    #1437773

  • RE: DBCC CHECKDB and Recovery

    Firstly, "In recovery" is a normal process that all of your databases go through every time SQL starts up, so there's nothing horrific about it.

    Is this the combination of messages...

    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

    January 24, 2012 at 9:07 am

    #1437748

  • RE: Lots of VLF in logfile

    Ninja's_RGR'us (1/24/2012)

    GilaMonster (1/24/2012)

    Full backups will take longer than they should. Log backups take longer than they should. Large transaction rollbacks may take longer than they should. Restores will take longer...

    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

    January 24, 2012 at 8:59 am

    #1437743

  • RE: Am I understanding "maximum memory utilized" correctly?

    Sure. Take a look through all of the sys.dm_os_memory_* DMVs (there are a lot of them)

    Edit: Also DBCC MemoryStatus, but that might be harder to understand

    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

    January 24, 2012 at 8:51 am

    #1437735

  • RE: Lots of VLF in logfile

    Full backups will take longer than they should. Log backups take longer than they should. Large transaction rollbacks may take longer than they should. Restores will take longer than they...

    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

    January 24, 2012 at 8:35 am

    #1437727

  • RE: Am I understanding "maximum memory utilized" correctly?

    It's not just data cache.

    SQL's memory used is the data cache, the plan cache, query workspace and a whole lot of other smaller caches that exist. The data and plan...

    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

    January 24, 2012 at 8:33 am

    #1437724

  • RE: ShrinkDatabase doesn't shrink the data file

    Glad to hear it's fixed, but I wish we'd been able to figure out why it was happening. This is not expected behaviour.

    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

    January 24, 2012 at 8:31 am

    #1437721

  • RE: Differential backup

    Neither. Backups don't ever block DML activity (or DDL for that matter) on a database.

    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

    January 24, 2012 at 8:29 am

    #1437717

  • RE: blocking processes on a SQL Server instance

    Chapter 6 - http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    January 24, 2012 at 7:24 am

    #1437671

  • RE: Differential backup

    What effects are you asking about?

    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

    January 24, 2012 at 7:23 am

    #1437670

  • RE: SP- executed with more wait time and memory using

    Index definitions please.

    The first thing you can do for performance is remove those cursors and turn the deletes into a set-based delete. I couldn't see any reason for a cursor.

    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

    January 24, 2012 at 6:09 am

    #1437626

  • RE: SP- executed with more wait time and memory using

    Procedure text, table definitions and index definitions please.

    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

    January 24, 2012 at 2:29 am

    #1437517

  • RE: Is this memory configuration optimal ?

    Divine Flame (1/24/2012)

    Because even if we add up the minimum memory assigned to the instances it is 59 GB more than that we have on the server (48 GB). So...

    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

    January 24, 2012 at 1:36 am

    #1437496

  • RE: Transactions deleted in production and stage table only populating new data

    Sure, tonnes of ways to compare tables.

    There's an exe that's part of the SQL Server installation called TableDiff (http://msdn.microsoft.com/en-us/library/ms162843.aspx), if you have linked servers you could use EXCEPT, or OUTER...

    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

    January 24, 2012 at 1:33 am

    #1437495

Viewing 15 posts - 20,791 through 20,805 (of 49,552 total)