Viewing 15 posts - 14,296 through 14,310 (of 49,552 total)
Chris Burton-434978 (2/13/2013)
I took a backup which included the corruption and...
February 13, 2013 at 9:22 am
SQL will not go into emergency mode by itself. Someone has to have set it to emergency.
What exactly happened, why was the DB set into emergency mode and what is...
February 13, 2013 at 7:01 am
You've probably got a % growth like 10% (very bad default) and an IO subsystem under strain so that the log can't grow and zero-out the requested size in the...
February 13, 2013 at 1:02 am
SELECT SERVERPROPERTY('IsClustered')
February 13, 2013 at 1:00 am
Koen Verbeeck (2/13/2013)
I've copy pasted their question as-is into Google, and the first result had their answer.
Same, and when I do, I'll post the link to the search...
February 13, 2013 at 12:59 am
Personally I find LMGTFY to be incredibly condescending, I'd feel quite insulted if someone gave me that kind of reply. I'll do the search for people if I don't think...
February 13, 2013 at 12:22 am
Lowell (2/12/2013)
at least viewing the estimated execution plan would give you a ballpark number;
Where 'ballpark' is the size of half a continent. 🙂
Run the script in a test environment with...
February 12, 2013 at 3:05 pm
Beatrix Kiddo (2/12/2013)
GilaMonster (2/12/2013)
Beatrix Kiddo (2/12/2013)
February 12, 2013 at 7:56 am
Benki Chendu (2/12/2013)
So, my question is, once we change the compatibility to a lower version, can we not backup that database and restore on a instance with a lower version.
No....
February 12, 2013 at 7:23 am
GilaMonster (6/17/2012)
When you attach, explicitly remove the ldf in the dialog (if they didn't provide it). Or use CREATE DATABASE ... FOR ATTACH_REBUILD_LOG
February 12, 2013 at 6:58 am
Beatrix Kiddo (2/12/2013)
February 12, 2013 at 6:55 am
I take it you didn't read the article I referenced, as it shows how to save and attach the graphical plan.
Also, please post SQL 2008 questions in the SQL 2008...
February 12, 2013 at 6:54 am
Beatrix Kiddo (2/12/2013)
5) Schedule a regular backup of the transaction log, with overwritewill that work ok and solve my problem?
As long as you never want to restore that log...
February 12, 2013 at 3:29 am
Do not set the min and max to the same value, it disables some of SQL's memory management and means that SQL won't reduce memory usage if the OS is...
February 12, 2013 at 3:16 am
Viewing 15 posts - 14,296 through 14,310 (of 49,552 total)