Forum Replies Created

Viewing 15 posts - 76 through 90 (of 342 total)

  • RE: Backup

    Agree with Grant re. the need to actually restore from a database backup to ensure it's recoverable.

    RESTORE VERIFYONLY is fairly useless (with regards to data integrity in the backup set)...

    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: Drive C: filled during last full backup to drive D:

    A backup of a database does not need create a temporary file anywhere. SQL Server writes the backup data directly to disk, even if it was to a network...

    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 Backup starting taking 4x as long to run.. Just starting happening overnight..

    Try the suggestions in this article and its sub-articles. Provides some tests you could run.

    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: Restoring Backup -Size Issue

    When you restore a database from a backup set, the size of the data files and transaction log files will be identical to that of the database at the time...

    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 failuer with error 3132.

    We take full backup of the db's daily and all of a sudden we start seeing this error for last 3 days for one particular db. Nothing has changed and...

    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 failuer with error 3132.

    Are you backing up to an existing file? That's probably the case, and the existing file contains a backup set that was split across 2 files. If you...

    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 to protect your SQL 2005 Backups

    Using the PASSWORD option in SQL Server backups only require that you be able to supply the same password during restore operations. It does not encrypt the data in...

    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: VDI

    With regards to the errors in the event log, it appears that the Litespeed backup process terminated the backup operation. I would suggest looking for any logs that Litespeed...

    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: VDI

    sql_lock (11/2/2010)


    You could try simulating what your 3rd party product with the MS VDI simulator

    http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/27/sql-server-backup-simulator.aspx?

    The credit has to go to @andrew Kelly for his blog post last week..

    http://sqlblog.com/blogs/andrew_kelly/archive/2010/10/28/sql-server-backup-simulator.aspx

    NOTE: Read the...

    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: VDI

    It looks like the Litespeed backup process aborted the backup.

    As mentioned by Pradeep, look in the SQL Server error logs to check if there are more informative error messages in...

    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: Create a policy to avoid backups withou copy_only option

    For example, from FULL BAKCUP A to FULL BACKUP B, we have a log chain. If you issue a FULL backup C without COPY_ONLY between A and B, then, you...

    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 in other machine

    Have you manually check if you are able to read/write to the network share, perhaps using Windows Explorer, when logged on as the same account as that used by your...

    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: Find/Analyze bad statistics of entire db

    it says if the estimated number of rows are very different from the actual number of rows then it means there are bad statistics on the database.

    For large tables, SQL...

    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 Stripping

    Here's something I wrote some time back on improving backup speed: Speeding up backups

    Hope this helps some.

    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 Backup across network - non domain

    Have you tried creating the same user account, with the same passwords, on both machines, and use that account as the SQL Server Agent service startup account?

    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 - 76 through 90 (of 342 total)