Posts
Sort by recent activity
Used up our SQL Backup licenses
We've bought a bunch of SQL Backup licenses, but we forgot to deactivate when upgrading servers side by side. After the old servers' OS gone, we found we had lost opportunities to deactivate them. ...
Doesn't work when comparing TB live DB with its backup file
I don't know if the database is too big. When I compared them, SQL Data compare 7.1 just kept proceeding without a response until I cancelled it one day later.
Neo
Cannot catch the error when the backup file is in use
I have my stored procedures based on dbo.sqlbackup to restore databases, and they work fine except during backup files are in use.
I cannot catch the error because it returns a text message instead...
Got an error when trying to use "Restore headeronly"
declare @sql varchar(max)
set @sql = '-SQL "Restore headeronly from disk = ''\\BackupServer\BackupA\DB_20071201_013002.sqb''"'
exec master.dbo.sqlbackup @...
exitcode 0
sqlerrorcode 0
filename001 ...