July 20, 2016 at 10:04 pm
I'm still struggling with getting my SQL Server database into Azure. Most of it is my own misunderstanding, some of it is because I don't know the steps and feel like I've walked into the middle of a conversation.
Anyway, right now its too late, but I've had a logical server running for 4 days. I've heard that its best to turn things off in Azure when you're not using them, then turn the back on later when you're ready to do more work or use them. OK, that sounds nice. Only, I don't see any light switch anywhere. So how do you turn things off in Azure and then turn them back on again? Through the Portal?
Rod
July 20, 2016 at 10:45 pm
How do you turn off an instance of Azure?
Nukes? 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2016 at 11:04 pm
Turning the Azure SQL Databases on and off is not an option but you can throttle it down to a basic tier when not using it. The on/off option applies to virtual machines but not the SQL Databases.
😎
July 21, 2016 at 6:36 am
For Azure VMs you can do it via the portal. see the attached screen shot.
I Don't think you can switch off a logical server.
August 1, 2016 at 9:53 am
Even if you delete all the databases, the "server" will still be there. You don't pay for them, only the databases that are running on them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2016 at 4:35 pm
So... Like I said... "Nukes". 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply