Activity overview
Latest activity by zynrg
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. ...
I see. That means each time when SQL Data Compare 7 gets involved in backup comparison, it actually extracts all the content of backups and then compares them. If so, it's absolutely convenient for small databases, but for big databases, I'd rather restore them first and then compare them because it takes the same time and is more flexible.
Are there any means that we can just grab part of backups and get it fast? [image] / comments
I see. That means each time when SQL Data Compare 7 gets involved in backup comparison, it actually extracts all the content of backups and then compares them. If so, it's absolutely convenient for...
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
Hi Petey,
You are right. I will catch the exit code 580 and deal with it specificly.
Thanks, [image]
Neo / comments
Hi Petey,
You are right. I will catch the exit code 580 and deal with it specificly.
Thanks,
Neo
Hi Petey,
Thanks for your quick answer.
I can catch the exit code, but the exit code is 500 (General SQL Backup error). It doesn't indicate anything.
Generally, I use a variable table to catch errors, such as
Insert into @ErrorTable EXEC master..sqlbackup '-sql "..."', @exitcode OUTPUT, @sqlerrorcode OUTPUT
It works perfectly; however, it doesn't return a dataset only when the backup file is used by another process.
Is there any way I can catch the error message?
Neo / comments
Hi Petey,
Thanks for your quick answer.
I can catch the exit code, but the exit code is 500 (General SQL Backup error). It doesn't indicate anything.
Generally, I use a variable table to catch erro...
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...
Hey Petey,
That's exactly what I want, "WITH SINGLERESULTSET". Thank you a lot for your quick reponses.
BTW, probably, I'm the first one who want to use this funcationality in programming. [image]
It's easy for human beings to read but hard for machines, even I use "WITH SINGLERESULTSET", it still need some further process to deal with the info. Anyway, it will be great, if you could add a parameter to let people specify the result format. That's only my personal suggestion. [image]
Thanks again.
Neo / comments
Hey Petey,
That's exactly what I want, "WITH SINGLERESULTSET". Thank you a lot for your quick reponses.
BTW, probably, I'm the first one who want to use this funcationality in programming.
It's ea...
Yes, exactly, but it's entirely different from the sqlserver's result format.
If you use FILELISTONLY, you can get the same result as sqlserver's.
Actually, I'm using "Insert into @TempTable Exec(@Sql)", but if the result returns two tables with different column amount, I could not get the info. So far, I cannot figure out how to get these info in my stored procedure.
Why you design it like this? Or give me some suggestions.
Thanks, / comments
Yes, exactly, but it's entirely different from the sqlserver's result format.
If you use FILELISTONLY, you can get the same result as sqlserver's.
Actually, I'm using "Insert into @TempTable Exec(@...
Hey Petey,
You may download this file and try it. http://pickup.mofile.com/6330744401386462
declare @sql varchar(max)
set @sql = '-SQL "Restore headeronly from disk = ''E:\Backup_A\FULL_(local)_model_20071203_234217.sqb''"'
exec master.dbo.sqlbackup @...
[/url] / comments
Hey Petey,
You may download this file and try it.http://pickup.mofile.com/6330744401386462
declare @sql varchar(max)
set @sql = '-SQL "Restore headeronly from disk = ''E:\Backup_A\FULL_(local)_mode...
Hey Petey,
Here is the resutl:
12/5/2007 11:32:22 AM Not encrypted
12/5/2007 11:32:22 AM Single device file
12/5/2007 11:32:22 AM Compression level: 1
12/5/2007 11:32:22 AM File size: 664,576
12/5/2007 11:32:23 AM File read stopped at position: 664,233
12/5/2007 11:32:23 AM Remaining: 343
12/5/2007 11:32:23 AM Validating remaining bytes...
12/5/2007 11:32:23 AM File appears to be valid
12/5/2007 11:32:23 AM File read ended at position: 664,576
Did you try HEADERONLY on your computers? Could you successfully run it?
Thanks, / comments
Hey Petey,
Here is the resutl:
12/5/2007 11:32:22 AM Not encrypted
12/5/2007 11:32:22 AM Single device file
12/5/2007 11:32:22 AM Compression level: 1
12/5/2007 11:32:22 AM File size: 664,5...