Comments
Sort by recent activity
Which version of SQL Backup are you running?
Thanks,
- James / comments
Which version of SQL Backup are you running?
Thanks,
- James
You can find them under Troubleshooting->Errors in the SQL Backup manual.
SQL Server also gives its own set of errors which are reported through us if SQL Server has a problem we cannot detect first (IE people still using the database/database is suspect etc).
- James / comments
You can find them under Troubleshooting->Errors in the SQL Backup manual.
SQL Server also gives its own set of errors which are reported through us if SQL Server has a problem we cannot detect firs...
Hi,
Could you possibly run the following and let me have a copy of the results for the databases involved:
SELECT * FROM master..sysaltfiles
Could you do this on both servers involved as well. If you can either post the results or email them to me at james<dot>moore <at> red-gate <dot>com and we will try and get this issue resolved for you.
For some reason we are not picking up on the logical file names of the database in this case which is causing the initial FULL restore to fail, the UI uses sysaltfiles to get this information from the Servers.
Additionally if you need more time to complete your trial please contact sales@red-gate.com and they should be able to provide you with a trial extension.
Thanks,
- James / comments
Hi,
Could you possibly run the following and let me have a copy of the results for the databases involved:
SELECT * FROM master..sysaltfiles
Could you do this on both servers involved as well. If y...
Hi there,
Could you run SQL Profiler against your destination server while trying to do the restore at the end of the log shipping wizard and let me know the actual restore command used? You can email it to me at james<dot>moore<at>red-gate<dot>com.
Many thanks,
- James / comments
Hi there,
Could you run SQL Profiler against your destination server while trying to do the restore at the end of the log shipping wizard and let me know the actual restore command used? You can em...
Scott,
For various reasons we cache various data on your local disk, this is under (in windows xp) c:\documents and settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\ there will be one or more sub directories under here containing a file called localdatacache.dat and serveral other numbered files, make sure you close the UI then delete these and you should see the correct history appear in the UI.
For those who are stuggling with this issue please clear these files, check how much backup history you have on your server and get rid of any you dont need (the UI should be quite happy to handle serveral million records).
Register the server then wait for data to appear on the timeline for that server, I would expect to see reasonably high CPU/IO usage before data appears on the timeline for the server, this will take a few minutes if there is a large amount of backup history, once data is on the timeline you should not see this sort of performance hit again - it only happens when you initially register the server.
Let me know if you get continued poor performance after the initial hit or if the UI is unusable. We have spent a lot of time trying to make sure that SQL Backup 5 scales well so I would be interested to hear from anyone who has performance problems.
- James / comments
Scott,
For various reasons we cache various data on your local disk, this is under (in windows xp) c:\documents and settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\ there w...
Hi there,
This is probably due to the size of your backup history, can I suggest you take a look at running sp_delete_backuphistory (http://msdn2.microsoft.com/en-us/library/ms188328.aspx) with an appropraite value and additionally configure SQL Backup (in the options dialog) to do this as well - IE keep all backup history for just 30 days - keeping an excessive amount of backup history will slow down both Native and SQL Backup backups as well as wasting disk space on your server as updating the MSDB tables starts to take a long time and Microsoft do not provide a good set of Indexes over these tables.
- James / comments
Hi there,
This is probably due to the size of your backup history, can I suggest you take a look at running sp_delete_backuphistory (http://msdn2.microsoft.com/en-us/library/ms188328.aspx) with an ...
Hi Bryant,
Reporting uses Linked Servers to pull the data back off the remote servers - can you check the configuration in SQL Server Management studio of your linked servers and then try and address them from your source server directly when logged in via managmeent studio - you might need to tweak the impersonated login details for each of the linked servers - especially if using SQL Server Authentication rather than SSPI based authentication.
- James / comments
Hi Bryant,
Reporting uses Linked Servers to pull the data back off the remote servers - can you check the configuration in SQL Server Management studio of your linked servers and then try and addre...
Ahh Randy,
Sorry was trying to rack my brains as to where this error message comes from -
I know what is causing this - if you right click on the item in the backup history and choose restore if another backup has been taken more recently to the same location then the intelli restore will persume the file which you are trying to restore has been overwritten by the later backup.
This can be worked around by opening the restore wizard and choosing "restore from file" and browsing the the file explictily - if the intelli restore - ie the grid on the first page of the restore wizard is not showing the most recent backups to each location for the database then could you let me know and I will look into it.
Hope this helps,
- James / comments
Ahh Randy,
Sorry was trying to rack my brains as to where this error message comes from -
I know what is causing this - if you right click on the item in the backup history and choose restore if an...
Hi Bill,
A lite license will allow you to restore a 256 bit encrypted backup - contact the sales guys if you would like a test lite license and I'm sure they will be able to help you out,
Regards,
- James / comments
Hi Bill,
A lite license will allow you to restore a 256 bit encrypted backup - contact the sales guys if you would like a test lite license and I'm sure they will be able to help you out,
Regards,
...
Randy,
Are you attempting the restore via the GUI or the xproc directly? Who are you talking to in the office?
- James / comments
Randy,
Are you attempting the restore via the GUI or the xproc directly? Who are you talking to in the office?
- James