Viewing 15 posts - 8,086 through 8,100 (of 9,725 total)
It sounds like this latest question is something different from your original post. If that is indeed the case, please remember that new & unrelated questions should have their own...
April 2, 2010 at 8:54 am
chrisph (3/31/2010)
I would check/ask if they have "volume shadow copy" enabled on the server....
April 1, 2010 at 12:16 pm
river1 (3/31/2010)
No need steve, i want to delete almost all the logins. But thanks
But disabling them first will guarantee you'll be able to delete them afterwards.
Can't logon to the system...
March 31, 2010 at 6:23 am
Glad we could help. BTW, setting up a restore as an auto-job is probably going to be the hardest part. Once you have it set up, you can pretty much...
March 31, 2010 at 4:20 am
If the software was already staged, chances are that's why it's skipping the software check. It's probably been short-cutted to do so.
Basically, you'll have to manually do the checks to...
March 30, 2010 at 3:49 am
John Rowan (3/29/2010)
March 30, 2010 at 3:47 am
Actually, I just figured out what's going on in terms that I can understand.
My explanation to myself is:
It's not that you have a blocked index, because honestly, an Index...
March 29, 2010 at 12:29 pm
Ah. We posted at the same time. I see your explanation now.
Do you have the text of the Blocked Index errors you were getting?
March 29, 2010 at 11:47 am
Ditto to what Jason said. I'm just confused because I don't know what a blocked index is and what allowing page locks has to do with it.
If you could clarify...
March 29, 2010 at 11:46 am
Waseem Jaleel (3/29/2010)
March 29, 2010 at 11:43 am
Do not mistake "want" for "need". There is no need. Technically, you could run a 1 TB size database on one file and one filegroup.
The idea of splitting your database...
March 29, 2010 at 11:33 am
The one thing to note about killing connections this way is that it does NOT prevent those connections from reconnecting after they've been disconnected. The best way to do that...
March 29, 2010 at 11:28 am
I agree with Grant. If you can do it, go for it. I don't see any Cons to the situation and only Pros.
Just don't make the mistake of setting Max...
March 29, 2010 at 10:58 am
What exactly is your definition of a "Blocked Index"?
I've never heard that term before and I find myself wondering what it has to do with allow_page_locks being on or...
March 29, 2010 at 10:55 am
Not sure what MOSS is, but here goes.
gmamata7 (3/29/2010)
2. What are the exact steps I need to follow to create secondary data file?
Open up Books Online and lookup ALTER DATABASE...
March 29, 2010 at 10:44 am
Viewing 15 posts - 8,086 through 8,100 (of 9,725 total)