Restore Wizard | 'Backup Content' page/screen not showing backups created days ago from a different LiteSpeed instance on another system (4257369)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Restore Wizard | 'Backup Content' page/screen not showing backups created days ago from a different LiteSpeed instance on another system
Description

In the Restore Wizard, 'Backup Content' page/screen, when we go to restore a database, on the 'Backup Content' screen, the "First Backup to Recover" field is saying "Database or device does not have a full backup".

So it is not showing us our list of backups. We had created many backups over the last few weeks.

The backups were created from a LiteSpeed instance on a different system. This database does not exist locally.
When we looked at another database on that same SQL Server, we could see many older backups of that database available to be restored.
Cause

If a backup does not exist in the backup history of that database on that server, as seen in that server's MSDB, then the backup will not be available for restore and will not show up as an option in the 'Backup Content'. There is a text note on the 'Specify Backup Source' screen/page that says "Note: Backup content will be read from database backup history"
It doesn't matter where the historical backups are stored, such as for example, many different backups all stored together on one shared drive. What matters is which LiteSpeed instance / SQL Server was the one that actually created the backup.

The TSQL in the 'Additional Information' section below, if you run that on this SQL Server's MSDB, you will see the same results that LiteSpeed returns. That TSQL is the same query that the LiteSpeed 'Restore Wizard' runs to populate the list of databases available for restore.

We have had a user who would like the Restore Wizard to query the LiteSpeed local database instead of the MSDB. LiteSpeed is querying SQL Server and since that database is new to SQL Server, it doesn't show any backups, even though they are there. That LiteSpeed instance should be looking at history for LiteSpeed to get its history of previous backups.

We have logged this as enhancement request LS-1117: "LiteSpeed query the LiteSpeed local for backup history when using the restore wizard".
Resolution

WORKAROUND 1

If the backup is stored on a different SQL server than the server upon which the backup had been created: On the 'Specify Backup Source' page/screen, click the dropdown or browse button to the right of the "restore from" | 'Database'| 'SQL server' field and specify that backup source to use for the restore. i.e. select a different 'Select SQL Server Instance' from which to pull data from, as shown in the attached screenshot.

WORKAROUND 2
If the backup is stored on a different storage disk (doesn't need to be a SQL Server) than the server upon which the backup had been created, you can select the backup manually/directly. i.e. on the "Specify Backup source" page/step of the Restore Wizard, for "Restore From", instead of choosing the "Database" radio button, choose "Device" radio button and then under that, choose 'Disk' radio button.
The next wizard screen you will now be on is "Select Backup Files". Here you can manually dig through the directory structure to find the location of whatever backup file(s) you would like to restore and and manually select that file(s).
STATUS

Waiting for possible implementation of enhancement request LS-1117 in a future release of LiteSpeed
Defect ID

LS-1117
Additional Information

on the server where you are restoring the database (not the server where the backup was taken unless they are the same), run the below query on MSDB: DECLARE @ver as int SET @ver = @@microsoftversion / 0x1000000 DECLARE @Srv sysname IF @ver < 8 SET @Srv = UPPER(@@ServerName) ELSE EXEC sp_executesql N'SET @SrvOut = UPPER(CAST(SERVERPROPERTY(''ServerName'') as sysname))', N'@SrvOut sysname OUTPUT', @SrvOut = @Srv OUTPUT SELECT backup_set_id, b.name as bname, b.server_name, database_name, position, first_lsn, last_lsn, checkpoint_lsn, database_backup_lsn, backup_start_date, backup_finish_date, backup_size, user_name, expiration_date, b.media_set_id, b.description as bdescription, b.type, m.description as mdescription, m.name as mname, f.logical_device_name, f.physical_device_name, f.device_type, f.mirror as mirror, b.is_copy_only AS IsCopyOnly FROM msdb.dbo.backupset b INNER JOIN msdb.dbo.backupmediaset m ON b.media_set_id = m.media_set_id INNER JOIN msdb.dbo.backupmediafamily f on m.media_set_id = f.media_set_id AND f.family_sequence_number = 1 WHERE database_name = N'content_2016_prd' /*AND lower(b.server_name) = lower(@@servername)*/ AND lower(b.server_name) = lower(@Srv) AND type = 'D' ORDER BY backup_start_date desc

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Restore Wizard | 'Backup Content' page/screen not showing backups created days ago from a different LiteSpeed instance on another system (4257369)

Title

Description

Cause

Resolution

Defect ID

Additional Information

Leave a Comment