Forum Replies Created

Viewing 15 posts - 61 through 75 (of 342 total)

  • RE: Log backup failing due to FlushFileBuffers

    janet.gillespie (2/15/2011)I also agree that the local copying and then moving is just extra work and would not change network issues.

    The main objective is to get a backup made consistently....

    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: Restore of DB without the empty space bloat

    Red Gate's SQL Virtual Restore[/url] is another option you could consider. It allows you to mount a database from a backup file, without needing to actually perform a restore,...

    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: Log backup failing due to FlushFileBuffers

    I would guess that you have a flaky connection to your remote share, hence why SQL Server was unable to write the backup data successfully.

    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: Can I restore part of the database to a mapped drive due to disk space issue ?

    Using SQL Virtual Restore[/url] may be another option if space is limited. Basically, you can mount live databases from backup sets without actually having to restore the original data...

    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 from server to locahard

    I believe the OP knew that he would need to provide a network share path in order to save the backups to the remote share. In his original post,...

    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 from server to locahard

    You can back up to network shares, but the SQL Server service startup account needs to have read/write rights to that network share.

    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 time

    Is there a way to find out who's doing the backup of that database.

    You could set up a Profiler trace and filter on all commands containing the BACKUP command. ...

    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: NEED HELP ASAP!!! Cannot shrink transaction log for prod db!!!

    What's the value of the 'log_reuse_wait_desc' column in the sys.databases table for that database?

    Thanks.

    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 2008 Express edition

    With regards to SQL Server 2008 Express, see here.

    There is no explicit limitation on the no. of simultaneous users, but you would need to work within the limitations of 1...

    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 2005 Cluster Backup Problem

    Ok, you're obviously not using SQL Backup[/url], but the native SQL Server BACKUP command.

    It looks like there are multiple instances of the job all trying to back up the 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: SQL 2005 Cluster Backup Problem

    Could you please post the contents of the SQL Backup log for that backup process? The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red...

    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 2005 Cluster Backup Problem

    Problem with SQL Backup.

    When you say 'SQL Backup', do you mean the product by Red Gate Software, or SQL Server backups in general?

    Thanks.

    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: Differential backup - Source Information

    Here's an interesting article[/url] on predicting the size of a differential backup.

    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: Why is this backup taking so long? Why is the file so big?

    Try some of the timing suggestions in this link: Speeding up backups. Should tell you if the problem lies with reading or writing the backup data (or both).

    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

    Grant Fritchey (12/30/2010)


    Just so I can learn better, do you have any white papers or deeper documentation into precisely that issue available? I've got a little best-practice article I want...

    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 - 61 through 75 (of 342 total)