SQL Server Performance Forum – Threads Archive
Installation questionHello, I’m not sure what category to post this under, so I apologize if this is the wrong place. Please feel free to let me know where this belongs… I have just taken over the role of DBA for a new company and have a question that I can’t find the answer to. I want to set up a SQL Server that mimics exactly the settings of another setup that was done when I wasn’t here. How do I determine all the settings applied on the initial install to the next install as I need exact settings? Thanks for your help in advance,
Hi, if you run sp_dboption at your old / installed server it will shows you current seted option then according you can set it to your new version. Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
you can view the server setting from sp_configure
four your information in SQL Server 2005, you can save your settings and from another server you can import your settings! —————————————-
Cast your vote
hi, also sp_server_info can give you some config details on your server AKTHAR DILMOHAMUD
65 BENARES ST
As Dinesh said,
sp_configure is the best option to compare with the differnet installations and settings which are done by the time. If you make practice of SQLDiag tools, which will give you a detailed study of your hardware, software and SQL related information. Once you did the installation and tuning, just run this tool, which will generate one log file in log folder. You can keep this for your reference. In this Log, you can see lots of tools are applied and generate reports. If you are applied SP3a, it will work smooth, but if you are SP4, if will give you an error, but you can overcome this error, with using the previous version of SQLDiag.exe (which is along with SP3a or previous). Regards
Excellent…you are all great! Thanks for your quick reply… I have another question in regards to replication…I’ve been reading many articles about improving performance for replication and planning ahead. I will be performing a merge replication, but before I set this up I need to know if I use ranges for IDENTITY columns on the publisher and subscriber, should those columns also have the NOT FOR REPLICATION property set? Thanks again in advance for all your help!
Hi,<br /><br />here is a link of article about validating data / subscriber<br /><a href=’http://www.mssqlcity.com/Articles/Replic/ValidMR/ValidMR.htm’ target=’_blank’ title=’http://www.mssqlcity.com/Articles/Replic/ValidMR/ValidMR.htm'<a target="_blank" href=http://www.mssqlcity.com/Articles/Replic/ValidMR/ValidMR.htm>http://www.mssqlcity.com/Articles/Replic/ValidMR/ValidMR.htm</a></a><br /><br />Enhance Replication Performance <br /><a href=’http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replperf_5kx1.asp’ target=’_blank’ title=’http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replperf_5kx1.asp'<a target="_blank" href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replperf_5kx1.asp>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replperf_5kx1.asp</a></a><br /><br />Identity Property <br /><a href=’http://www.sql-server-performance.com/images/SQLServer2000FastAnswers_Chap03.pdf’ target=’_blank’ title=’http://www.sql-server-performance.com/images/SQLServer2000FastAnswers_Chap03.pdf'<a target="_blank" href=http://www.sql-server-performance.com/images/SQLServer2000FastAnswers_Chap03.pdf>http://www.sql-server-performance.com/images/SQLServer2000FastAnswers_Chap03.pdf</a> </a> <br /><a href=’http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp’ target=’_blank’ title=’http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp'<a target="_blank" href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp</a></a><br /><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Not sure whether the below information will help you, but worth refering to them:
http://www.sqlteam.com/Item.asp?ItemID=9244 HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.