February 8, 2012 at 12:08 pm
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?
February 8, 2012 at 12:13 pm
Interesting that you cannot see the log file in database property, can you post a screen shot of the database property?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2012 at 12:37 pm
Sorry, i can't.
February 8, 2012 at 12:58 pm
All i see is mdf file
February 8, 2012 at 1:11 pm
Hi vardan.hakopian,
When ever you creates a database, You must had the option popup besides the window Filename.(If you want you can change this different than Logical Name)
Logical Name and Physical Name/FileName 's are two different things for the same database.
Logical Name should be Your Given database Name as 'SQl 2008' for Mdf and 'SQl 2008_log' for the ldf.
Of course, By default Physical/ File Names should be 'SQl 2008.mdf' and 'SQl 2008_Log.ldf' .
Unless you chose different names for your requirement.
Database (SQl 2008)--> Properties --> Files -->
Now you can take the scroll button and go all the way to the right until you see the File Name.. Please take a look for .ldf file under FileName Coulmn.
I hope it helps.
February 8, 2012 at 1:19 pm
There is only 1 row for mdf
February 8, 2012 at 1:23 pm
vardan.hakopian (2/8/2012)
There is only 1 row for mdf
Run the below script and see what you get..
SELECT * FROM MASTER..SYSALTFILES WHERE dbid = DB_ID('Database_Name')
Replace Database_name with the database that you are working on..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2012 at 1:26 pm
Are you looking at a database snapshot perhaps rather than a normal database?
Why can't you post a screenshot?
What's the output of this when run in that database?
SELECT type_desc ,
data_space_id ,
name ,
physical_name ,
state_desc ,
size ,
max_size ,
growth
FROM sys.database_files AS df
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2012 at 1:27 pm
fileidgroupidsizemaxsizegrowthstatusperfdbidnamefilename
111862400-138400208PRDE:\DB_Data\PRD_COPY.mdf
20704000-110104864208PRD_logG:\DB_Log\PRD_COPY_log.LDF
February 8, 2012 at 1:30 pm
type_descdata_space_idname physical_name state_descsize max_size growth
ROWS 1 PRD E:\DB_Data\COPY.mdfONLINE1862400 -138400
LOG 0 PRD_log G:\DB_Log\COPY_log.LDFONLINE704000 -110
February 8, 2012 at 1:31 pm
type_desc data_space_id name physical_name state_desc size max_size growth
ROWS 1 PRD E:\DB_Data\PRD_COPY.mdf ONLINE 1862400 -1 38400
LOG 0 PRD_log G:\DB_Log\PRD_COPY_log.LDF ONLINE 704000 -1 10
February 8, 2012 at 1:32 pm
type_desc data_space_id name physical_name state_desc size max_size growth
ROWS 1 PRD E:\DB_Data\PRD_COPY.mdf ONLINE 1862400 -1 38400
LOG 0 PRD_log G:\DB_Log\PRD_COPY_log.LDF ONLINE 704000 -1 10
February 8, 2012 at 1:34 pm
vardan.hakopian (2/8/2012)
fileidgroupidsizemaxsizegrowthstatusperfdbidnamefilename111862400-138400208PRDE:\DB_Data\PRD_COPY.mdf
20704000-110104864208PRD_logG:\DB_Log\PRD_COPY_log.LDF
If that returns more than 1 record, it should then display you the same number of rows in database properties (when you select files page)..
Can you ensure you close the properties dialog box and retry one more time and see what is displays..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2012 at 1:41 pm
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.
February 8, 2012 at 1:54 pm
Any idea what is wrong with my SSMS?
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply