| Author |
Topic |
|
hayko98
Starting Member
29 Posts |
 Posted - 2012-02-08 : 14:44:14
|
| Hi all,I created datebase(SQl 2008) and placed my mdf file in F drive ,ldf file in G drive.I am trying to increse log files size.When i go to database's property/files i don't see log file.How do i change log files settings from SSMS? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-08 : 14:46:15
|
| right click on database choose properties. in that it will list all files (mdf,ndfs if any and ldfs) against that you've option to set log files growth ,max size etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2012-02-08 : 14:57:42
|
| As i said(When i go to database's property/files ),all i see is mdf file |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-08 : 15:04:17
|
| then try manually mapping it to ldf file in g:\ and set properties accordingly------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
hayko98
Starting Member
29 Posts |
Posted - 2012-02-08 : 15:18:33
|
| How do i map manually?.From SSMS? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-08 : 15:24:02
|
| yep...through the wizard you can map it by clicking browse button (... in properties)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2012-02-08 : 15:40:29
|
| OK.I was connecting to this server from my workstation.When i actualy opened SSMS from that server it shows both files.Looks like problem comes from my workstation. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-08 : 15:42:20
|
quote:
Originally posted by tkizer
My point is that the file has to already exist if the database is operational. A data file and a transaction log file are the minimum requirements of a database. Once it's created, you don't map another one unless it's for storage reasons. The fact that hayko98 isn't see two files there at a minimum puts into question the validity of the database since 2 are required.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
yep...agree to thatwe had couple of occasions where we had to map it to different drive due to space constraints which was what I was referring to------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hayko98
Starting Member
29 Posts |
Posted - 2012-02-08 : 15:53:22
|
| Any idea what is wrong with my SSMS? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
how to change log file's settings