Viewing 15 posts - 31 through 45 (of 420 total)
I'm gonna go out on a limb here and say there's really no need to look at Ola anymore.
Minion Backup does everything it can do and much more... and the...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 8:29 am
No, you don't HAVE to have cmdshell when you work with the filesystem. There are a couple XPs to do something simple things, and you can write CLR. ...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 7:47 am
Well, since we're all sharing backup routines, has anyone here tried Minion Backup?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 7:08 am
Don't use non-native backups for SQL. This is always a bad idea. These products will always fail you in the end.
If it takes you that long...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 5:33 am
Check the disk. Sounds like you may have some bad sectors you're writing to. Or maybe there's a disk quota? I doubt it, but I want to...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 5:28 am
What's your exact use case for this? I can kinda see where it would be useful in some limited circumstances, but otherwise there's not much point.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 5:24 am
Actually, preaching to disable cmdshell is a very out-dated concept. There are lots of ways you can hurt security, but cmdshell isn't really one of them. Here's a...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 5:12 am
I'm sorry man, but this backup routine is only for the most basic of shops. If you've got a little departmental DB under someone's desk and you just need...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
December 17, 2015 at 4:25 am
But I want to make it clear that the article is solid. It just needs a better title.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
September 8, 2015 at 3:09 pm
The title of this is misleading isn't it? Because you're not really getting query results out of SSMS, you're just re-running the query in PS. If you've got...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
September 7, 2015 at 6:03 am
Wow, thanks for the good words guys.
Let me know if you need any help with anything.
And oh yeah, I'll have to check that MR specifically weeds out disabled indexes.
We're about...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
July 30, 2015 at 8:18 am
Yeah, that's one of the situations I envisioned when thinking about the Azure copies.
We can certainly take it offline if you like. I can tell you what all I...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 1, 2015 at 5:15 pm
Ok, so feel free to post links to these blog posts you're referring to. I guarantee you that they're just discussing general practice, and that's the problem with articles...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 1, 2015 at 5:13 pm
I'll answer both of you guys at once.
1. No, we don't have a comparison with Ola yet. If you recall, when we released MR it took us probably a...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 1, 2015 at 4:28 pm
Hey VictorDBA, thanks for letting me know about the link. http://www.MidnightDBA.com works but for some reason the null host header doesn't. I'll look into that.
And yes MB does...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 1, 2015 at 9:30 am
Viewing 15 posts - 31 through 45 (of 420 total)