Viewing 15 posts - 916 through 930 (of 1,790 total)
Lynn Pettis (1/16/2009)
Jason Shadonix (1/16/2009)
I used to work for a not-for-profit company that had SQL Server and Access, but no decent devleopment tools. (Couldn't/wouldn't pay for decent...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2009 at 3:18 pm
The link Colin provided above didn't work for me but this one did. Thanks for sharing - looking forward to the read.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2009 at 12:29 pm
Mike - Thanks for the clarification. What GSquared was recommending is as you stated, having 2 instances on the same box. And you could do as he described putting the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 16, 2009 at 7:25 am
Hence my question earlier about the volume group (set of disks) being dedicated. Hopefully that is the configuration. If not you get phantom IO issues to chase down and the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 3:57 pm
Shripati - To get more details on the space required when doing the restore you can run the following;
restore filelistonly from disk = 'D:\YourFolder\YourBackup.bak'
The output from that will...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 3:24 pm
Then you are going to want something comprehensive that will either pull it all to tape or some remote disk as Jason already stated. You will need to consider if...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 3:06 pm
All good points and to further what Gints is saying, you do have to take into consideration what skills are prevalent in your organization and / or your community. Where...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 1:50 pm
Have you looked at Data Protection Manager from MS? Check it out. Definitely worthy of a look.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 11:46 am
Steve Jones - Editor (1/15/2009)
What's "won"? Not sure what that means. Faster, larger, price/performance?
Sorry, good question. Yes, faster, and better price performance especially since we were using partitioning which is...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 9:57 am
We actually did what you describe Jeff, we had a "run off" with Oracle 10G and SQL Server 2005 in a data warehouse conversion test. Both 64-Bit on Itanium (this...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 8:35 am
Steve - Should we change the title of this topic to "Are the posters becoming more violent"? 😀
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 7:44 am
Have to agree with Michael on this and appreciate all the points he makes. It has been a few years since I have had to work with Oracle but they...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 7:42 am
GilaMonster (1/15/2009)
I just noticed that you're backing up the log with NO_TRUNCATE. Why?
Nice catch. Didn't even see that before. Ack...:sick:
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 5:01 am
Jeff Moden (1/14/2009)
Greg Edwards (1/14/2009)
Maybe you better think about upgrading Jeff. I'd hate for you to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 3:33 am
Marker (1/14/2009)
The TRN backup is completely ignored. During the DB Optimization then kicks off after the optimization completes.
Just to clarify, you are actually backing up the log during...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 14, 2009 at 3:25 pm
Viewing 15 posts - 916 through 930 (of 1,790 total)