How can we help you today? How can we help you today?
MartinH
Activity overview Badges (0) Posts (33) Comments (38)

Comments

Sort by recent activity
Yes, that was the trouble. Obvious when you think about it :-) Thanks very much, MartinH. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore on a different server
Yes, that was the trouble. Obvious when you think about it :-) Thanks very much, MartinH.
0 votes
Hi Brian: Brian Donahue wrote: Hi Martin, Keep in mind you'll need the Professional version of SQL Backup to have more servers appear in the dropdown, plus you'll need to have the server registered in the SQL Backup console as well. I have just purchased the Professional version and install the key as well as activating the product. I have also done a 'Install/upgrade server components on the remote machine'. I had to use the 'Make necessary changes via sp_configue' option, but this seemed to work fine. Unfortunately, still only one server appears in the list. Regards, MartinH. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore on a different server
Hi Brian: Brian Donahue wrote: Hi Martin, Keep in mind you'll need the Professional version of SQL Backup to have more servers appear in the dropdown, plus you'll need to have the server registere...
0 votes
Jessica: Thanks for the information, that help me a lot and I have managed to identify the obsolete files and manually remove them. It might be worth including a utility to do this cleanup in a future version, as I'm sure many users could benefit from it. Once again, thanks for your detailed help. Martin. / comments
  1. Community
  2. SmartAssembly
  3. Cleanup samap files
Jessica: Thanks for the information, that help me a lot and I have managed to identify the obsolete files and manually remove them. It might be worth including a utility to do this cleanup in a fut...
0 votes
I'm also experiencing the same problem. Are the any ideas on how to resolve this? Thanks, Martin. / comments
  1. Community
  2. SmartAssembly
  3. OutOfMemoryException when building project. 6.8.0.121
I'm also experiencing the same problem. Are the any ideas on how to resolve this? Thanks, Martin.
0 votes
Thanks to all who have contributed. I have managed to recover the data I was interested in. Lots of lessons have be learnt, and once again Redgate make this all so easy. Great job guys! / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore to point in time from 2 Full backups
Thanks to all who have contributed. I have managed to recover the data I was interested in. Lots of lessons have be learnt, and once again Redgate make this all so easy. Great job guys!
0 votes
Should I start with restoring the full backup from 29/04/12, and then restore the log to the specified point in time of 30/04/12 18:00? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore to point in time from 2 Full backups
Should I start with restoring the full backup from 29/04/12, and then restore the log to the specified point in time of 30/04/12 18:00?
0 votes
Okay, when I do a Full backup, and don't perform a Log backup, I take it the log is still preserved, so can I now do a Log backup and use that? A Log backup has not been performed yet, so is it still preserved? If so, can I use that Transaction Log to do a restore to a point in time? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore to point in time from 2 Full backups
Okay, when I do a Full backup, and don't perform a Log backup, I take it the log is still preserved, so can I now do a Log backup and use that? A Log backup has not been performed yet, so is it sti...
0 votes
Eddie: Good questions! I'm not sure I know the answers, please allow me to elaborate. The whole purpose of the exercise is to reduce the size of the daily backups. The database is just over 2Gb and the compressed size is 250Mb. Of this, over half is historic data that does not change (ever). I thought that if I could move the historic data to a new filegroup, I could do much smaller daily backups. Currently we do 2 Full backups a day, and one Log backup per day. Now you know the situation and the goal we wish to achieve, what would you suggest? I have no problem doing a 'complete' backup once a week (including the historic data), and partial backups (no historical data) throughout the week. Is this possible? Your help is appreciated. Regards, Martin. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. How should I backup a readonly Filegroup?
Eddie: Good questions! I'm not sure I know the answers, please allow me to elaborate. The whole purpose of the exercise is to reduce the size of the daily backups. The database is just over 2Gb and...
0 votes
Eddie: I am using the same version. I have recorded a very short video where you can see the problem, it can be downloaded here: https://zipsend.com/download/T2dkMFh1Uz ... fd835fcd47 HTH, Martin. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Decimal places for floating point and money numbers
Eddie: I am using the same version. I have recorded a very short video where you can see the problem, it can be downloaded here:https://zipsend.com/download/T2dkMFh1Uz ... fd835fcd47 HTH, Martin.
0 votes
Eddie: Yes I did try this, but I typed 0.5 and in Spain we use the coma to separate decimals, so is should be 0,5 if regional settings are respected. When I type 0.5 it is converted to 5. When I type 0,5 it is rounded to 1! Thanks, Martin. / comments
  1. Community
  2. SQL Data Generator Previous Versions
  3. Decimal places for floating point and money numbers
Eddie: Yes I did try this, but I typed 0.5 and in Spain we use the coma to separate decimals, so is should be 0,5 if regional settings are respected. When I type 0.5 it is converted to 5. When I ty...
0 votes
Total activity
96
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
25