Viewing 15 posts - 4,141 through 4,155 (of 22,224 total)
Probably the easiest way is to set up a scheduled check for the existence of the file. If it's there, fire off the load process. If it's not there, wait...
"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
January 5, 2017 at 4:45 am
Everything everyone else has already said, plus, to help troubleshoot, you can look at sys.dm_os_wait_stats before and after running the restore to understand where the slow downs are occurring. You...
"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
January 5, 2017 at 4:42 am
I'm going to try to work up a blog post on this over the next couple of days. If I get it done I'll come back here & post a...
"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
January 4, 2017 at 3:40 pm
It is. I don't have an example handy.
"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
January 4, 2017 at 11:48 am
Since you're on SQL Server 2012, instead of using Profiler, I'd strongly recommend you use Extended Events. They have a much more lightweight footprint than Trace Events (you wouldn't want...
"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
January 4, 2017 at 11:15 am
BrainDonor (1/4/2017)
DBMS of the year, apparently - http://db-engines.com/en/blog_post/67
I use this list a lot (and usually Microsoft hovers around #3 or #4, occasionally #2). It's a great tool for discussing why...
"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
January 4, 2017 at 8:34 am
We use Azure Automation. You can schedule it pretty much like Agent. Currently we don't have any specific maintenance for Data Warehouse because we do a daily reload. There's nothing...
"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
January 4, 2017 at 6:08 am
All respect to the GUI, it's so much easier to backup and restore databases using T-SQL. Here's a good intro on the topic [/url]that ought to give you everything you...
"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
January 4, 2017 at 6:02 am
I agree with Chris. If you can verify that all your databases are being backed up, then the issue is somehow within the job itself. It's not exiting cleanly. You'll...
"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
January 4, 2017 at 5:53 am
Which the optimizer then turned into what I was writing:
SELECT Expr1002 = CASE
...
"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
January 3, 2017 at 12:41 pm
AZCopy is how I would do it if you aren't going to use the Redgate utility.
As to cost, the Redgate utility as currently configured, is free.
"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
January 3, 2017 at 9:57 am
Sorry, I was away from email. However, the other answers are what you need to do. Get a list of successful backups (which was a part of Thomas' article) and...
"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
January 3, 2017 at 9:55 am
Thomas' stuff looks excellent. I'd follow that method. If not, just querying the backupset system database can at least tell you what has been successfully backed up. You can then...
"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
January 3, 2017 at 8:31 am
Through Microsoft's own testing, SSIS is the worst mechanism for migrating data into Azure SQL Data Warehouse. I would recommend any other method.
DISCLAIMER: I also work for Redgate.
"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
January 3, 2017 at 6:24 am
My son purchased his first car ever and it was an ancient & abused Jeep Wrangler. I drove it and it was a blast. When my pickup truck died (ugly),...
"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
December 29, 2016 at 9:22 am
Viewing 15 posts - 4,141 through 4,155 (of 22,224 total)