Viewing 15 posts - 17,041 through 17,055 (of 39,831 total)
jay holovacs (1/12/2011)
GSquared (1/12/2011)
January 12, 2011 at 1:30 pm
CriticalStatus (1/12/2011)
Interesting thought. Made me think about how we would handle availability within our control. Another thought popped as I finished reading your article.
Can you replicate between...
January 12, 2011 at 1:28 pm
I have corrected the question to note that indexes on computed columns will not be used.
Because of this, I have also awarded back points to everyone that has answered this...
January 12, 2011 at 1:23 pm
What edition of SQL Server is this? If it's not Enterprise, you can't restore Primary and then get people working while you restore other files.
I have heard this advice before,...
January 12, 2011 at 9:00 am
Apologies. I was unclear.
That's good to know, but more about what connects to what, and for what purpose? How does this application work?
Are you thinking this is a series...
January 12, 2011 at 8:46 am
Alvin Ramard (1/12/2011)
Koen (da-zero) (1/12/2011)
Alvin Ramard (1/12/2011)
Canada's the backawards neighbour? I think someone got it backwards. 😎Hey, don't shoot the messenger 😀
(I even don't live in the USA)
Don't...
January 12, 2011 at 8:44 am
Make sure you dig in and understand what happens.
Also realize that when the CIO says "shrink", he doesn't necessarily mean "run dbcc shrinkfile". What he means could be "make sure...
January 12, 2011 at 8:43 am
You have to have primary available, and then you can restore another filegroup.
So if you have your db at 5:00pm. Some things in Primary, some in Reporting. If you have...
January 12, 2011 at 8:42 am
If it is subsequent actions, you would schedule a few log backups to clean it up. The reindex will be one large logged operation.
January 12, 2011 at 8:39 am
george sibbald (1/12/2011)
from QOTD of 7th JAnlog created at:
less than 64MB - 4 VLFs
64MB and less than 1GB - 8 VLFs
1GB or greater - 16VLFs
Nice memory
January 12, 2011 at 8:37 am
I tend to agree that you don't want your SQL Server exposed directly. Can you explain a little more on your setup?
January 12, 2011 at 8:22 am
Nope, everything is written to the transaction log. Even index rebuilds. This is so if they fail in the middle, they can be rolled back and maintain an intact index.
January 12, 2011 at 7:18 am
The above answer is correct. Shrink is not part of backup, and you should not shrink to a point below that which you need for maintenance operations.
How much data do...
January 11, 2011 at 8:47 pm
Excellent. Don't get too technical, don't use too much T-SQL/BOL style of explanation. Think junior DBA, secretary trained to handle basics, and explain in a simple way what to do...
January 11, 2011 at 8:53 am
Viewing 15 posts - 17,041 through 17,055 (of 39,831 total)