Forum Replies Created

Viewing 15 posts - 301 through 315 (of 342 total)

  • RE: error on creating backup device

    To quickly check if you have rights, run xp_cmdshell 'dir \\remotesharedfolder'.

    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 log backup without database backup file

    Did you actually manage to restore the cold backups, and apply trx logs to the database after that?  As regards the space constraints, have a look at our product, MiniSQLBackup. ...

    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 log backup without database backup file

    I do not think it's possible to restore log files to a database you restore from a cold backup.

    Firstly, the database needs to be in standby/restoring mode if you 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.

  • RE: Error when restoring database

    Are you able to use the newly restored database?  If you run DBCC CHECKDB, do you find any errors?  Check this link to see if it's applicable to 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: VDI questions!

    That's entirely up to you to implement on the client side.  SQL Server will just provide you the backup data in the form of memory buffers.  You decide what 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: Multiple Backups from multiple instances

    If it even fails when running manually, I think there is definitely something wrong with the remote folder permissions.  See if you can query the contents of the remote folders...

    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 questions!

    You need not concern yourself with the server side.  On the Overview page, note the phrase:

    The server side interface is described for informational purposes only.  This interface is used exclusively by...

    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 LOG from different location being denied

    Did you change the location of the data/log files on the originating server between the time you performed the initial full database backup and the subsequent log backups?

    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: Multiple Backups from multiple instances

    Have you tried performing a backup using Query Analyzer first, to the remote destination folders?

    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: Multiple Backups from multiple instances

    I take it you are trying to backup to a remote folder, and that you are encountering errors when trying to perform the backup?  Ensure that the SQL Server service...

    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: Multiple Backups from multiple instances

    Could you pls post the error messages you are receiving?

    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 & Third party backup software

    For anyone that's interested, I've described in a little more detail the Microsoft VDI for third party backup software vendors here.

    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: Multiple Database Backups

    INSERT, UPDATE, or DELETE statements are allowed during a backup operation.  One suggestion to ensure consistency across databases for the backups is to set all databases to single user mode...

    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 database when it is in use ?

    In Inside SQL Server 2000, the section on backups implies that the backup data is the state of the database when the backup ends, not at the beginning as that stated...

    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 shipping problem - can not use recent backup

    I'm guessing it's a rights problem.  In Query Analyzer, what is the result when you run this:

    master..xp_cmdshell 'dir \\sourceserver\logshare'

    If you get the 'Access denied' message, change the service startup...

    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 - 301 through 315 (of 342 total)