Viewing 15 posts - 211 through 225 (of 2,640 total)
it's probably a silly question but did you check the service was running?
Can you connect locally on the box?
May 18, 2011 at 9:31 am
I don't think you need to be so harsh about serialisable transactions, you just need to explain that it effectively puts the database into single user mode - you'd need...
May 18, 2011 at 9:30 am
hmm interesting - I'm running under domain accounts but our datacentre don't support Kerberos so I don't know why it all works for me to be sure. I made no...
May 18, 2011 at 9:25 am
enable logging for the error numbers so it's written to the sql error log.
May 18, 2011 at 2:16 am
name/reports should do it.. If I remember correctly using the ip address usually forces a login.
I seem to remember that sometimes the first time you connect a login box...
May 18, 2011 at 2:13 am
snapshots are fine - most of my servers have lots of power to spare, the problem I had was that nearly all the reports had to do a load of...
May 18, 2011 at 1:59 am
note that you can't issue any writes and your mirror server must be licensed. ( normally failover/standy servers don't require sql licenses )
I will say I did some tests with...
May 17, 2011 at 3:50 am
sorry didn't fully answer your question - there are no real pitfalls to moving san volumes about - BUT - I'd make a backup somewhere else first just in case....
May 17, 2011 at 3:42 am
you can't just detach and attach system databases - you'll need to find the relevent kb article.
The quickest way to move mdfs or backups when you have a san is...
May 17, 2011 at 3:38 am
It's not so much how much much you spend on security as how much it will cost you if your security fails!
I must admit to always having hardware firewalls...
May 16, 2011 at 1:52 pm
I'd suggest you start with 56GB out of 64GB for SQL Server max memory and work from there. There have been so many blog posts from the microsoft teams over...
May 16, 2011 at 1:40 pm
yup I agree with you opc.three. You can't just declare replication will solve this that and the other. when databases/tables are large making changes or re-initialising the objects...
May 16, 2011 at 1:34 pm
hmm that's interesting, I did at one stage try gauges on my dashboards but they took up too much room compared with the normal pie or bar charts - I...
May 16, 2011 at 1:22 pm
I so love following this type of post because it's real world practical stuff that it's good to know as who knows what the business/developers are going to throw at...
May 16, 2011 at 1:14 pm
Viewing 15 posts - 211 through 225 (of 2,640 total)