Comments
Sort by recent activity
Thank you for investigating further.
It seems anything named aux. in Windows is reserved and can not be created.
You learn something new everyday! / comments
Thank you for investigating further.
It seems anything named aux. in Windows is reserved and can not be created.
You learn something new everyday!
Hi Jerry,
You cannot deactivate only SQL Backup but if you deactivate all products, reactivate again with SQL Compare, Data Compare etc it should activate all the products except SQL Backup.
You should then be able to use the SQL Backup activation on another machine.
Running the following command on all SQL Servers with SQL Backup installed will return their licensing information :
execute master..sqbutility 1021, @LicenseType OUTPUT, @Version OUTPUT, @SerialNumber OUTPUT, @DateInstalled OUTPUT, @DateFirstUsed OUTPUT, @RevokeErrorsv4 OUTPUT, @Warningsv5 OUTPUT;
The function takes no additional parameters, and returns seven values – an integer @LicenseType, which will be one of the following: @LicenseType Definition
0 No License – the trial period has expired.
1 Trial License (equivalent to Professional in features, but only valid for 14 days). Trial Extensions also fall in this category.
2 Standard License
3 Professional License
6 'Lite' License
I hope this helps. / comments
Hi Jerry,
You cannot deactivate only SQL Backup but if you deactivate all products, reactivate again with SQL Compare, Data Compare etc it should activate all the products except SQL Backup.
You sh...
Thank you for your post into the forum.
Unfortunately to deactivate SQL Backup an internet connection must be established. Without an internet connection our Activation Server will not be able to free up the activation.
I hope this helps. / comments
Thank you for your post into the forum.
Unfortunately to deactivate SQL Backup an internet connection must be established. Without an internet connection our Activation Server will not be able to ...
The ERASEFILES_REMOTE option is only available in the command line at this point.
More information can be found in the help file under :
The SQL Backup Toolkit>Toolkit Syntax>The BACKUP Command / comments
The ERASEFILES_REMOTE option is only available in the command line at this point.
More information can be found in the help file under :
The SQL Backup Toolkit>Toolkit Syntax>The BACKUP Command
Hi Steve,
Thank you for your post into the forum.
This issue has been brought to our attention previously but thank you for doing so again.
If you run into this problem again and do not wish to recreate your job you can do the following :
Close the SQL Backup GUI.
Edit the job step in SSMS or Enterprise Manager from the following :
BACKUP DATABASES EXCLUDE []
To :
BACKUP DATABASES [*]
Open the SQL Backup GUI and you should now be able to edit your job.
I hope this helps. / comments
Hi Steve,
Thank you for your post into the forum.
This issue has been brought to our attention previously but thank you for doing so again.
If you run into this problem again and do not wish to rec...
Hi Terrihawkins,
It looks as though you have not installed the SQL Backup Server Components.
If you navigate to your SQL Backup GUI installation folder, locate the file SQBServerSetup.exe and copy to/run it on your SQL Server the Server Components can then be installed using the wizard.
Once this is completed the server should be usable via the SQL Backup GUI.
Hope this helps. / comments
Hi Terrihawkins,
It looks as though you have not installed the SQL Backup Server Components.
If you navigate to your SQL Backup GUI installation folder, locate the file SQBServerSetup.exe and copy ...
Hi Bryan,
Thank you for your post into the forum.
I have created the following script which will restore the latest full backup of a database. The script will not find the backup file if it has been moved from the original primary location, it will also overwrite the existing database.
The script is as follows :
DECLARE @SQL VARCHAR(1000)
DECLARE @restorestring VARCHAR(1000)
DECLARE @exitcode INT
DECLARE @sqlerrorcode INT
SELECT @SQL = b.physical_device_name
FROM msdb..backupmediafamily b
WHERE b.physical_device_name = ( SELECT TOP 1
b.physical_device_name
FROM msdb..[backupset] a
INNER JOIN msdb..backupmediafamily b ON a.[media_set_id] = b.[media_set_id]
WHERE a.[database_name] = 'WidgetDevEmpty'
AND a.TYPE = 'D'
ORDER BY a.backup_start_date DESC
)
SET @restorestring = '-SQL "RESTORE DATABASE [WidgetDevEmpty] FROM DISK = '''
+ @SQL + ''' WITH RECOVERY, REPLACE" -E'
EXEC MASTER..sqlbackup @restorestring, @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF ( @exitcode <> 0 )
OR ( @sqlerrorcode <> 0 )
BEGIN
RAISERROR ( 'SQL Backup job failed with exitcode: %d SQL error code: %d',
16, 1, @exitcode, @sqlerrorcode )
END
You will need to swap the WidgetDevEmpty database with your database name, feel free to edit and adapt the script to your needs.
Please let me know if this is useful. / comments
Hi Bryan,
Thank you for your post into the forum.
I have created the following script which will restore the latest full backup of a database. The script will not find the backup file if it has be...
Hi Jeff,
Thank you for your post into the forums.
Unfortunately there is no way of selecting multiple databases when setting up log shipping using the SQL Backup GUI.
I believe it is possible to script the log shipping setup process. If you create a test log shipping scenario and script both create jobs using SQL Server Management Studio you will be able to see the syntax used to create the SQL Agent Jobs.
From here it should be possible to create a stored procedure taking the database name as a parameter to create the jobs.
Unfortunately I have not tried this myself but would be interested in seeing the script if you can get this working.
With reference to promoting the destination server, if you wish to keep this server as active and log ship back to the original source server, log shipping would need to be re-created.
If you wish to get back to your original setup once the source server has been recovered, you could re-seed the databases and use the existing jobs.
Once reseeded you should ensure no old transaction log files are present in the network share.
I hope this helps. / comments
Hi Jeff,
Thank you for your post into the forums.
Unfortunately there is no way of selecting multiple databases when setting up log shipping using the SQL Backup GUI.
I believe it is possible to sc...
Hi sugam,
Thank you for your forum post.
The following syntax can be used to perform a verification of a SQL Backup backup file :
EXECUTE master..sqlbackup N'-SQL "RESTORE VERIFYONLY FROM DISK = ''C:\Backup\pubs.sqb''"'
Hope this helps. / comments
Hi sugam,
Thank you for your forum post.
The following syntax can be used to perform a verification of a SQL Backup backup file :
EXECUTE master..sqlbackup N'-SQL "RESTORE VERIFYONLY FROM DISK = ''...
Hi Chris,
Thus far the build has only been needed for machines running Windows Server 2008 and SQL Server 2008 CTP/RC0.
Hope this helps / comments
Hi Chris,
Thus far the build has only been needed for machines running Windows Server 2008 and SQL Server 2008 CTP/RC0.
Hope this helps