100% ved SQL2017
SFS
Posts: 1 New member
in SQL Backup
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?
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
Can you forward on your SQL Backup log file to support@red-gate.com 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'
Dan Bainbridge
Product Support Engineer | Redgate Software