Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RandySCJ
Starting Member
2 Posts |
 Posted - 2007-10-29 : 16:59:18
|
| Hello,I have (2) questions about SQL versions and (1) question about "Standard Log Sizing" for SharePoint directory. I am pretty sure about SQL 2000 versions "Not being Certified".1) Which versions of MS SQL Server 2000 and 2005 are certified to run on Vista?2) Which versions of MS SQL Server 2000 and 2005 are certified to run on Internet Explorer 7 (IE7)?3) What should the "Standard Log Sizing" be for MS SharePoint Server drive be? Or is there an actual standard?Thank you. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-29 : 17:04:01
|
| 1) SQL Server is a "Server" application. "Vista" is a workstation O/S. So the answer is really "none". There are "cut-down" versions of SQL Server which will run on a workstation-O/S (look for terms like "Lite" and "Express" in the product name!!), so that's probably the answer you are looking for.2) The version of the database server has nothing to do with the Browser you may want to use.3) What do you mean by "Standard Log Sizing"?Kristen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-29 : 22:28:16
|
| 1. Sql2k5 standard edition can run on workstation os.3. There is no db log size standard, can be any size. |
|
|
|
RandySCJ
Starting Member
2 Posts |
Posted - 2007-11-01 : 14:49:38
|
Hi Kristen,Thank you for the information. I did find this information on the Microsoft.com website about which SQL versions/editions will be certified to be run on Longhorn / Vista. http://www.microsoft.com/sql/howtobuy/sqlonvista.mspxEarlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server "Longhorn" or Windows Vista.What I was asking about "Standard Log Sizing" or trying to ask was I was wondering if you had any guidelines on how to properly size the drive for logs on a new SQL server. We are currently working on migrating our Sharepoint servers to SQL 2005 and we were using a guideline from a former consultant of 25%, but that works out to 150Gb.Our server engineers are thinking that is way too big. The logs get backed up every hour and there is a full back up at the end of the day.They do not have auto shrink turned on. Currently there is 400Gb of data.  Thanks,Randyquote:
Originally posted by Kristen
1) SQL Server is a "Server" application. "Vista" is a workstation O/S. So the answer is really "none". There are "cut-down" versions of SQL Server which will run on a workstation-O/S (look for terms like "Lite" and "Express" in the product name!!), so that's probably the answer you are looking for.2) The version of the database server has nothing to do with the Browser you may want to use.3) What do you mean by "Standard Log Sizing"?Kristen
|
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-01 : 15:04:13
|
| (assuming I've understood your use of "Logs" to be the size of the LDF file)We work on the basis that the LDF file will be 120% of the MDF file.The most common cause of LDF growth is the maintenance of the LDF file (reindex / update statistics / bulk delete) which it is often harder to control by frequent TLog backup than the normal OLTP "traffic"Kristen |
|
|
|
|
|
|
|
|
SQL Server Certified for Vista and MS SharePoint