Viewing 15 posts - 226 through 240 (of 966 total)
Are any XEvents or SQL Server Audits setup? Could be done for some kind of compliance.
June 22, 2015 at 1:31 pm
What kind of logging? Can you give some examples of what is in the log? It could be apps issuing RAISERROR or THROW commands, SQL Server audits, XEvents, etc.
June 22, 2015 at 1:30 pm
That is why the Report Server logs are so important. One can guess that it is a deadlock issue but that is only a guess. The logs will have have...
June 22, 2015 at 1:23 pm
What is the retention time set on mx plan?
How old are the backups that you were expecting to be deleted?
June 19, 2015 at 11:57 am
How did you set the job up and what are the specifications of the backups? If the files do not meet the properties you are setting in the mx plan...
June 19, 2015 at 7:14 am
Was the sa login recently disabled or renamed on the instance where your development is pointing to?
June 19, 2015 at 7:01 am
What is the serviceaccount you are specifying to setspn? Is it a domain user account, a computer account, a virtual account? It sounds like you are specifying the account name...
June 19, 2015 at 6:59 am
It's an odd thing. There's no reason for it but I don't believe that you can be in the database that you're attempting to shrink a file of. Try USE...
June 17, 2015 at 9:47 pm
Yes and no. You can create an AlwaysOn Availability Group where one of the replicas is a cluster (they refer to it as AlwaysOn Failover Cluster Instance (FCI)). So in...
June 17, 2015 at 2:39 pm
* Do I need to backup and restore the service master key on secondary server in order to have the column level encryption to work on secondary server?
Service master keys...
June 17, 2015 at 2:32 pm
Is this SQL Server 2005? If so, what is the version number/patch level?
June 17, 2015 at 2:05 pm
Good question. I would think so but the requirements page seems to indicate 2.0 specifically. Can you test it out and see if it works?
June 17, 2015 at 1:58 pm
I have a bad feeling if you are getting an architecture mismatch to Excel using the 64-bit driver you are going to need to use the 32-bit driver.
Which means you...
June 16, 2015 at 2:34 pm
It can be done while the database/application are online. If it is a large database or the server is very active you might want to consider setting this up outside...
June 16, 2015 at 2:19 pm
If you have SQL Server Configuration Manager on the machine trying to use Named Pipes you can setup the order protocols are tried. Otherwise you can setup a SQL Server...
June 16, 2015 at 2:13 pm
Viewing 15 posts - 226 through 240 (of 966 total)