Forum Replies Created

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

  • RE: Importing Blobs from a MySQL Database and Export Them

    SQL Image Viewer can export blobs from MySQL and most other popular database servers, and even files embedded in OLE Object fields.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: How Long Before Your Database Runs Out of Space?

    Nice informative article. We have a tool that performs similar database growth and size data collection and analysis, and also raise alerts when certain limits are reached e.g.

    - when...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: SQL Server Performance Problems

    That should rule out backups as a source of disk contention then.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: SQL Server Performance Problems

    kiffab (12/19/2012)


    The top wait on live always seems to be this:

    wait_typewait_time_ms

    MSQL_XP26126343

    I believe this is due to SQL waiting on extended stored procs to complete yet I can't find a process...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Difference in Size of SQL Server 2008 R2 backup on Local disk and on Remote Network Share

    As Lowell suggested, your backup files might be containing multiple backup sets. See here for details.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Backup to a fileshare slow down gradually for large databases

    Perhaps you could try copying a large file to the same network share, and observe if the same behaviour is exhibited. If it is, then it is probable that...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: backup and restore

    This topic (Backup Reads and Writes) and its associated subtopics should shed some light on the backup/restore process and IO requirements, including some simple tests you can run to determine...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Database Backup Issue

    You could use Process Explorer from Sysinternals to find out which application is using that backup file. Or you could use the command line application 'handle.exe' (also from Sysinternals).

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Do DBA admins rather restore whole databases then restoring individual tables?

    dbdmora (8/4/2011)


    What if you have a database that is over 100 gigs and a developer needs an object restored or QA, how do you guys handle that?

    What we used to...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Do DBA admins rather restore whole databases then restoring individual tables?

    You should be aware that some 3rd party tools that are able to recover individual tables from a backup set may give you different data than if the entire database...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Data base Integrity MSSQL 2005

    Ninja's_RGR'us (8/2/2011)


    Ah darn. Ok, so how often does it happen? I've never heard of bugs in that arena. Have you?

    Personally, I have not seen any bugs...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Data base Integrity MSSQL 2005

    Ninja's_RGR'us (8/1/2011)


    I'm not sure we're talking the same thing.

    I was not reffering to goes bad after being good.

    I was talking about being bad right after taking it... like failing verification...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Data base Integrity MSSQL 2005

    Ninja's_RGR'us (7/29/2011)What do you do if that tlog backup doesn't pass verification right after you take it? How can you undo / redo that whitout stopping the prod db?

    If...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Data base Integrity MSSQL 2005

    Ninja's_RGR'us (7/27/2011)


    So bottom line Ray, if you take backup with checksum, after a successful checkdb(), then run verify (which passes) and then successfully do a test restore you can't possibly...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • RE: Data base Integrity MSSQL 2005

    Both products (SQL DBA Bundle and SQL Verify) approach verification of backup sets differently.

    From the DBA bundle, you can use SQL Backup or SQL Hyperbac to restore the backup sets...

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

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