Preparation

Nov 24, 2006

Hi,

Any suggestions on how to get a crash course to prepare for an interview on SQL Server 2005 Integration Services please?
Thanks

View 2 Replies

Replication(Preparation) In Sql Server 2000

Aug 20, 2007

Morning Guys,
If one was preparing to Replicate a database and need to know how much more size would be needed to accomadate the distribution database and its transaction logs etc... what performance counters would you set to gather this information and or tools...?

How to go about finding the average tranaction size.... number of transactions per day.... via profiler.... perfmon....
any suggestions or good sites for replication would be greatly appreciated...
thanks,

thanks,
Jonathan Marshall

View 1 Replies

Dec 21, 2007

Hi
I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance.
I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system.
I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.

Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version?
I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer.
According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system
(NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?

Thanks

gifty

View 3 Replies

Apr 10, 2014

I ran the Advanced cluster preparation for a new sql instance on an existing cluster.

Slq Server 2012.

After is completed, it was successful, I realized I specified the wrong Instance Root directory.

Is it possible to remove what the preparation installed? Or is it possible to change the root directory?

View 3 Replies

View Related

Preparation

SQL Server Interview Preparation...

Replication(Preparation) In Sql Server 2000

Can I Use Sql Server 2005 Developer Edition With Windows Xp Home Edition SP2 For MCTS Exam 70-431 Preparation?

SQL 2012 :: Advanced Cluster Preparation For New Instance On Existing Cluster