User profile for ehuna

David, that's great news! Thank you for listening to your customers and following up with this early access build of SQL Compare with support for SQL Azure. As more and more developers find out about Windows Azure and host their data on SQL Azure I'm convinced this will pay off for Red Gate. Thanks! / comments

David, that's great news! Thank you for listening to your customers and following up with this early access build of SQL Compare with support for SQL Azure. As more and more developers find out ab...

0 votes

Nick, I understand you need to prioritize features depending on the popularity of the platform or device your code is targeting. That's one of the reasons so many developers are writing iPhone apps. But if you had to bet on a platform related to SQL Server, I think SQL Azure is a safe bet. Microsoft has invested over 2 billion dollars already on Azure and it's creating 5 data centers in the US that are over 500,000 square feet each. There's a similar data center being built in Dublin, Ireland as well. Only the SQL Azure CTP is available and hundreds of thousands of invitation tokens have been sent. Check out the SQL Azure CTP forums and you'll see dozens of threads each day - and the CTP was released less than a week ago! As mbaladi mentioned - SQL Azure works on port 1433 - it's TDS! That should minimize your efforts to make a version of SQL Compare that works with SQL Azure. Check out for example my two blog posts on scripts for SQL Azure: Cleaning up scripts for SQL Azure http://blog.ehuna.org/2009/08/cleaning_up_scripts_for_sql_az.html and Windows PowerShell commands to clean up scripts for SQL Azure http://blog.ehuna.org/2009/08/windows_powershell_commands_to.html I also opened a thread on the SQL Azure forums to share cleaning tips with other developers: http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/2e72f8a8-7e25-4149-98e6-2fd6c1506159 I spent 20 minutes and created the above PowerShell scripts that handle 90$% of my issues when cleaning up the generated scripts from SSMS for SQL Azure. I'm sure it wouldn't take you that long to come up with an integrated solution in SQL Compare. Of course I can't make you fix SQL Compare so it works with SQL Azure - but even today you would make a lot of money from folks upgrading their old versions of SQL Compare to streamline their SQL Azure development. Seems line a no brainer to me. / comments

Nick, I understand you need to prioritize features depending on the popularity of the platform or device your code is targeting. That's one of the reasons so many developers are writing iPhone app...

0 votes

There were no errors. So I tried going through the Log Shipping wizard again and this time was very patient. I let it run overnight and in the morning I had the four checkboxes and all four tasks were completed. I am setting up log shipping on a production environment where we have a standby system. This standby system is in a different city and we have a VPN between the two systems. Although we are assured 1 Mbps simetric between the two systems, sometimes it can be a lot slower. I think a possible feature request for future versions of SQL Backup would be more feedback on the restore status. The restore worked for an hour fine, where every few seconds I could see a few MBs had been transferred. But when it got to 99% or even 100% of all data being restored, it literally just sat there for hours. A link with more detailed steps or something that would give me the assurance that SQL Backup didn't just die or is not responding would be great. Otherwise, how would I know how long I should wait before panic kicks in and I have to kill SQL Backup? / comments

There were no errors. So I tried going through the Log Shipping wizard again and this time was very patient. I let it run overnight and in the morning I had the four checkboxes and all four tasks...

0 votes

I meant the log backup is configured by SQL backup. And therefore since the NO TRUNCATE option is not used, the space is recovered automatically (by SQL Server itself indeed). / comments

I meant the log backup is configured by SQL backup. And therefore since the NO TRUNCATE option is not used, the space is recovered automatically (by SQL Server itself indeed).

0 votes

Peter, thanks for the fast response. I think I understand, but let me be a bit more specific. Suppose I'm using only the SQL Backup UI to configure my SQL full backups and log shipping. Is there anything else I need to do to make sure that the logs don't just keep growing every day. In other words, should I have a manual step to "manually reduce the size of the database log (ldf) files by running DBCC SHRINKFILE or something similar", or does master..sqlbackup do it for me? If master..sqlbackup doesn't do it, when should I do it and what exact command should I use? (e.g. "DBCC SHRINKFILE ...") / comments

Peter, thanks for the fast response. I think I understand, but let me be a bit more specific. Suppose I'm using only the SQL Backup UI to configure my SQL full backups and log shipping. Is there a...

0 votes

Thanks Peter, that's excellent info. I will attempt not to shrink the LDF files and see how that goes. Since the space is recovered after every log backup (configured through SQL Backup) we should be ok. / comments

Thanks Peter, that's excellent info. I will attempt not to shrink the LDF files and see how that goes. Since the space is recovered after every log backup (configured through SQL Backup) we shoul...

0 votes

Got it, thanks. For those having the same question you need a license on any servers where you'll be backing up or restoring data (a full backup or logs). This means that if you are setting up log shipping, you need at least two licenses: one for your production server (source) and one for the standby (destintion). The good news is that you don't need licenses for the UI portion, so you could install it in your workstation as well as some Production systems used only for configuration, etc... Note: this is true today, Red Gate could of course change this any time. / comments

Got it, thanks. For those having the same question you need a license on any servers where you'll be backing up or restoring data (a full backup or logs). This means that if you are setting up log ...

0 votes

How can we help you today?

ehuna

Comments