Comments
Sort by recent activity
Hi Edgardo,
What version of the SQL Backup GUI/Server Components do you have installed?
You can check the GUI version by using Help>About.
You can check the Server Components version by right clicking it in the GUI and selecting Properties.
I can restore a database with multiple file groups to different locations using the SQL Backup 5.3 GUI.
You could also use the extended stored procedures to restore manually : EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [Filegroup] FROM DISK = ''C:\Backup\FULL_SQL2005_Filegroup.sqb'' WITH RECOVERY, MOVE ''Test1dat1'' TO ''C:\Backups\Filegroup2Test1.ndf'', MOVE ''Test1dat2'' TO ''C:\Backup\Filegroup2Test2.ndf'', MOVE ''test1dat3'' TO ''D:\Data\Filegroup2Test3.ndf'', MOVE ''test1dat4'' TO ''D:\Data\Filegroup2Test4.ndf'', MOVE ''FileGroupTest_log'' TO ''D:\Log\Filegroup2Test_log.LDF''"'
I hope this helps, / comments
Hi Edgardo,
What version of the SQL Backup GUI/Server Components do you have installed?
You can check the GUI version by using Help>About.
You can check the Server Components version by right click...
Hi Gladiatr,
It sounds like you have a Lite license activated on your machine, a Professional license is required to use SQL Backup on 64 bit servers.
Please can you open the SQL Backup GUI, right click your server and select properties.
What is listed as the Edition in the last entry? / comments
Hi Gladiatr,
It sounds like you have a Lite license activated on your machine, a Professional license is required to use SQL Backup on 64 bit servers.
Please can you open the SQL Backup GUI, right ...
Hi Cameron,
Yes log shipping can be setup to ship from a SQL 2000 database to a SQL 2005 database, there are a couple of points to note though :
You must set the SQL 2005 database to be in NO RECOVERY mode, the WITH STANDBY option will not work because the database must be upgraded to SQL 2005 before it can be queried.
SQL Server performs this upgrade when the Database is brought Online.
Because SQL Server performs these upgrade steps when bringing the database online, you should be aware that it might take longer to bring the database online that a straight 2000 -> 2000 etc log shipping scenario.
You should factor this into any disaster recovery plans/response times you may have.
I hope this helps. / comments
Hi Cameron,
Yes log shipping can be setup to ship from a SQL 2000 database to a SQL 2005 database, there are a couple of points to note though :
You must set the SQL 2005 database to be in NO RECOV...
Hi Boka,
The only other thing I can think of would be to uninstall and reinstall the Server Components. When installing you can specify the location of the data store.
You can specify the Data location on Step 6 of the wizard when performing a cluster aware installation.
Thanks, / comments
Hi Boka,
The only other thing I can think of would be to uninstall and reinstall the Server Components. When installing you can specify the location of the data store.
You can specify the Data loc...
Hi,
Did you change the registry on Both nodes and then add the Registry Replication in again?
I've tested several times and the settings are holding. / comments
Hi,
Did you change the registry on Both nodes and then add the Registry Replication in again?
I've tested several times and the settings are holding.
Hi Boka,
I've had a mess around with it and found out the problem.
After taking the SQL Backup Agent Resource offline you need to Select Properties and the Registry Replication tab.
On this tab remove the Registry entry for BackupSettingsGlobal\<instance name> (You might want to copy this first to add it again later).
Now set your Data location in the registry of both nodes.
Go back to your Registry Replication and add the BackupSettingsGlobal\<instance name> entry.
Now bring the resource online and the change should stick.
I hope this helps. / comments
Hi Boka,
I've had a mess around with it and found out the problem.
After taking the SQL Backup Agent Resource offline you need to Select Properties and the Registry Replication tab.
On this tab rem...
Hi Boka,
I apologise for the belated reply.
The SQL Backup 5.3 Cluster Aware installation should allow you to set the location for the datapath.
To change it, could you please take the SQL Backup resource offline.
Make sure the SQL Backup Agent Service is stopped on all nodes.
Change reg entry (HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>) with new value on the Active Node.
Start the SQL Backup Agent Service on the Active Node.
Check that the change is correct and the data.sdf file is located in the new location.
Bring the resource online.
When you installed SQL Backup to your cluster, did you use the Cluster Aware Installation or do a manual Installation as per instructions on our website?
Thanks, / comments
Hi Boka,
I apologise for the belated reply.
The SQL Backup 5.3 Cluster Aware installation should allow you to set the location for the datapath.
To change it, could you please take the SQL Backup r...
Hi,
Thank you for your post into the forum.
This is something that has come up before, could you please see the following forum post : http://www.red-gate.com/MessageBoard/vi ... hp?p=19659
The information given by Michelle is still relevant.
I hope this helps, / comments
Hi,
Thank you for your post into the forum.
This is something that has come up before, could you please see the following forum post :http://www.red-gate.com/MessageBoard/vi ... hp?p=19659
The info...
Hi,
You have a couple of options for restoring the backups to your machine.
The first would be to install the 14 day trial version of SQL Backup on your machine and use the extended stored procedure/GUI to restore it. Obviously if you need to regularly restore a backup you would end up needing a licence.
The second option is to convert your backup file to Native format and then restore the files to your second SQL Server in the usual way.
The command line version of the converter is called sqb2mtf and is located in your SQL Backup GUI installation folder.
There is also a GUI Version available from : http://labs.red-gate.com/index.php/SQL_ ... _Converter
You can also use the extended stored procedures to convert the file with the following :
exec master..sqlbackup N'-SQL "CONVERT ''C:\Northwind.sqb'' TO ''C:\Northwind.bak''"'
I hope this helps. / comments
Hi,
You have a couple of options for restoring the backups to your machine.
The first would be to install the 14 day trial version of SQL Backup on your machine and use the extended stored procedur...
We have an internal build which addresses this issue.
Please note that this is an internal build and has not undergone our full regression testing.
We advise running it in a test environment before implementing on production systems.
Please contact support@red-gate.com to obtain this patch.
Thanks, / comments
We have an internal build which addresses this issue.
Please note that this is an internal build and has not undergone our full regression testing.
We advise running it in a test environment before...