Comments
Sort by recent activity
thanks.
Could you tell me what the speed column is? I'm curious as of the things I'm looking at is backup throughput times. / comments
thanks.
Could you tell me what the speed column is? I'm curious as of the things I'm looking at is backup throughput times.
Cheers. The move worked but I can't restore the latest backup from the 3 individual backups that are in the folder.
e.g.
this works....
EXEC master..sqlbackup '-sql "RESTORE DATABASE Logging_LiveCopy
FROM DISK = [F:\SQL BACKUP\Logging\Logging_FULL_20120107_200002.sqb] WITH REPLACE,
MOVE ''Logging'' TO [E:\SQL MDF\Logging_LiveCopy.mdf],
MOVE ''Logging_Log'' TO [D:\SQL LDF\Logging_LiveCopy_Log.ldf]"'
GO
this doesn't....
EXEC master..sqlbackup '-sql "RESTORE DATABASE Logging_LiveCopy
FROM DISK = [F:\SQL BACKUP\Logging\Logging*.sqb] LATEST_FULL WITH REPLACE,
MOVE ''Logging'' TO [E:\SQL MDF\Logging_LiveCopy.mdf],
MOVE ''Logging_Log'' TO [D:\SQL LDF\Logging_LiveCopy_Log.ldf]"'
returns....
Error 507: No valid backup sets found from provided folder(s).
The only thing I can think of why this doesn't work is because although I'm taking a full back up of the same database to the same folder each night, this does not
mean it is actually a backup "set", so it fails.
Thanks / comments
Cheers. The move worked but I can't restore the latest backup from the 3 individual backups that are in the folder.
e.g.
this works....
EXEC master..sqlbackup '-sql "RESTORE DATABASE Logging_LiveCo...
That kind of doesn't make sense as I know one of the files is a full backup that can be restored
If I delete the other two and leave just the one full backup that I have restored by naming explicitly it still wont restore it using the wildcard? / comments
That kind of doesn't make sense as I know one of the files is a full backup that can be restored
If I delete the other two and leave just the one full backup that I have restored by naming explicit...
Oh I see. If using the wildcard I need to tell it what the source is.
EXEC master..sqlbackup '-sql "RESTORE DATABASE Logging_LiveCopy
FROM DISK = [F:\SQL BACKUP\Logging\*.sqb] SOURCE = ''Logging''LATEST_FULL WITH REPLACE,
MOVE ''Logging'' TO [E:\SQL MDF\Logging_LiveCopy.mdf],
MOVE ''Logging_Log'' TO [D:\SQL LDF\Logging_LiveCopy_Log.ldf]"' / comments
Oh I see. If using the wildcard I need to tell it what the source is.
EXEC master..sqlbackup '-sql "RESTORE DATABASE Logging_LiveCopy
FROM DISK = [F:\SQL BACKUP\Logging\*.sqb] SOURCE = ''Logging''L...
2.1 so that'll explain it, I'll upgrade it and keep my eye on it.
Thanks / comments
2.1 so that'll explain it, I'll upgrade it and keep my eye on it.
Thanks
I've discovered this problem whilst testing sql monitor.
I'm only monitoring 3 servers with only a one day retention period.
This table ended up with 30 million rows @ 18Gb after a few weeks.
Problem is there's no option to purge it on the front-end, I just had to set up a SQL agent job to truncate it each night / comments
I've discovered this problem whilst testing sql monitor.
I'm only monitoring 3 servers with only a one day retention period.
This table ended up with 30 million rows @ 18Gb after a few weeks.
Probl...
I would say it's probably the wording that slightly out in this case.
I dont work for RedGate but I'm guessing until the check that fires the alert is run, it would not read the table, so if you created a database before the check runs it won't know that a backup doesn't exist, simple.
Anyway wouldn't you find it really annoying if it immediately warned you that there was no backup as soon as you created a database? I'd end up turning this alert off it it did this.
HTH / comments
I would say it's probably the wording that slightly out in this case.
I dont work for RedGate but I'm guessing until the check that fires the alert is run, it would not read the table, so if you cr...