Viewing 15 posts - 226 through 240 (of 1,154 total)
Do you have any Application Jobs\Processes running during this period ? Start a server side profiler trace by appling filter on that DB and App ID and see what's the...
March 14, 2014 at 10:24 am
Could be due to missing 64 bit drivers for Excel ? Try to change the setting Run64BitRunTime property as False in the SSIS package and Run.
Or else you install ACE...
March 14, 2014 at 10:02 am
What was the reason for mapping the Network Drive at server startup ? You can ask your system admin to do that as Free_Mascot mentioned.
http://www.howtogeek.com/118452/how-to-map-network-drives-from-the-command-prompt-in-windows/
--
SQLBuddy
March 14, 2014 at 9:42 am
krypto69 (3/14/2014)
I have a situation I hope the smart people on here can help me with.
We have a local SQL server that is moving to the SAAS (online) environment....
March 14, 2014 at 9:36 am
On a server with 64 GB of Memory, How did you come up with 12GB Max Memory ? Do you have multiple instances running ?
--
SQLBuddy
March 14, 2014 at 9:34 am
kl25 (3/14/2014)
sqlbuddy123 (3/14/2014)
Also try to enable SSIS logging in the package and run the Job. That way you can better troubleshoot the issues.
Must have been typing at the same time...
March 14, 2014 at 9:32 am
How are you scheduling the Job ? Also try to enable SSIS logging in the package and run the Job. That way you can better troubleshoot the issues.
Also this could...
March 14, 2014 at 9:11 am
The failover takes place and the mirrored DB now becomes the Principal DB.
For automatic failover to happen, a witness server is needed and a connection should exist between Witness &...
March 13, 2014 at 3:42 pm
smtzac (3/13/2014)
I am configuring DB mirroring on principle database and the database has Full,Diff,TranLog backups job running everyday on Sql Agent.
In order to configure Mirroring on principle database...
March 13, 2014 at 3:36 pm
obtllc (3/13/2014)
March 13, 2014 at 3:22 pm
You are welcome, Thanh 🙂
--
SQLBuddy
March 13, 2014 at 2:04 pm
True, this confusion is introduced by MS terminology. Even though they say it as 3 synch replicas P, Sec, Sec , in reality it's only 2 Synch pairs (P -...
March 13, 2014 at 11:46 am
My questions are:
- How big is the risk of having "Maximum worker threads" way higher than the default value?
Mirroring:
As per your Scenario, assuming 64-bit system, Max Worker Threads = 640.
Max...
March 13, 2014 at 11:35 am
Naming should not be Node specific. Bcs in cluster nodes are always transparent.
It's better to have the name as department specific. Or if you have Application specific clusters it...
March 13, 2014 at 12:20 am
Charmer (3/11/2014)
I am just a beginner in report service. I am trying to deploy a report. But i get the messages below.
"Error1The permissions granted to user 'Domain\user' are insufficient...
March 13, 2014 at 12:11 am
Viewing 15 posts - 226 through 240 (of 1,154 total)