Activity overview
Latest activity by willgart
oohh...
I have just discover a way to simplify my script...
Because the BKP folder contains ONLY 1 full backup and a lot of log backups, I can use this statement:
RESTORE DATABASE MyDB FROM DISK = ''e:\bkp\FULL*.sqb'' WITH NORECOVERY, REPLACE, DISCONNECT_EXISTING
the FULL*.SQB returns only 1 file and so the full backup command doesn't required an explicit full file name. / comments
oohh...
I have just discover a way to simplify my script...
Because the BKP folder contains ONLY 1 full backup and a lot of log backups, I can use this statement:
RESTORE DATABASE MyDB FROM DISK = ...
forsure, I have this:
FULL_(local)_MyBD_20100831_200000.sqb
LOG_MyDB_20100831220000.sqb
...
more than 20 backup Log files
Doing an explicit restore of the FULL_(local)_MyBD_20100831_200000.sqb file, and then doing a restore log e:\ods\log*.sqb
works fine, all the log files are processed.
I have created a script using the SQBHeaderOnly command (which returns all the file name matching my criteria) to identify the name of the latest full backup file, and then my script use this file name to do the restore as describe just above.
This produce the same result as the LATEST_FULL option.
Little complicated, But this works. / comments
forsure, I have this:
FULL_(local)_MyBD_20100831_200000.sqb
LOG_MyDB_20100831220000.sqb
...
more than 20 backup Log files
Doing an explicit restore of the FULL_(local)_MyBD_20100831_200000.sqb file...
Yes, I try using the same DB name, but doesn't works.
and I install the latest release (1016), but doesn't work too
with the version 1015 , the SQL Agent service failed to start. / comments
Yes, I try using the same DB name, but doesn't works.
and I install the latest release (1016), but doesn't work too
with the version 1015 , the SQL Agent service failed to start.
LATEST_FULL or LATEST_ALL doesn't works for me.
I'm trying to restore on a different server and red gate says:
Error 507: No valid backup sets found from provided folder(s).
here the command:
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [dbname] FROM DISK = [e:\bkp\*.sqb] LATEST_ALL WITH RECOVERY, REPLACE, DISCONNECT_EXISTING"'
I have updated the binaries files to the .1001 version
and I continue to have the same error.
Apparently this works if the backup was made on the same server.
Any idea why? / comments
LATEST_FULL or LATEST_ALL doesn't works for me.
I'm trying to restore on a different server and red gate says:
Error 507: No valid backup sets found from provided folder(s).
here the command:
EXECU...
ingoring cross database differences?
Hi,
how I can ignore differences related to a cross database query?
my source query is:
select ... from DB1.dbo.Table1 inner join dbo.Table2
and the destination is:
select ... from OTHERDB1.dbo.Tab...