<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 Administration
»
SQL express 2008 R2 - DB size
13 posts, Page 1 of 2
1
2
»»
SQL express 2008 R2 - DB size
Rate Topic
Display Mode
Topic Options
Author
Message
Krishna1
Krishna1
Posted Monday, October 01, 2012 12:16 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:51 AM
Points: 127,
Visits: 277
I am using express edition of SQL 2008 R2. As per the microsoft sites we can have max DB size as 10GB. But in my sql server current size is 15GB
I dont know how this is possible. Do you have any idea?
Post #1366327
GilaMonster
GilaMonster
Posted Monday, October 01, 2012 1:13 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
How big's the data file, how big's the log file?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1366334
Krishna1
Krishna1
Posted Monday, October 01, 2012 1:35 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:51 AM
Points: 127,
Visits: 277
db file size is 6 GB and log is 9 gb
Post #1366345
GilaMonster
GilaMonster
Posted Monday, October 01, 2012 1:51 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
You're within the size limits then. The size limit is on the data files, the log file does not count. so 6 GB used out of 10 GB allowed.
p.s. Got proper log management in place? Log files aren't usually larger than the data files.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1366357
Krishna1
Krishna1
Posted Monday, October 01, 2012 2:08 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:51 AM
Points: 127,
Visits: 277
I just took Full backup but still the log file size is showing 9GB? I did it using sqlcmd command and the procedure sp_BackupDatabases
Post #1366377
GilaMonster
GilaMonster
Posted Monday, October 01, 2012 2:16 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
Backups don't change file sizes.
I suspect you may need to read this:
Managing Transaction Logs
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1366382
Krishna1
Krishna1
Posted Monday, October 01, 2012 3:35 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:51 AM
Points: 127,
Visits: 277
thanks for the link. After shrinking the log file now DB size has reduced to 6GB.
Post #1366426
GilaMonster
GilaMonster
Posted Monday, October 01, 2012 3:44 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
I take it you missed the section in that article about not shrinking the log then.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1366437
dan-572483
dan-572483
Posted Monday, October 01, 2012 10:34 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 11:09 PM
Points: 328,
Visits: 939
On a related note, I've discovered a hole in the 10GB limit. We have a user with a SQL 2008 R2 Express instance on his workstation whose been adding tables to the Master database and importing data to them. He's up past 50GB now.
I'm NOT recommending that anyone do this. I'm suggesting that if anyone from the Microsoft SQL Dev team is reading you might want to take a look at this.
Post #1366654
Krishna1
Krishna1
Posted Monday, October 08, 2012 1:40 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:51 AM
Points: 127,
Visits: 277
The log file size had increaded due to BCP operaiton. Hence i did the shrink. Is it ok to do dhrink in this case?
Post #1369645
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
