Viewing 15 posts - 241 through 255 (of 1,524 total)
Yes, it does sound like a permissions issue.
October 20, 2015 at 8:11 am
Robert is right... check that. I missed that on one of mine once and a forum poster helped me with that. I believe you have to restart SQL...
October 20, 2015 at 8:06 am
Hum... My best guess is that it should be OK. By your accounts things are very low usage and if you say you have super fast storage too...
The only...
October 15, 2015 at 9:03 am
The BIG question is can a one box have enough resources for all that you want done... CPU AND Memory? Only you can determine that.
October 15, 2015 at 8:58 am
When you say Clone what do you really mean?
If you are simply wanting to take a prod environment and create a test environment that looks just like it.. then.
Install SQL...
October 15, 2015 at 8:56 am
First thing to do is log into SQL Server and run this query select @@version
This will tell you what build version SQL Server thinks...
October 8, 2015 at 1:28 pm
If you are THAT green look into the 5 day SQL Server DBA class from a Microsoft certified training facility. On youtube there are some good step by step...
October 8, 2015 at 1:26 pm
There is a balancing act we must all in IT adhere to. Keep something running 'as is' because it just runs... versus spending a lot of money and time...
October 8, 2015 at 5:45 am
Eric M Russell (10/6/2015)
Does DBCC OPENTRAN show any open transactions belonging to that user?
Too late to know this now. This happened at 10PM last night. I will keep...
October 6, 2015 at 8:11 am
That just might be it.... when I look at her SPID SQL it shows the select... hum....
That would explain why I see her as a blocking thread to another update......
October 6, 2015 at 8:10 am
Ok, thanks for the assistance. Next time it happens I will query sys.dm_tran_locks and see what shows up.
The NOLOCK hint is a left over from when this was in...
October 6, 2015 at 7:11 am
Agree. Automating a shrink is never good advice. Several apps have been installed here where they schedule a shink... I disable the job then delete it later.
October 6, 2015 at 6:54 am
I have only applied SP3 to 3 servers and all went well. Your best bet is to open a case with Microsoft for a fix.
September 11, 2015 at 12:24 pm
Not sure if this will help or not... worth trying..
try backing up to multiple files... 3...4... instead of 1 file.
Also, if you are SQL2008R2 or greater use the COMPRESS option...
September 11, 2015 at 12:19 pm
When you restore master you have to put SQL Server into Single user mode first as no other connections can be accessing SQL Server.
What error(s) are you getting?
September 9, 2015 at 5:11 am
Viewing 15 posts - 241 through 255 (of 1,524 total)