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?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 18, 2011 at 9:25 am
enable logging for the error numbers so it's written to the sql error log.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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....
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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...
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 16, 2011 at 1:14 pm
ah .. but have you tried to use rowversion?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 16, 2011 at 9:13 am
Viewing 15 posts - 211 through 225 (of 2,640 total)