Viewing 15 posts - 46 through 60 (of 115 total)
I believe the question was meant to discover whether your instance was started in Single user mode, also known as maintenance mode. Startup parameter: -m
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 30, 2012 at 3:17 am
I know it's already been covered, but just to put in cleartext:
The reason why you need to be careful about which indexes to add is that adding indexes can actually...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 30, 2012 at 3:01 am
Suspended is not necessarily bad, it simply mens we're waiting for some resource, which practically all queries will at some point and for some time.
The questions we need to...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 30, 2012 at 2:46 am
Yep. Your server's backup history will only show backups that were actually made on this server.
However, the server also keeps track of your restore history.
So, if you need to know...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 26, 2012 at 5:59 am
A differential backup is a backup of all pages changed since the last full backup, so there MUST be a preceding full backup somewhere. However, there is no requirement for...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 26, 2012 at 5:45 am
Are you sure the one server isn't just busier than the other and that's the reason why things take longer?
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 26, 2012 at 3:17 am
Actually, if we're talking about full-text search catalogs and that's what is not refreshing, than yes, I'd say that's probably it and I'm probably the one who was off. ...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 23, 2012 at 3:35 pm
alanspeckman (10/23/2012)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 23, 2012 at 3:15 pm
You should start by going back to whoever wrote this and have them provide whatever additional details they may have regarding the alleged "2 instances of the database". To me...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 23, 2012 at 2:14 pm
Sure, no problem. They are seperate files that can be grown (or shrunk) separately.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 23, 2012 at 2:00 pm
Well, at least you're cleaning up your own mess and learning from it. 🙂
Trust me, we've all had to do that a few times along the way.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 22, 2012 at 4:21 pm
Most likely you've come across a piece of bad application code that doesn't clean up after itself.
All temporary objects created in tempdb must be dropped when you're done with them.
You...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 22, 2012 at 4:04 pm
Also, you do need to be sure if changing recovery model of all databases to simple is really an OK thing to do.
This change has a significant impact on recoverability.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 22, 2012 at 3:52 pm
In my opinion, this whole having to "Run as administrator" thing is actually one of the worst ideas to be adopted by Microsoft in many years. While I can see...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 20, 2012 at 12:27 pm
Hmmm, we'd really need more info about your server and the actual job steps to say anything or certain, but one thought that strikes me is perhaps you're actually doing...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 18, 2012 at 11:25 pm
Viewing 15 posts - 46 through 60 (of 115 total)