Viewing 15 posts - 17,131 through 17,145 (of 39,957 total)
That's weird. I'll have someone look at it.
January 14, 2011 at 8:40 am
You have a good explanation, John. Just not sure that it's entirely valid to paint a paradigm or framework as "less secure" with a broad brush.
The flip side is that...
January 14, 2011 at 7:48 am
TravisDBA (1/14/2011)
January 14, 2011 at 7:44 am
If you shrink a log, you are reclaiming inactive space (subject to a few constraints) for the OS by reducing the physical size of the log. However regrowing it can...
January 14, 2011 at 7:38 am
I think I might ask for a 64-bit test from then. The file formats, and many things are the same. Unless they have some 32 bit driver, it ought to...
January 14, 2011 at 7:34 am
First, get backups running on production servers in an organized fashion. Just built a policy for now, then start getting things changed based on criticality.
Second, as you set things up,...
January 13, 2011 at 5:32 pm
You can drop the login without any consequences on the primary system.
January 13, 2011 at 3:58 pm
First, you might look at this script for a more efficient index rebuild: http://sqlfool.com/2009/06/index-defrag-script-v30/
An index rebuild is a logged operation. So rebuilding the indexes will result in lots of log...
January 13, 2011 at 3:41 pm
What I have heard regarding CUs is that they are tested and the support people at MS have confidence in them. However, they do not get the wide range of...
January 13, 2011 at 3:25 pm
You create a login and user on the source system.
You then migrate that login to the new system (the user will come through log shipping) using the same SPID.
This should...
January 13, 2011 at 3:21 pm
I have heard of upgrades being done that have literally been done with shipping a SAN through Fed Ex for large scale migrations.
These days I'd use Michael's advice. I'd actually...
January 13, 2011 at 3:18 pm
Backup does nothing to the transaction logs. Not sure what you mean by "reorganize" here, but a backup doesn't affect t-logs.
The thing is you database file and your external files...
January 13, 2011 at 3:15 pm
January 13, 2011 at 3:10 pm
Luke L (1/13/2011)
January 13, 2011 at 2:28 pm
You cannot make changes to a db in standby mode.
January 13, 2011 at 2:20 pm
Viewing 15 posts - 17,131 through 17,145 (of 39,957 total)