Jump to content
RESET Forums (homeservershow.com)
Sign in to follow this  
ultra99

sql server?

Recommended Posts

ultra99

I have the N54L and wanted to run MS SQL server on it and store databases. Can I do that with any OS? FreeNAS for example?

Share this post


Link to post
Share on other sites
jmwills

No, you will need Windows Server unless you run a SQL EXpress and then you are limited by the total size of the data.

Share this post


Link to post
Share on other sites
ultra99

I just need SQL express. Can I run it?

Share this post


Link to post
Share on other sites
LoneWolf

You can host the database on FreeNAS for storage likely, but not run it.

 

Seeing as FreeNAS is designed for a storage perspective, I don't think it's ideal for your plans.  You could use Linux and MySQL, otherwise you're best off running some form of Windows Server.

Share this post


Link to post
Share on other sites
ultra99

I thought of installing win7, but since its not a "server" OS it won't be the best idea?

Share this post


Link to post
Share on other sites
ultra99

UPDATE: i found out that i get Windows Server R2  and Server 2008 and SQL Server 2012 R2  and and 2014 for free. Hmm...interesting, now his changes things around. Should I get Server R2 and SQL 2012 or 2014?

Share this post


Link to post
Share on other sites
jmwills

Use Server 2008 R2 and SQL 2012.  and....get ready to dedicate plenty of RAM to this box.

Share this post


Link to post
Share on other sites
ultra99

Use Server 2008 R2 and SQL 2012.  and....get ready to dedicate plenty of RAM to this box.

Thanks for your suggestion. May I know why Server 2008?

I still have the default 2gb ram. Should I aim for 8 or 16gb?

 

I want it to be mainly for data storage and SQL.

Share this post


Link to post
Share on other sites
jmwills

I'm just not a big fan of Server 2012 yet.  What is SQL going ot be used for?  (i.e what application)

 

No less than 8 GB

Share this post


Link to post
Share on other sites
ultra99

I see, I'm new to this server world so I don't know the difference. I'm starting ot self-learn MS SQL Server and how ot manage databases. Nothing big or major.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  



×
×
  • Create New...