Viewing 15 posts - 46 through 60 (of 984 total)
December 13, 2018 at 7:53 am
That looks more like a security issue - check the permissions on the C:\backup folder and that the SQL Server service account has access to that directory and the files...
December 13, 2018 at 7:25 am
Yup. That functionality was broken in the upgrade from 2008 -> 2012. https://docs.microsoft.com/en-gb/sql/database-engine/breaking-changes-to-database-engine-features-in-sql-server-2016?view=sql-server-2014#SQL14 There was a workaround - set the compatibility level of the database to 100 - but...
December 10, 2018 at 10:11 am
I've had similar problems in the past, which haven't been cleared by rebooting. I blogged about it here - https://thelonedba.wordpress.com/2017/09/18/sql-server-installation-failed-due-to-pending-restart-of-server/
The gist of the solution I used in this...
December 10, 2018 at 9:13 am
A further thought - the virtual file stats dmv will also not account for any data requests that are served from cache. Depending on the config of your server, that...
December 5, 2018 at 3:21 am
That'll also keep track of any throughput due to backups, index maintenance, dbcc etc. Depending on your job frequencies, this may be heavily skewing the IO.
You could report...
December 5, 2018 at 3:19 am
a year later, and people are just now contributing suggestions.
I would suggest that either the OP has fixed the problem, or he has found a new opportunity. Possibly...
December 4, 2018 at 7:12 am
November 28, 2018 at 5:40 am
November 28, 2018 at 5:09 am
November 28, 2018 at 5:01 am
Does the user ID named as being the job owner still exist in the domain?
November 27, 2018 at 7:23 am
I'm just going to leave this here... https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/
November 16, 2018 at 7:17 am
Assuming that the relationships have been properly baked into the SQL database schema, then there are tools out there to help you visualise the connections / relationships. For example, Redgate's...
November 16, 2018 at 4:47 am
You should go with me. It's much more fun to find and pork...
November 12, 2018 at 6:30 am
Am aware that am posting on years old thread. Sorry for that.
Would you...
November 12, 2018 at 5:43 am
Viewing 15 posts - 46 through 60 (of 984 total)