Viewing 15 posts - 1 through 15 (of 1,347 total)
I've used Netbackup and Commvault.
used to backup a 6TB database via netbackup to tape. Took 2-3 days for LTO-4
Commvault is nice and has amazing compression. Way...
January 14, 2019 at 11:41 am
you can try distributed replay controller. It's part of SQL 2012 and you might be able to use it with 2008 as well. It's more for load testing, but might...
July 11, 2018 at 7:17 am
July 10, 2018 at 8:00 am
Personally I like Extended Events better than profiler. But my biggest complaint is not setting up the session, but changing it. It was easier on profiler than editing the query...
June 21, 2018 at 2:54 pm
Why would anyone run any other application on a SQL server? Especially one with large databases like this?
I've had really good results with lock pages in memory. I've...
June 11, 2018 at 7:04 am
I've had this happen via a straight SSMS connection from my computer and have seen something similar with replication. A few times the DC was hosed up and needed a...
May 31, 2018 at 9:07 am
create a variablewrite a query to populate it write if statement if it equals doesn't equal 192 then Sp_send_dbmail with whatever you want to email
maybe put the...
May 21, 2018 at 2:10 pm
Has anyone done this on servers with numerous applications accessing them? How do you handle applications slowing down due to the loss of indexes? And how does Always On react...
May 21, 2018 at 1:09 pm
Is it possible to create a distro list on your email system with all the addresses who need this report and use it in your subscription? Fairly sure that this...
May 15, 2018 at 9:41 am
We use Commvault. I have a few scripts that check backupset to make sure everything is backed up. We do test restores every so often and Commvault verifies that the...
April 19, 2018 at 9:08 am
Commvault and a lot of the other disk backup systems you can replicate your backups to a DR site unlike native backups
April 18, 2018 at 7:41 am
could be DNS. For some reason it can't connect to the database.
Was SQL restarted during the error?
April 10, 2018 at 12:41 pm
Not 100% sure but this might work
And I'm not sure of the minimum version of SQL it requires
April 10, 2018 at 12:37 pm
have you checked the requirements to make sure you don't need enterprise edition?
April 6, 2018 at 6:59 am
i'll try the elevated. I'm admin on the server and thought it would be enough
March 29, 2018 at 12:48 pm