Activity overview
Latest activity by Thrall
Either I am missing something or it is odd behavior. But I try to do a log restore with redgate and it seems that with log restores that redgate does not support the "MOVE" native command with sql but it does support it with database restore?
Is this true? If so how do you provide the same funtionality without the move command? MOVETO seems to have issues if there are other ldfs in the folder. / comments
Either I am missing something or it is odd behavior. But I try to do a log restore with redgate and it seems that with log restores that redgate does not support the "MOVE" native command with sql...
Restore log error
Here is my code:
DECLARE @RestoreCommand VARCHAR(1000)
SET @RestoreCommand = N'-SQL "RESTORE LOG [MSN_Doc]
FROM DISK = ''c:\filename.sqb''
WITH MOVETO = ''D:\SQL_Data\''"'
PRINT @RestoreCommand
EXE...
The box that I have run the naive restore and redgate restore and litespeed restore on is an old box but the results of redgate restore is slower. It is a pentium III 1.26 GHZ, 2 GB RAM.
File size:
4,952,697 KB to be copy from network share c$ to network share d$ took 14min. / comments
The box that I have run the naive restore and redgate restore and litespeed restore on is an old box but the results of redgate restore is slower. It is a pentium III 1.26 GHZ, 2 GB RAM.
File size...
Slow restore Performance
I am having issues with long running restores. I have even restored locally and across the network and both restores are very slow, almost at the speed of the naïve restore of sql server 2000. ...