Sage Crm-Need some advices
My problem is :
1) to backup the transaction logs without using mush disk space I would open
Query analyzer, select the database that I want to reduce the transaction log
size and type:
"BACKUP LOG MyDatabase WITH TRUNCATE_ONLY" How long would this take for
100GB approx??
2) to shrink the database I do the same a s step 1 except I use the
following command:
" DBCC SHRINKFILE ('MyDatabase_Log', 1000) " what do you recommend I should
shrink it to?
I don't want to loose any data in this process....so if I backup my 200mb
database before I do anything and then run the outlined commands on my 100GB
transaction log which has never been backed up before to reduce its size to
1gb am I going to loose data? Could my database grow to 100gb then?? I am
really confused now?
I am lost with this statement above. I am running Sage CRM as my application
and my database is 200MB. I am still unsure as to what the best size would be
to use with the DBCC SHRINKFILE command to shrink my 100gb ldf file down to??
Your help is greatly appreciated.Thanking You
You do need to set the current database to the target database before
running this command. The log needs to be sized for the update activity
between log backups so the proper size depends on your application. You can
still allow autogrow as a safety net. Since index builds are fully logged,
the log size should be at least 1.2 times the size of your largest table to
accommodate building the clustered index. You can always start large (e.g.
200 MB), monitor the space and gradually shrink the log size if you don't
want to waste space.
This database is small so you might consider just shrinking the log to 200MB
(same size as the db). You don't need to shrink it further unless you want
to save the disk space.