Viewing 15 posts - 32,686 through 32,700 (of 49,552 total)
jpage01 (5/30/2010)
Msg 7909, Level 20, State 1, Line 1The emergency-mode repair failed.You must restore from backup.DBNAME
That says it all. Emergency mode is the very last resort, if it fails, there's...
May 30, 2010 at 11:12 pm
Ok, I give up. What's a clustering agent?
http://www.sqlservercentral.com/Forums/Topic930164-146-1.aspx
Who's got the crystal ball?
May 30, 2010 at 11:11 am
I'm working with a client at the moment where there's no DBA at all and never has been. Plan is that I do triage and get the environment back into...
May 30, 2010 at 10:58 am
This one's not much better...
http://www.sqlservercentral.com/Forums/Topic929458-357-1.aspx
If you have a 2 TB database and don't know how to plan backup and restore strategies, there's a bigger problem there.
May 30, 2010 at 10:53 am
viswanath09 (5/27/2010)
which backup and restore strategy used for the database size above 2TB.
I would really hope that if you have 2 TB databases, you have a senior DBA who's...
May 30, 2010 at 10:51 am
hxkresl (5/30/2010)
Thanks for replying Gilamonster.I have been saving to the same trans log using NOINT. so, there's only one trans file.
I would strongly suggest that you change your...
May 30, 2010 at 10:50 am
From the error, I'd say that log backup was taken before the Diff, which means it's not needed for the restore. You should start with the first log backup after...
May 30, 2010 at 3:40 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
May 30, 2010 at 3:39 am
Sourav-657741 (5/29/2010)
sp_spaceused only takes the 'table name' as parameter input. Can I get something similar results for SPs?
Not really, and I honestly don't see why you'd need to. Tables store...
May 30, 2010 at 3:34 am
What do you mean by size? No of characters? No of lines? Something else?
May 29, 2010 at 8:28 am
Do you have a DBA there, or someone that knows SQL well?
May 29, 2010 at 2:15 am
WayneS (5/28/2010)
GilaMonster (5/28/2010)
It was. I did the exchange rate calc in my head and messed it up. :blush: Fixed.
That's better! 😀
For those that didn't see it... she was offering her...
May 28, 2010 at 4:18 pm
TravisDBA (5/28/2010)
I feel every company should hire citizens first before immigrants regardless of country"
I'm so glad that isn't a law where I live. Though, the way the government is going...
May 28, 2010 at 2:31 pm
Viewing 15 posts - 32,686 through 32,700 (of 49,552 total)