100% ved SQL2017

SFSSFS Posts: 1 New member
Hello World,

After we installed SQL 2017 we expirence that the restore performance is going down for SQL Backup. And the disk i going to 100% for almost the hole 10-15 min it takes to restore a 4-500MB logfile. We see that before SQL2017

This i how we do restore:

EXEC master..sqlbackup '-SQL "RESTORE LOG [Database] FROM DISK = ''\\FileServer\file_Log.sqb'' WITH STANDBY=''T:\\Database.sdf'', DISCONNECT_EXISTING"'

We are running version 9.1.6.257 which is the latest as far as I can see.

Any advice?
Tagged:

Answers

  • Hi SFS,

    Can you forward on your SQL Backup log file to [email protected] please so we can investigate this further.

    To find your log file open the SQL backup GUI, select the job in the activity history pane at the bottom and then select 'show log'
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.