Viewing 15 posts - 3,586 through 3,600 (of 18,926 total)
naresh.talla (8/9/2011)
we are getting error "not enough server storage is available to process this command"
We...
August 9, 2011 at 6:04 am
No it doesn't have to recover 170 GB of data. It has to rollforward, or most likely rollback the active transaction you killed mid-process.
You just happened to do it...
August 9, 2011 at 6:01 am
Thanks for pointing out the new system objects.
Couples points.
Heaps should not be ignored when doing index maintenance.
You shouldn't blindly rebuild all index without there being a need for it.
This is...
August 9, 2011 at 5:58 am
Adiga (8/9/2011)
Naresh,Check if restarting the SQL Server instance before restoring the database helps.
How could that help?
August 9, 2011 at 5:50 am
srinath.vanama (8/9/2011)
After database recovered i checked the log size and it is near about 170 gb. Later i shrinked the...
August 9, 2011 at 5:48 am
RonKyle (8/9/2011)
Also consider that most DBAs do not consider Access as a Database
Access may not be an enterprise level database, but it is a database. Like any tool, there...
August 9, 2011 at 5:26 am
Rob-350472 (8/9/2011)
On and it's probably obvious but why are the last 3 tutorials greyed out?!
The stairway concept is somewhat new around here. The articles have been laid out and...
August 9, 2011 at 5:14 am
Plan L might be to call an SP which generates html and then sends via dm mail. It would not be my first choice but this would work.
August 8, 2011 at 2:34 pm
That depends entirely on your backup strategy and how much back data you need to keep to be in order with your sla.
You might want to hit google on this...
August 8, 2011 at 2:25 pm
My cie has a rather complexe ERP (only 1 DB & 1 app). The total man hours required to thoroughly test the application is in the 1000 of hours.
Let's...
August 8, 2011 at 2:24 pm
SQLRNNR (8/8/2011)
And our MVP thread friend blew it by still taking cred. Background - his script including notes are verbatim from Microsoft.
Not 100% sure about this. Maybe I'm...
August 8, 2011 at 11:12 am
Told you the fix was simple. 🙂
Take 5 and get back to it. I'm sure you'll get it from now on 😉
August 8, 2011 at 11:07 am
... and with insurance and extra support that life cycle can be extended even further.
Yes licenses are pricey, but it comes with a loads of benefits.
August 8, 2011 at 11:05 am
Here's my little 0.0000002$.
Everybody's trying to help everybody on this thread (and community).
Nobody's tried to insult anybody and every comment should be taken with a big spoon of salt.
Let's...
August 8, 2011 at 11:03 am
Viewing 15 posts - 3,586 through 3,600 (of 18,926 total)