New DBA
-
Hi,
i am a new dba, i need tips to note on what are the things to note and to do while installing a sql server2005 and setting up new database and creation of user roles and give a perfect secured database to my team.
the database size is approximately 15 GB the disk space is 148 GB. our SA has planned to install OS for 30 gb.
D:/ sql server 2005 and system files
E:/ - User database and transactional log files hourly will be stored in this drive
G:/ - daily backup(full) of the database.
remaining can be used for transaction and web application server. am i right.
Please suggest how much space i must allot for each drive among 100 gb.
things to note while installation
1.mixed mode with server and windows authentication
2. setting up sa password.
3. install the service pack 3 for sql server 2005
3. after the installation i have to start the services for sql server.
4. set the port 1433 for sql server.
Is that all that i have to follow. or have i left anything please guide me.
After all this will the programmers able to connect this server from their PC.
Please suggest how much space i must allot for each drive among 100 gb.
After this setup can the programmers connect to sql server without any problem.
-
I dont think Sp3 is available for SQL 2005 refer, http://support.microsoft.com/kb/913089
for installing sql 2005 refer,http://dumthata.com/sqlchn/articles/install/insql.htm and also always have your data and log files in a separate drive and tempdb in seperate drive for the sake of performance........you need to create the logins in sql server for those who wish to connect it........default port of sql server is 1433
[font="Verdana"]- Deepak[/font]
-
can i split like this
D:\ 30 gb - SYSTEM DB AND SQL SERVER INSTALLATION
H:\ 30 gb - TEMP DB and TRANSACTIONAL LOG
E:\ 40 gb - USER DB
can i install service pack 1 for sqlserver 2005 but from the link i can see service pack 2 but i checked with my friends they all are using sp1 in their office only
and for the daily backup what setup should i request.
-
my advise is to go for SP2 as many problems faced in SP1 are fixed with Service pack2....backups schedule depends on your requirements, if your db is extremely critical and is used in OLTP environment where many data changes are possible so you should have full backups daily and differential or tran log backups are needed only if the db is very critical and you if you wish to have data consistency in case of any disaster.......
Data file - 1 drive other than where os resides.....
Log file - seperate drive
Backup and Tempdb - another drive........i feel this is fine but lets have few more opinions
[font="Verdana"]- Deepak[/font]
-
Deepak
i am going to set up a development db and this setup will be followed for production also. ok i will go for sp2
what you mean is
1st drive for OS AND SYSTEM DB
2nd drive for user db
3rd drive log file
4th drive is for backup and tempdb.
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply