Viewing 15 posts - 1 through 15 (of 131 total)
Thread deleted. Never mind.
August 4, 2012 at 7:53 pm
I think Thursday I may have gone down the wrong path due to an error message leading me that way.
The reality is yes, the account I am running as...
May 6, 2012 at 1:33 pm
Then in that case, you need to do what Perry Whittle suggested. You need to tell your DNS Administrator (if it's not you) to add a CNAME record that points...
October 18, 2011 at 2:53 am
Can we assume you have a trust set up between the two domains? Obviously your users are in one domain and their user accounts must be known to and trusted...
October 17, 2011 at 1:24 pm
In my experience, compression with 2008 R2 will make a big difference. I am seeing a 50-80% reduction in backup size.
October 16, 2011 at 2:32 pm
If your relational databases are large, complex, or valuable enough to warrant a full time DBA, then as a general rule of thumb, that DBA or team of DBA's should...
October 16, 2011 at 2:25 pm
"Backwards from the branches" isn't descriptive enough for me either. Do you mean a reverse-preorder?
Check out this wikipedia article for some standard nomenclature with regard to tree traversal:
October 14, 2011 at 6:03 am
Ah, about 6 months ago an accounting analyst at my last job reported this exact problem and I am struggling to remember what it was. I think it had something...
October 13, 2011 at 2:54 pm
Forgive me, I didn't quite state things correctly above.
The two modes your secondary database can be in to receive logs in a log shipping scenario are, RESTORE WITH NORECOVERY...
October 13, 2011 at 2:47 pm
In my experience it's best never to present so-called, "decision makers" with anything but the right decision(s)!
October 13, 2011 at 2:06 pm
There are two options for the database on the secondary server (aka, the one receiving the log shipments, so to speak). It can either remain In Recovery, or it can...
October 13, 2011 at 1:59 pm
My best guess is whether you use DSN or not isn't going to make any difference. You're going to either configure SQL to use a random port or a...
October 13, 2011 at 12:49 pm
If you only removed tables, added indexes and added tables, the Red Gate's SQL Data Compare would be perfect. I've used it for years. For any objects that it doesn't...
October 13, 2011 at 12:35 pm
By all means, lock it down the networking as much as you can, but Lowell's point is that even after closing down ports you don't need, you're still going to...
October 13, 2011 at 12:20 pm
We recently upgraded all of our reports to SSRS 2008 R2 and it works quite a bit better than 2005. 2005 left me very frustrated.
Data driven subscriptions have been...
May 29, 2011 at 9:59 am