Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
futureking
Starting Member
2 Posts |
 Posted - 2008-10-26 : 14:03:43
|
| hi,I am developing my database and entering records on my local machine. My plan is to finally transfer it to Web Server.The problem is..My DB size is : 7 MBand Log size is : 1191 MBSql database is costly and I haven't enough money to host such kind of giant db. 7 MB looks normal because I haven't entered much records but could not understood why the database become so large 1191 MB?The web interface that I am using to enter records create many connections to db to submit data. But it is required! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-26 : 14:54:38
|
Backup database and log file will be truncated.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-10-26 : 17:10:25
|
| Check the database recovery model by right-clicking on it and going to properties. If it is FULL, then you need to decide if point-in-time recovery is needed for this database. If it isn't, switch the recovery model to SIMPLE, and then shrink the transaction log (DBCC SHRINKFILE). If point-in-time recovery is needed, then you need start backing up your transaction log on a scheduled basis via BACKUP LOG. We backup ours every 15 minutes due to the criticality of the data. We get asked this same question multiple times per week, so if you don't understand any of what I have said, do some searching as we've explained it in greater detail in other threads.Peter, the log file does not get truncated when you backup the database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-27 : 02:09:47
|
I know  That would be my next step to explain.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
futureking
Starting Member
2 Posts |
Posted - 2008-10-27 : 02:30:16
|
quote:
Check the database recovery model by right-clicking on it and going to properties. If it is FULL, then you need to decide if point-in-time recovery is needed for this database. If it isn't, switch the recovery model to SIMPLE, and then shrink the transaction log (DBCC SHRINKFILE). If point-in-time recovery is needed, then you need start backing up your transaction log on a scheduled basis via BACKUP LOG. We backup ours every 15 minutes due to the criticality of the data.We get asked this same question multiple times per week, so if you don't understand any of what I have said, do some searching as we've explained it in greater detail in other threads.
THANK YOU VERY MUCH.TODAY I HAVE CREATED A DB IN MY SERVER. I am using shared hosting with 300MB of space for 1 DB.I noticed that the backup option is disabled when I connect to my web server db. Thank you very much for providing this useful information. If you write blog and have some time then please write a detailed article about it because many people have this question.I am very impressed with quick replies on this forum. Best of Luck. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-10-27 : 03:05:24
|
quote:
Thank you very much for providing this useful information. If you write blog and have some time then please write a detailed article about it because many people have this question.
It's in Books Online, it's on MSDN and tonnes of blog posts exist discussing.[url]http://www.sqlskills.com/blogs/paul/post/Search-Engine-QA-23-My-transaction-log-is-full-now-what.aspx[/url][url]http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/[/url][url]http://blogs.msdn.com/sqlblog/archive/2006/09/18/why-is-my-transaction-log-file-growing-rapidly-how-do-i-stop-it-from-eating-up-all-my-disk-space.aspx[/url][url]http://blogs.technet.com/beatrice/archive/2008/07/24/full-backups-transaction-logs-backup.aspx[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Db is 7 MB and Log is 1191 MB please help